gistfile1.txt

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 481M (Tables: 643)
[--] Data in InnoDB tables: 11M (Tables: 116)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 0B (Tables: 4)
[!!] Total fragmented tables: 136

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

-------- Performance Metrics -------------------------------------------------
[--] Up for: 8d 19h 20m 50s (94M q [123.916 qps], 1M conn, TX: 74B, RX: 5B)
[--] Reads / Writes: 77% / 23%
[--] Total buffers: 192.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 597.8M (15% of installed RAM)
[OK] Slow queries: 0% (1K/94M)
[OK] Highest usage of available connections: 68% (103/151)
[OK] Key buffer size / total MyISAM indexes: 16.0M/339.5M
[OK] Key buffer hit rate: 99.7% (436M cached / 1M reads)
[OK] Query cache efficiency: 77.6% (65M cached / 84M selects)
[!!] Query cache prunes per day: 495079
[OK] Sorts requiring temporary tables: 0% (4K temp sorts / 1M sorts)
[OK] Temporary tables created on disk: 11% (1K on disk / 15K total)
[OK] Thread cache hit rate: 99% (2K created / 1M connections)
[!!] Table cache hit rate: 5% (400 open / 7K opened)
[OK] Open file limit used: 54% (557/1K)
[OK] Table locks acquired immediately: 99% (26M immediate / 26M locks)
[!!] Connections aborted: 19%
[OK] InnoDB data size / buffer pool: 11.0M/128.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Increase table_cache gradually to avoid file descriptor limits
    Your applications are not closing MySQL connections properly
Variables to adjust:
    query_cache_size (> 16M)
    table_cache (> 400)