>> MySQLTuner 1.2.0_1 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at [url]http://mysqltuner.com/[/url]
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.32-cll
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 11G (Tables: 19935)
[--] Data in InnoDB tables: 1G (Tables: 10064)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1M (Tables: 105)
[!!] Total fragmented tables: 1637
-------- Performance Metrics -------------------------------------------------
[--] Up for: 22m 9s (53K q [40.251 qps], 2K conn, TX: 266M, RX: 15M)
[--] Reads / Writes: 93% / 7%
[--] Total buffers: 2.5G global + 12.6M per thread (400 max threads)
[OK] Maximum possible memory usage: 7.5G (64% of installed RAM)
[OK] Slow queries: 0% (38/53K)
[OK] Highest usage of available connections: 2% (11/400)
[OK] Key buffer size / total MyISAM indexes: 384.0M/3.5G
[OK] Key buffer hit rate: 99.0% (1M cached / 11K reads)
[OK] Query cache efficiency: 32.2% (22K cached / 69K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (5 temp sorts / 2K sorts)
[!!] Joins performed without indexes: 1134
[OK] Temporary tables created on disk: 11% (456 on disk / 4K total)
[OK] Thread cache hit rate: 99% (11 created / 2K connections)
[OK] Table cache hit rate: 97% (1K open / 1K opened)
[OK] Open file limit used: 3% (1K/50K)
[OK] Table locks acquired immediately: 99% (32K immediate / 32K locks)
[OK] InnoDB data size / buffer pool: 1.9G/2.0G
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Adjust your join queries to always utilize indexes
Variables to adjust:
join_buffer_size (> 384.0K, or always use indexes with joins)