Проблема с MySQL

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

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 365M (Tables: 1073)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 1009K (Tables: 8)
[!!] Total fragmented tables: 48

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

-------- Performance Metrics -------------------------------------------------
[--] Up for: 8h 59m 9s (294K q [9.110 qps], 22K conn, TX: 7B, RX: 69M)
[--] Reads / Writes: 78% / 22%
[--] Total buffers: 120.0M global + 2.5M per thread (30 max threads)
[OK] Maximum possible memory usage: 195.0M (38% of installed RAM)
[OK] Slow queries: 0% (0/294K)
[OK] Highest usage of available connections: 13% (4/30)
[OK] Key buffer size / total MyISAM indexes: 32.0M/134.3M
[OK] Key buffer hit rate: 99.8% (6M cached / 13K reads)
[OK] Query cache efficiency: 53.6% (107K cached / 199K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 31K sorts)
[!!] Temporary tables created on disk: 31% (1K on disk / 3K total)
[OK] Thread cache hit rate: 99% (4 created / 22K connections)
[OK] Table cache hit rate: 66% (573 open / 868 opened)
[OK] Open file limit used: 25% (1K/4K)
[OK] Table locks acquired immediately: 99% (218K immediate / 218K 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
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
tmp_table_size (> 16M)
max_heap_table_size (> 16M)

[root@92 ~]#

Продюсер:
несколько дней спустя:

Продюсер:
[--] Up for: 8h 59m 9s (294K q [9.110 qps], 22K conn, TX: 7B, RX: 69M)

MarcusTven:
Кто-то перегрузил вам mysql сервер

query_cache_size (> 72M)