How to solve the problem in very high value of Opened vs Open Tables?
Basic InformationAugust 08, 2007, 02:46:34 AM
Operating System: Microsoft Windows XP [Version 5.1.2600]
Processor: x86 Family 15 Model 4 Stepping 1 GenuineIntel ~3000 Mhz,[02]: x86 Family 15 Model 4 Stepping 1 GenuineIntel (~3000MHz)
Current processes: 52 (52 running, 0 zombie)
Processes by CPU: System Idle Process (1) 97.5%, WINWORD.EXE (1) 1.8%, (other) (42) 0.7%
Memory usage: 69.781% (359424k / 515072k)
Swap: 179.968% (1140736k / 633856k)
MySQL StatisticsMySQL 5.0.x
Connections per second: 0.0195
Kilobytes received per second: 0.1366
Kilobytes sent per second: 1.3672
Queries per second: 0.6026
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache) 1361.4848 (should be <= 80)Table cache usage:
(table_cache) 0.043 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size) 0.0128 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 0.1226 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 9807.8333 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 0.2 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 0.7783 (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.4307 (should be <= 0.5)
Query cache prune rate:
(query_cache_size) 0 (should be <= 0.05)
STATUSPHPINFODedicated Host Server.
thanks