>>  MySQLTuner 1.2.0 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
[OK] Logged in using credentials from debian maintenance account.

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.31-0+wheezy1
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1016M (Tables: 367)
[--] Data in InnoDB tables: 1G (Tables: 148)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 124K (Tables: 1)
[!!] Total fragmented tables: 189

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 5d 1h 38m 37s (22M q [51.820 qps], 1M conn, TX: 41B, RX: 4B)
[--] Reads / Writes: 75% / 25%
[--] Total buffers: 3.4G global + 12.4M per thread (151 max threads)
[OK] Maximum possible memory usage: 5.2G (33% of installed RAM)
[OK] Slow queries: 0% (0/22M)
[OK] Highest usage of available connections: 9% (14/151)
[OK] Key buffer size / total MyISAM indexes: 368.0M/419.5M
[OK] Key buffer hit rate: 100.0% (5B cached / 665K reads)
[OK] Query cache efficiency: 38.8% (6M cached / 15M selects)
[!!] Query cache prunes per day: 835993
[OK] Sorts requiring temporary tables: 0% (111 temp sorts / 2M sorts)
[!!] Joins performed without indexes: 244929
[!!] Temporary tables created on disk: 36% (819K on disk / 2M total)
[OK] Thread cache hit rate: 99% (14 created / 1M connections)
[OK] Table cache hit rate: 20% (687 open / 3K opened)
[OK] Open file limit used: 40% (889/2K)
[OK] Table locks acquired immediately: 99% (19M immediate / 19M locks)
[OK] InnoDB data size / buffer pool: 1.6G/2.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Enable the slow query log to troubleshoot bad queries
    Increasing the query_cache size over 128M may reduce performance
    Adjust your join queries to always utilize indexes
    Temporary table size is already large - reduce result set size
    Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
    query_cache_size (> 512M) [see warning above]
    join_buffer_size (> 128.0K, or always use indexes with joins)