Nitro212

Untitled

Jun 9th, 2013
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.02 KB | None | 0 0
  1.  
  2.  >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
  3.  >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
  4.  >>  Run with '--help' for additional options and output filtering
  5.  
  6. -------- General Statistics --------------------------------------------------
  7. [--] Skipped version check for MySQLTuner script
  8. [OK] Currently running supported MySQL version 5.5.30-cll
  9. [OK] Operating on 64-bit architecture
  10.  
  11. -------- Storage Engine Statistics -------------------------------------------
  12. [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
  13. [--] Data in MyISAM tables: 281M (Tables: 111)
  14. [--] Data in InnoDB tables: 208K (Tables: 13)
  15. [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
  16. [!!] Total fragmented tables: 15
  17.  
  18. -------- Security Recommendations  -------------------------------------------
  19. [OK] All database users have passwords assigned
  20.  
  21. -------- Performance Metrics -------------------------------------------------
  22. [--] Up for: 6m 25s (178K q [462.636 qps], 14K conn, TX: 67M, RX: 28M)
  23. [--] Reads / Writes: 62% / 38%
  24. [--] Total buffers: 168.0M global + 2.8M per thread (500 max threads)
  25. [OK] Maximum possible memory usage: 1.5G (4% of installed RAM)
  26. [OK] Slow queries: 0% (0/178K)
  27. [!!] Highest connection usage: 100%  (501/500)
  28. [!!] Key buffer size / total MyISAM indexes: 8.0M/225.7M
  29. [!!] Key buffer hit rate: 94.6% (62M cached / 3M reads)
  30. [!!] Query cache is disabled
  31. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 20K sorts)
  32. [!!] Temporary tables created on disk: 37% (6K on disk / 17K total)
  33. [!!] Thread cache is disabled
  34. [!!] Table cache hit rate: 0% (400 open / 82K opened)
  35. [OK] Open file limit used: 16% (417/2K)
  36. [!!] Table locks acquired immediately: 82%
  37. [OK] InnoDB data size / buffer pool: 208.0K/128.0M
  38.  
  39. -------- Recommendations -----------------------------------------------------
  40. General recommendations:
  41.     Run OPTIMIZE TABLE to defragment tables for better performance
  42.     MySQL started within last 24 hours - recommendations may be inaccurate
  43.     Reduce or eliminate persistent connections to reduce connection usage
  44.     When making adjustments, make tmp_table_size/max_heap_table_size equal
  45.     Reduce your SELECT DISTINCT queries without LIMIT clauses
  46.     Set thread_cache_size to 4 as a starting value
  47.     Increase table_cache gradually to avoid file descriptor limits
  48.     Optimize queries and/or use InnoDB to reduce lock wait
  49. Variables to adjust:
  50.     max_connections (> 500)
  51.     wait_timeout (< 28800)
  52.     interactive_timeout (< 28800)
  53.     key_buffer_size (> 225.7M)
  54.     query_cache_size (>= 8M)
  55.     tmp_table_size (> 16M)
  56.     max_heap_table_size (> 16M)
  57.     thread_cache_size (start at 4)
  58.     table_cache (> 400)
Advertisement
Add Comment
Please, Sign In to add comment