Administrace komentářů

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.85
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 805M (Tables: 528)
[!!] Total fragmented tables: 19

-------- Performance Metrics -------------------------------------------------
[--] Up for: 7h 24m 1s (1M q [47.316 qps], 49K conn, TX: 2B, RX: 221M)
[--] Reads / Writes: 55% / 45%
[--] Total buffers: 827.0M global + 13.2M per thread (89 max threads)
[OK] Maximum possible memory usage: 2.0G (65% of installed RAM)
[OK] Slow queries: 0% (6/1M)
[OK] Highest usage of available connections: 31% (28/89)
[OK] Key buffer size / total MyISAM indexes: 777.0M/687.5M
[OK] Key buffer hit rate: 100.0% (882M cached / 366K reads)
[OK] Query cache efficiency: 57.1% (492K cached / 863K selects)
[!!] Query cache prunes per day: 85848
[OK] Sorts requiring temporary tables: 0% (68 temp sorts / 79K sorts)
[!!] Joins performed without indexes: 1401
[OK] Temporary tables created on disk: 5% (1K on disk / 32K total)
[OK] Thread cache hit rate: 99% (252 created / 49K connections)
[OK] Table cache hit rate: 52% (256 open / 488 opened)
[OK] Open file limit used: 4% (445/11K)
[OK] Table locks acquired immediately: 99% (881K immediate / 886K locks)

-------- 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
Variables to adjust:
    query_cache_size (> 24M)
    join_buffer_size (> 1.0M, or always use indexes with joins)