Problem

Started by edi67, October 07, 2005, 02:28:48 AM

Previous topic - Next topic

edi67

i checked Status.php in my forum and i had these results:

QuoteMySQL Statistics
MySQL 4.1.x
Connections per second:  13.2996 
Kilobytes received per second:  0.5818 
Kilobytes sent per second:  0.322 
Queries per second:  297.7746 
Percentage of slow queries:  0 
Opened vs. Open tables:
(table_cache)  9653.6528 (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.0434 (should be <= 0.01) 
Key buffer write hit rate:
(key_buffer_size)  0.2679 (should be <= 0.5) 
Thread cache hit rate:
(thread_cache_size)  131.9915 (should be >= 30 ) 
Thread cache usage:
(thread_cache_size)  0.6875 (should be >= 0.7 and <= 0.9) 
Temporary table disk usage:
(tmp_table_size)  0.2023 (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.0545 (should be <= 0.1) 
Query cache prune rate:
(query_cache_size)  0.4374 (should be <= 0.05) 

i think this is very big: Opened vs. Open tables: (table_cache)  9653.6528 (should be <= 80) 

there is some solution for have more performances and have results more better?
CrazyZone - My SMF Forum


From the difficult the hardening of the man you can see

Elmacik

in my local forum, none of them has the "should" values :S
Home of Elmacik

Advertisement: