View difference between Paste ID: nBrCnnUM and
SHOW:
|
|
- or go back to the newest paste.
| 1 | >> MySQLTuner 1.2.0 - Major Hayden <[email protected]> | |
| 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 |
