| 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)
|
|---|
