>>  MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
 >>  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: 70M (Tables: 142)
[--] Data in InnoDB tables: 96K (Tables: 3)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 8

-------- 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: 15m 30s (36K q [39.371 qps], 517 conn, TX: 30M, RX: 8M)
[--] Reads / Writes: 84% / 16%
[--] Total buffers: 176.0M global + 1.6M per thread (151 max threads)
[OK] Maximum possible memory usage: 411.9M (41% of installed RAM)
[OK] Slow queries: 0% (0/36K)
[OK] Highest usage of available connections: 7% (12/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/47.1M
[OK] Key buffer hit rate: 99.6% (982K cached / 3K reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2K sorts)
[!!] Joins performed without indexes: 75
[OK] Temporary tables created on disk: 20% (510 on disk / 2K total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 10% (64 open / 640 opened)
[OK] Open file limit used: 10% (109/1K)
[OK] Table locks acquired immediately: 99% (39K immediate / 39K 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
    Set thread_cache_size to 4 as a starting value
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    query_cache_size (>= 8M)
    join_buffer_size (> 128.0K, or always use indexes with joins)
    thread_cache_size (start at 4)
    table_cache (> 64)