Vrlo korisna perl skriptica koja Vam olaksava optimizaciju MySQL servera.
Klasicni output:
./mysqltuner.pl
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | MySQLTuner 1.0.0 - Major Hayden Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for additional options and output filtering -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.0.58-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 121M (Tables: 1024) [--] Data in InnoDB tables: 6M (Tables: 156) [--] Data in MEMORY tables: 0B (Tables: 1) [!!] Total fragmented tables: 8 -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 22h 18m 1s (1M q [9.310 qps], 147K conn, TX: 2B, RX: 300M) [--] Reads / Writes: 47% / 53% [--] Total buffers: 130.0M global + 4.6M per thread (200 max threads) [OK] Maximum possible memory usage: 1.0G (23% of installed RAM) [OK] Slow queries: 0% (39/1M) [OK] Highest usage of available connections: 33% (66/200) [!!] Key buffer size / total MyISAM indexes: 32.0M/55.0M [!!] Key buffer hit rate: 92.7% (10M cached / 741K reads) [OK] Query cache efficiency: 71.1% (477K cached / 670K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 36K sorts) [OK] Temporary tables created on disk: 13% (6K on disk / 47K total) [OK] Thread cache hit rate: 98% (1K created / 147K connections) [!!] Table cache hit rate: 17% (1K open / 8K opened) [OK] Open file limit used: 3% (2K/65K) [OK] Table locks acquired immediately: 99% (532K immediate / 532K locks) [OK] InnoDB data size / buffer pool: 6.6M/8.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Increase table_cache gradually to avoid file descriptor limits Variables to adjust: key_buffer_size (> 55.0M) table_cache (> 32662) |
Download: mysqltuner.pl
