MySQL Forums
Forum List  »  Performance

Question about the Query Cache and server settings
Posted by: Erin ONeill
Date: July 22, 2005 04:28PM

I've got some slow queries and they're a 3rd party software (forum software). I'm wondering if I could tweak my query cache some more to move some of these queries out of the slow query log (yup they appear over and over again, one in the THOUSANDS). I've got the O'Reilly book on optimization now and I'm not finding the answer...

Any suggestions on how to further tweak these?

here's the query vars:
query_alloc_block_size 8192
query_cache_limit 3145700
query_cache_size 134217728
query_cache_type ON
query_prealloc_size 8192

And here's what my query stats look like:
Questions 131295410
Qcache_queries_in_cache 9657
Qcache_inserts 21774443
Qcache_hits 65619535
Qcache_lowmem_prunes 3538685
Qcache_not_cached 1080088
Qcache_free_memory 13053192
Qcache_free_blocks 6579
Qcache_total_blocks 42480
Slow_queries 16584

And some other status stuff that may be relevant and helpful:
Com_unlock_tables 331031
Com_update 2247434
Connections 12084402
Created_tmp_disk_tables 348564
Created_tmp_tables 1406717
Created_tmp_files 1627
Threads_cached 89

Any suggestions? the key reads & writes are looking good so I feel like my key_buffer is set pretty darn spot on (384M).

OH! we have 4 GB of ram ....

thanks!
erin
ps. I'll post the results after the tweaks....

Options: ReplyQuote


Subject
Views
Written By
Posted
Question about the Query Cache and server settings
2441
July 22, 2005 04:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.