| 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: 71M (Tables: 142)
|
|---|
| 14 | [--] Data in InnoDB tables: 96K (Tables: 3)
|
|---|
| 15 | [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
|
|---|
| 16 | [!!] Total fragmented tables: 18
|
|---|
| 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: 3h 57m 18s (189K q [13.305 qps], 2K conn, TX: 140M, RX: 50M)
|
|---|
| 27 | [--] Reads / Writes: 43% / 57%
|
|---|
| 28 | [--] Total buffers: 196.0M global + 1.8M per thread (151 max threads)
|
|---|
| 29 | [OK] Maximum possible memory usage: 469.7M (46% of installed RAM)
|
|---|
| 30 | [OK] Slow queries: 0% (0/189K)
|
|---|
| 31 | [OK] Highest usage of available connections: 11% (18/151)
|
|---|
| 32 | [OK] Key buffer size / total MyISAM indexes: 16.0M/48.3M
|
|---|
| 33 | [OK] Key buffer hit rate: 96.8% (2M cached / 82K reads)
|
|---|
| 34 | [OK] Query cache efficiency: 84.0% (124K cached / 148K selects)
|
|---|
| 35 | [OK] Query cache prunes per day: 0
|
|---|
| 36 | [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)
|
|---|
| 37 | [!!] Joins performed without indexes: 98
|
|---|
| 38 | [OK] Temporary tables created on disk: 1% (66 on disk / 3K total)
|
|---|
| 39 | [OK] Thread cache hit rate: 99% (18 created / 2K connections)
|
|---|
| 40 | [!!] Table cache hit rate: 3% (110 open / 2K opened)
|
|---|
| 41 | [OK] Open file limit used: 15% (161/1K)
|
|---|
| 42 | [OK] Table locks acquired immediately: 99% (76K immediate / 76K locks)
|
|---|
| 43 | [OK] InnoDB data size / buffer pool: 96.0K/128.0M
|
|---|
| 44 |
|
|---|
| 45 | -------- Recommendations -----------------------------------------------------
|
|---|
| 46 | General recommendations:
|
|---|
| 47 | Run OPTIMIZE TABLE to defragment tables for better performance
|
|---|
| 48 | MySQL started within last 24 hours - recommendations may be inaccurate
|
|---|
| 49 | Enable the slow query log to troubleshoot bad queries
|
|---|
| 50 | Adjust your join queries to always utilize indexes
|
|---|
| 51 | Increase table_cache gradually to avoid file descriptor limits
|
|---|
| 52 | Variables to adjust:
|
|---|
| 53 | join_buffer_size (> 384.0K, or always use indexes with joins)
|
|---|
| 54 | table_cache (> 192)
|
|---|
| 55 |
|
|---|
| 56 |
|
|---|
