Public Pastes
SHARE
TWEET

Untitled

a guest Oct 10th, 2011 104 Never
  1. >>  MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net>
  2.  >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
  3.  >>  Run with '--help' for additional options and output filtering
  4. Please enter your MySQL administrative login:
  5. Please enter your MySQL administrative password:
  6.  
  7. -------- General Statistics --------------------------------------------------
  8. [--] Skipped version check for MySQLTuner script
  9. [OK] Currently running supported MySQL version 5.1.41-3ubuntu12.10
  10. [OK] Operating on 32-bit architecture with less than 2GB RAM
  11.  
  12. -------- Storage Engine Statistics -------------------------------------------
  13. [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
  14. [--] Data in MyISAM tables: 3G (Tables: 460)
  15. [--] Data in MEMORY tables: 252K (Tables: 2)
  16. [!!] InnoDB is enabled but isn't being used
  17. [!!] Total fragmented tables: 57
  18.  
  19. -------- Security Recommendations  -------------------------------------------
  20. [OK] All database users have passwords assigned
  21.  
  22. -------- Performance Metrics -------------------------------------------------
  23. [--] Up for: 1d 6h 9m 10s (2M q [23.336 qps], 127K conn, TX: 1B, RX: 1B)
  24. [--] Reads / Writes: 57% / 43%
  25. [--] Total buffers: 42.1M global + 1.0M per thread (151 max threads)
  26. [OK] Maximum possible memory usage: 193.1M (19% of installed RAM)
  27. [OK] Slow queries: 0% (764/2M)
  28. [OK] Highest usage of available connections: 27% (41/151)
  29. [!!] Key buffer size / total MyISAM indexes: 64.0K/1.8G
  30. [!!] Key buffer hit rate: 81.0% (80M cached / 15M reads)
  31. [OK] Query cache efficiency: 47.7% (777K cached / 1M selects)
  32. [!!] Query cache prunes per day: 22551
  33. [OK] Sorts requiring temporary tables: 1% (127 temp sorts / 11K sorts)
  34. [!!] Temporary tables created on disk: 43% (4K on disk / 10K total)
  35. [OK] Thread cache hit rate: 99% (95 created / 127K connections)
  36. [!!] Table cache hit rate: 0% (16 open / 320K opened)
  37. [OK] Open file limit used: 2% (29/1K)
  38. [OK] Table locks acquired immediately: 99% (2M immediate / 2M locks)
  39.  
  40. -------- Recommendations -----------------------------------------------------
  41. General recommendations:
  42.     Add skip-innodb to MySQL configuration to disable InnoDB
  43.     Run OPTIMIZE TABLE to defragment tables for better performance
  44.     Enable the slow query log to troubleshoot bad queries
  45.     When making adjustments, make tmp_table_size/max_heap_table_size equal
  46.     Reduce your SELECT DISTINCT queries without LIMIT clauses
  47.     Increase table_cache gradually to avoid file descriptor limits
  48. Variables to adjust:
  49.     key_buffer_size (> 1.8G)
  50.     query_cache_size (> 16M)
  51.     tmp_table_size (> 16M)
  52.     max_heap_table_size (> 16M)
  53.     table_cache (> 16)
  54.  
  55.  
RAW Paste Data
Top