Ruglots MySQLTuner Results

mysqltuner.txt

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.30-30.1
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
[--] Data in MyISAM tables: 191M (Tables: 33)
[--] Data in InnoDB tables: 3G (Tables: 964)
[--] Data in MEMORY tables: 7M (Tables: 34)
[!!] Total fragmented tables: 965

-------- Security Recommendations  -------------------------------------------
ERROR 1142 (42000) at line 1: SELECT command denied to user 'ruglotsc_upgrade'@'localhost' for table 'user'
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 19d 12h 14m 18s (253M q [150.372 qps], 1M conn, TX: 644B, RX: 110B)
[--] Reads / Writes: 64% / 36%
[--] Total buffers: 9.0G global + 26.2M per thread (650 max threads)
[!!] Maximum possible memory usage: 25.6G (109% of installed RAM)
[OK] Slow queries: 0% (4K/253M)
[OK] Highest usage of available connections: 41% (271/650)
[OK] Key buffer size / total MyISAM indexes: 256.0M/36.0M
[OK] Key buffer hit rate: 100.0% (2B cached / 65K reads)
[OK] Query cache efficiency: 65.6% (132M cached / 201M selects)
[!!] Query cache prunes per day: 1097137
[OK] Sorts requiring temporary tables: 0% (1K temp sorts / 11M sorts)
[!!] Joins performed without indexes: 74808
[!!] Temporary tables created on disk: 26% (4M on disk / 17M total)
[OK] Thread cache hit rate: 99% (271 created / 1M connections)
[!!] Table cache hit rate: 3% (5K open / 190K opened)
[OK] Open file limit used: 1% (301/17K)
[OK] Table locks acquired immediately: 99% (171M immediate / 171M locks)
[OK] InnoDB data size / buffer pool: 3.9G/8.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Reduce your overall MySQL memory footprint for system stability
    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
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_size (> 256M) [see warning above]
    join_buffer_size (> 4.0M, or always use indexes with joins)
    table_cache (> 8192)