| 1 | >> MySQLTuner 1.1.1 - 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 | [!!] Successfully authenticated with no password - SECURITY RISK! |
|---|
| 5 | |
|---|
| 6 | -------- General Statistics -------------------------------------------------- |
|---|
| 7 | [--] Skipped version check for MySQLTuner script |
|---|
| 8 | [OK] Currently running supported MySQL version 5.5.12 |
|---|
| 9 | [OK] Operating on 32-bit architecture with less than 2GB RAM |
|---|
| 10 | |
|---|
| 11 | -------- Storage Engine Statistics ------------------------------------------- |
|---|
| 12 | [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster |
|---|
| 13 | [--] Data in MyISAM tables: 70M (Tables: 142) |
|---|
| 14 | [--] Data in InnoDB tables: 96K (Tables: 3) |
|---|
| 15 | [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) |
|---|
| 16 | [!!] Total fragmented tables: 8 |
|---|
| 17 | |
|---|
| 18 | -------- Security Recommendations ------------------------------------------- |
|---|
| 19 | [!!] User '@localhost' has no password set. |
|---|
| 20 | [!!] User '@mythtv' has no password set. |
|---|
| 21 | [!!] User 'root@127.0.0.1' has no password set. |
|---|
| 22 | [!!] User 'root@localhost' has no password set. |
|---|
| 23 | [!!] User 'root@mythtv' has no password set. |
|---|
| 24 | |
|---|
| 25 | -------- Performance Metrics ------------------------------------------------- |
|---|
| 26 | [--] Up for: 15m 30s (36K q [39.371 qps], 517 conn, TX: 30M, RX: 8M) |
|---|
| 27 | [--] Reads / Writes: 84% / 16% |
|---|
| 28 | [--] Total buffers: 176.0M global + 1.6M per thread (151 max threads) |
|---|
| 29 | [OK] Maximum possible memory usage: 411.9M (41% of installed RAM) |
|---|
| 30 | [OK] Slow queries: 0% (0/36K) |
|---|
| 31 | [OK] Highest usage of available connections: 7% (12/151) |
|---|
| 32 | [OK] Key buffer size / total MyISAM indexes: 16.0M/47.1M |
|---|
| 33 | [OK] Key buffer hit rate: 99.6% (982K cached / 3K reads) |
|---|
| 34 | [!!] Query cache is disabled |
|---|
| 35 | [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2K sorts) |
|---|
| 36 | [!!] Joins performed without indexes: 75 |
|---|
| 37 | [OK] Temporary tables created on disk: 20% (510 on disk / 2K total) |
|---|
| 38 | [!!] Thread cache is disabled |
|---|
| 39 | [!!] Table cache hit rate: 10% (64 open / 640 opened) |
|---|
| 40 | [OK] Open file limit used: 10% (109/1K) |
|---|
| 41 | [OK] Table locks acquired immediately: 99% (39K immediate / 39K locks) |
|---|
| 42 | [OK] InnoDB data size / buffer pool: 96.0K/128.0M |
|---|
| 43 | |
|---|
| 44 | -------- Recommendations ----------------------------------------------------- |
|---|
| 45 | General recommendations: |
|---|
| 46 | Run OPTIMIZE TABLE to defragment tables for better performance |
|---|
| 47 | MySQL started within last 24 hours - recommendations may be inaccurate |
|---|
| 48 | Enable the slow query log to troubleshoot bad queries |
|---|
| 49 | Adjust your join queries to always utilize indexes |
|---|
| 50 | Set thread_cache_size to 4 as a starting value |
|---|
| 51 | Increase table_cache gradually to avoid file descriptor limits |
|---|
| 52 | Variables to adjust: |
|---|
| 53 | query_cache_size (>= 8M) |
|---|
| 54 | join_buffer_size (> 128.0K, or always use indexes with joins) |
|---|
| 55 | thread_cache_size (start at 4) |
|---|
| 56 | table_cache (> 64) |
|---|
