>> MySQLTuner 1.4.0 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 5.1.73-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +CSV +InnoDB +MRG_MYISAM [--] Data in MyISAM tables: 22M (Tables: 40) [!!] InnoDB is enabled but isn't being used [!!] Total fragmented tables: 1 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 2m 19s (18K q [134.266 qps], 1K conn, TX: 807M, RX: 1M) [--] Reads / Writes: 77% / 23% [--] Total buffers: 1.5G global + 26.4M per thread (2000 max threads) [!!] Maximum possible memory usage: 53.0G (341% of installed RAM) [OK] Slow queries: 0% (0/18K) [OK] Highest usage of available connections: 1% (22/2000) [OK] Key buffer size / total MyISAM indexes: 384.0M/2.3M [!!] Key buffer hit rate: 93.6% (730 cached / 47 reads) [!!] Query cache efficiency: 7.7% (357 cached / 4K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 10 sorts) [OK] Temporary tables created on disk: 0% (0 on disk / 3K total) [OK] Thread cache hit rate: 95% (81 created / 1K connections) [OK] Table cache hit rate: 90% (64 open / 71 opened) [OK] Open file limit used: 1% (100/10K) [!!] Table locks acquired immediately: 59% -------- Recommendations ----------------------------------------------------- General recommendations: Add skip-innodb to MySQL configuration to disable InnoDB Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Reduce your overall MySQL memory footprint for system stability Optimize queries and/or use InnoDB to reduce lock wait Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_limit (> 1M, or use smaller result sets)