Excessive resources problem

Started by ormuzra, January 25, 2006, 09:57:05 PM

Previous topic - Next topic

ormuzra

Hi

I have a problem, mi server spend excessive resources, actually y read other post and i did everything from this topic http://www.simplemachines.org/community/index.php?topic=49999.0 but i still have the problem

Mi status.php is that

Connections per second:    12.7573    
Kilobytes received per second:    0    
Kilobytes sent per second:    0    
Queries per second:    365.3245    
Percentage of slow queries:    0    
Opened vs. Open tables:
(table_cache)    0 (should be <= 80)    
Table cache usage:
(table_cache)    1 (should be >= 0.5 and <= 0.9)    (problem)
Key buffer read hit rate:
(key_buffer_size)    0.005 (should be <= 0.01)    
Key buffer write hit rate:
(key_buffer_size)    0.1648 (should be <= 0.5)    
Thread cache hit rate:
(thread_cache_size)    480.6388 (should be >= 30 )    
Thread cache usage:
(thread_cache_size)    0.7813 (should be >= 0.7 and <= 0.9)    
Temporary table disk usage:
(tmp_table_size)    0 (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)    8740830 (should be <= 0.1)    (problem)
Query cache prune rate:
(query_cache_size)    3211775 (should be <= 0.05)       (problem)

the indicated problems (problem) item are the only ones, any idea??

(sorry for my english)

Ben_S

Liverpool FC Forum with 14 million+ posts.

Advertisement: