Created
May 27, 2011 05:06
-
-
Save arooni/994678 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -------- General Statistics -------------------------------------------------- | |
| [--] Skipped version check for MySQLTuner script | |
| [OK] Currently running supported MySQL version 5.1.41-3ubuntu12.10 | |
| [OK] Operating on 32-bit architecture with less than 2GB RAM | |
| -------- Storage Engine Statistics ------------------------------------------- | |
| [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster | |
| [--] Data in MyISAM tables: 7B (Tables: 1) | |
| [--] Data in InnoDB tables: 312M (Tables: 44) | |
| [!!] Total fragmented tables: 44 | |
| -------- Performance Metrics ------------------------------------------------- | |
| [--] Up for: 1d 2h 53m 3s (109K q [1.130 qps], 11K conn, TX: 414M, RX: 7M) | |
| [--] Reads / Writes: 43% / 57% | |
| [--] Total buffers: 58.0M global + 2.7M per thread (151 max threads) | |
| [OK] Maximum possible memory usage: 463.8M (65% of installed RAM) | |
| [OK] Slow queries: 0% (1/109K) | |
| [OK] Highest usage of available connections: 4% (7/151) | |
| [OK] Key buffer size / total MyISAM indexes: 16.0M/88.0K | |
| [OK] Query cache efficiency: 80.8% (32K cached / 39K selects) | |
| [OK] Query cache prunes per day: 0 | |
| [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 14 sorts) | |
| [!!] Temporary tables created on disk: 49% (28K on disk / 56K total) | |
| [OK] Thread cache hit rate: 99% (7 created / 11K connections) | |
| [!!] Table cache hit rate: 14% (64 open / 430 opened) | |
| [OK] Open file limit used: 4% (46/1K) | |
| [OK] Table locks acquired immediately: 100% (17K immediate / 17K locks) | |
| [!!] InnoDB data size / buffer pool: 312.5M/8.0M | |
| -------- Recommendations ----------------------------------------------------- | |
| General recommendations: | |
| Run OPTIMIZE TABLE to defragment tables for better performance | |
| Enable the slow query log to troubleshoot bad queries | |
| When making adjustments, make tmp_table_size/max_heap_table_size equal | |
| Reduce your SELECT DISTINCT queries without LIMIT clauses | |
| Increase table_cache gradually to avoid file descriptor limits | |
| Variables to adjust: | |
| tmp_table_size (> 16M) | |
| max_heap_table_size (> 16M) | |
| table_cache (> 64) | |
| innodb_buffer_pool_size (>= 312M) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
li25-146 /var/www: free -m
total used free shared buffers cached
Mem: 708 683 25 0 13 488
-/+ buffers/cache: 181 527
Swap: 255 5 250