>> MySQLTuner 1.1.1 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [!!] Successfully authenticated with no password - SECURITY RISK! -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.12 [OK] Operating on 32-bit architecture with less than 2GB RAM -------- Storage Engine Statistics ------------------------------------------- [--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 71M (Tables: 142) [--] Data in InnoDB tables: 96K (Tables: 3) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 18 -------- Security Recommendations ------------------------------------------- [!!] User '@localhost' has no password set. [!!] User '@mythtv' has no password set. [!!] User 'root@127.0.0.1' has no password set. [!!] User 'root@localhost' has no password set. [!!] User 'root@mythtv' has no password set. -------- Performance Metrics ------------------------------------------------- [--] Up for: 3h 57m 18s (189K q [13.305 qps], 2K conn, TX: 140M, RX: 50M) [--] Reads / Writes: 43% / 57% [--] Total buffers: 196.0M global + 1.8M per thread (151 max threads) [OK] Maximum possible memory usage: 469.7M (46% of installed RAM) [OK] Slow queries: 0% (0/189K) [OK] Highest usage of available connections: 11% (18/151) [OK] Key buffer size / total MyISAM indexes: 16.0M/48.3M [OK] Key buffer hit rate: 96.8% (2M cached / 82K reads) [OK] Query cache efficiency: 84.0% (124K cached / 148K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts) [!!] Joins performed without indexes: 98 [OK] Temporary tables created on disk: 1% (66 on disk / 3K total) [OK] Thread cache hit rate: 99% (18 created / 2K connections) [!!] Table cache hit rate: 3% (110 open / 2K opened) [OK] Open file limit used: 15% (161/1K) [OK] Table locks acquired immediately: 99% (76K immediate / 76K locks) [OK] InnoDB data size / buffer pool: 96.0K/128.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Adjust your join queries to always utilize indexes Increase table_cache gradually to avoid file descriptor limits Variables to adjust: join_buffer_size (> 384.0K, or always use indexes with joins) table_cache (> 192)