>> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net> >> 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:
-------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.16-log [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: 7B (Tables: 2) [--] Data in InnoDB tables: 184M (Tables: 7) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 5
-------- Security Recommendations ------------------------------------------- [!!] User '@even.example.com' has no password set. [!!] User '@localhost' has no password set. [!!] User 'root@127.0.0.1' has no password set. [!!] User 'root@::1' has no password set. [!!] User 'root@even.example.com' has no password set.
-------- Performance Metrics ------------------------------------------------- [--] Up for: 10s (9 q [0.900 qps], 6 conn, TX: 10K, RX: 625) [--] Reads / Writes: 100% / 0% [--] Total buffers: 176.0M global + 1.6M per thread (151 max threads) [OK] Maximum possible memory usage: 411.9M (38% of installed RAM) [OK] Slow queries: 0% (0/9) [OK] Highest usage of available connections: 0% (1/151) [OK] Key buffer size / total MyISAM indexes: 16.0M/98.0K [!!] Query cache is disabled [OK] Temporary tables created on disk: 0% (0 on disk / 2 total) [!!] Thread cache is disabled [OK] Table cache hit rate: 78% (26 open / 33 opened) [OK] Open file limit used: 2% (21/1K) [OK] Table locks acquired immediately: 100% (36 immediate / 36 locks) [!!] Connections aborted: 16% [!!] InnoDB data size / buffer pool: 184.8M/128.0M
-------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Set thread_cache_size to 4 as a starting value Your applications are not closing MySQL connections properly Variables to adjust: query_cache_size (>= 8M) thread_cache_size (start at 4) innodb_buffer_pool_size (>= 184M)