کد PHP:
-------- Performance Metrics -------------------------------------------------
[--] Up for: 17h 47m 9s (96M q [1K qps], 10M conn, TX: 235B, RX: 17B)
[--] Reads / Writes: 79% / 21%
[--] Total buffers: 10.9G global + 12.4M per thread (1000 max threads)
[OK] Maximum possible memory usage: 23.0G (75% of installed RAM)
[OK] Slow queries: 0% (5/96M)
[OK] Highest usage of available connections: 79% (797/1000)
[OK] Key buffer size / total MyISAM indexes: 512.0M/44.1M
[OK] Key buffer hit rate: 100.0% (631M cached / 5K reads)
[OK] Query cache efficiency: 41.1% (30M cached / 74M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (9 temp sorts / 1M sorts)
[!!] Temporary tables created on disk: 50% (1M on disk / 2M total)
[OK] Thread cache hit rate: 90% (1M created / 10M connections)
[OK] Table cache hit rate: 59% (2K open / 3K opened)
[OK] Open file limit used: 32% (1K/5K)
[OK] Table locks acquired immediately: 97% (63M immediate / 64M locks)
[OK] InnoDB data size / buffer pool: 544.0K/128.0M
-------- 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)