Advertisement
Guest User

Untitled

a guest
Sep 28th, 2015
59
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -------------------------------------------------------------
  2. System MySQL monitoring stats
  3. mysqlmymonlite.sh - 0.5.4 WHM mysqlmymon.com
  4. compiled by George Liu (eva2000) vbtechsupport.com
  5. -------------------------------------------------------------
  6.  
  7. Report Generated:
  8. Mon Sep 28 10:41:56 UTC 2015
  9.  
  10. -------------------------------------------------
  11. mysqltuner output
  12. -------------------------------------------------
  13. mysqltuner.pl [found]
  14.  
  15. >> MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net>
  16. >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
  17. >> Run with '--help' for additional options and output filtering
  18. [OK] Currently running supported MySQL version 5.5.42-cll
  19. [OK] Operating on 64-bit architecture
  20.  
  21. -------- Storage Engine Statistics -------------------------------------------
  22. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
  23. [--] Data in MyISAM tables: 3G (Tables: 8938)
  24. [--] Data in MRG_MYISAM tables: 19M (Tables: 3)
  25. [--] Data in InnoDB tables: 675M (Tables: 4648)
  26. [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
  27. [--] Data in MEMORY tables: 95M (Tables: 38)
  28. [!!] Total fragmented tables: 792
  29.  
  30. -------- Security Recommendations -------------------------------------------
  31. [OK] All database users have passwords assigned
  32.  
  33. -------- Performance Metrics -------------------------------------------------
  34. [--] Up for: 21h 24m 50s (6M q [80.359 qps], 297K conn, TX: 303B, RX: 1B)
  35. [--] Reads / Writes: 75% / 25%
  36. [--] Total buffers: 2.5G global + 34.5M per thread (200 max threads)
  37. [OK] Maximum possible memory usage: 9.2G (54% of installed RAM)
  38. [OK] Slow queries: 0% (10K/6M)
  39. [OK] Highest usage of available connections: 32% (64/200)
  40. [!!] Key buffer size / total MyISAM indexes: 0B/1.2G
  41. [!!] Key buffer hit rate: 0.0% (74M cached / 74M reads)
  42. [OK] Query cache efficiency: 68.3% (2M cached / 4M selects)
  43. [!!] Query cache prunes per day: 237099
  44. [OK] Sorts requiring temporary tables: 1% (4K temp sorts / 282K sorts)
  45. [!!] Joins performed without indexes: 39544
  46. [!!] Temporary tables created on disk: 31% (177K on disk / 557K total)
  47. [OK] Thread cache hit rate: 99% (883 created / 297K connections)
  48. [!!] Table cache hit rate: 0% (728 open / 3M opened)
  49. [OK] Open file limit used: 2% (1K/43K)
  50. [OK] Table locks acquired immediately: 99% (2M immediate / 2M locks)
  51. [OK] InnoDB buffer pool / data size: 760.0M/675.7M
  52. [OK] InnoDB log waits: 0
  53. -------- Recommendations -----------------------------------------------------
  54. General recommendations:
  55. Run OPTIMIZE TABLE to defragment tables for better performance
  56. MySQL started within last 24 hours - recommendations may be inaccurate
  57. Increasing the query_cache size over 128M may reduce performance
  58. Adjust your join queries to always utilize indexes
  59. Temporary table size is already large - reduce result set size
  60. Reduce your SELECT DISTINCT queries without LIMIT clauses
  61. Increase table_cache gradually to avoid file descriptor limits
  62. Read this before increasing table_cache over 64: http://bit.ly/1mi7c4C
  63. Variables to adjust:
  64. key_buffer_size (> 1.2G)
  65. query_cache_size (> 768M) [see warning above]
  66. join_buffer_size (> 16.0M, or always use indexes with joins)
  67. table_cache (> 728)
  68.  
  69.  
  70. Report Complete:
  71. Mon Sep 28 10:42:08 UTC 2015
  72. ----------------------------
Advertisement
RAW Paste Data Copied
Advertisement