It's is running slow again atm:
Operating System: Linux 2.6.32-042stab053.5
Processor: Intel® Xeon® CPU L5520 @ 2.27GHz (376.838MHz)
Load averages: 9.81, 4.00, 3.55
Current processes: 95 (86 sleeping, 8 running, 1 zombie)
Processes by CPU: apache2 (66) 77.6%, mysqld (1) 4.7%, (other) (21) 0.0%
Memory usage: 87.573% (1836532k / 2097152k)
Swap: 0% (0k / 0k)
MySQL processes
Total processes: 25 (24 sleeping, 1 running, 0 locked)
MySQL Statistics
MySQL 5.0.x
Connections per second: 2.6235
Kilobytes received per second: 7.8861
Kilobytes sent per second: 39.5593
Queries per second: 35.3815
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache) 1336.4844 (should be <= 80)
Table cache usage:
(table_cache) 1 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size) 0.0044 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 0.0919 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 76.2202 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 0.375 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 0.0199 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer) 0 (should be <= 0.001)
Query cache enabled:
(query_cache_type) 1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit) 0.428 (should be <= 0.5)
Query cache prune rate:
(query_cache_size) 0.0746 (should be <= 0.05)
