Estou enfrentando um problema de extrema lentidão no fórum, o acesso a página inicial é normal... mas ao tentar abrir algum tópico está levando cerca de 30segundos
segue o meu config do mysql
segue o mysqltuner.pl
>> 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
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.32-cll
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 614M (Tables: 2376)
[--] Data in InnoDB tables: 841M (Tables: 778)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 248K (Tables: 66)
[!!] Total fragmented tables: 40
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 16m 22s (51K q [52.142 qps], 2K conn, TX: 1B, RX: 25M)
[--] Reads / Writes: 81% / 19%
[--] Total buffers: 6.6G global + 3.6M per thread (500 max threads)
[OK] Maximum possible memory usage: 8.4G (26% of installed RAM)
[OK] Slow queries: 0% (0/51K)
[OK] Highest usage of available connections: 4% (20/500)
[OK] Key buffer size / total MyISAM indexes: 512.0M/505.8M
[!!] Key buffer hit rate: 94.7% (98K cached / 5K reads)
[OK] Query cache efficiency: 62.8% (23K cached / 37K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (1 temp sorts / 2K sorts)
[!!] Joins performed without indexes: 8
[OK] Temporary tables created on disk: 21% (345 on disk / 1K total)
[OK] Thread cache hit rate: 99% (20 created / 2K connections)
[!!] Table cache hit rate: 19% (3K open / 16K opened)
[OK] Open file limit used: 48% (4K/9K)
[OK] Table locks acquired immediately: 99% (39K immediate / 39K locks)
[OK] InnoDB data size / buffer pool: 841.4M/6.0G
-------- 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
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
join_buffer_size (> 1.0M, or always use indexes with joins)
table_cache (> 4096)