gistfile1.txt

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
[--] Data in MyISAM tables: 0B (Tables: 9)
[--] Data in InnoDB tables: 11G (Tables: 1411)
[!!] Total fragmented tables: 173

-------- Performance Metrics -------------------------------------------------
[--] Up for: 30d 8h 1m 47s (61M q [23.355 qps], 151K conn, TX: 153B, RX: 20B)
[--] Reads / Writes: 40% / 60%
[--] Total buffers: 442.0M global + 12.4M per thread (151 max threads)
[OK] Maximum possible memory usage: 2.3G (56% of installed RAM)
[OK] Slow queries: 0% (413/61M)
[OK] Highest usage of available connections: 10% (16/151)
[OK] Key buffer size / total MyISAM indexes: 384.0M/112.0K
[OK] Key buffer hit rate: 100.0% (35K cached / 0 reads)
[OK] Query cache efficiency: 47.6% (12M cached / 26M selects)
[!!] Query cache prunes per day: 50966
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 397K sorts)
[OK] Temporary tables created on disk: 25% (14K on disk / 58K total)
[OK] Thread cache hit rate: 99% (16 created / 151K connections)
[!!] Table cache hit rate: 2% (504 open / 22K opened)
[OK] Open file limit used: 0% (0/65K)
[OK] Table locks acquired immediately: 99% (35M immediate / 35M locks)
[!!] InnoDB data size / buffer pool: 11.0G/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Enable the slow query log to troubleshoot bad queries
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    query_cache_size (> 32M)
    table_cache (> 512)
    innodb_buffer_pool_size (>= 11G)