Question about the Query Cache and server settings
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....
Subject
Views
Written By
Posted
Question about the Query Cache and server settings
2466
July 22, 2005 04:28PM
4019
July 22, 2005 05:40PM
1671
July 23, 2005 12:14AM
1755
July 24, 2005 09:56AM
1510
July 24, 2005 12:46PM
1666
July 24, 2005 04:56PM
1730
July 25, 2005 10:47AM
1863
July 25, 2005 06:56PM
1820
July 26, 2005 12:36PM
1737
July 26, 2005 08:23PM
1623
July 26, 2005 10:53PM
1945
July 27, 2005 10:23AM
1695
July 30, 2005 12:07PM
1636
July 30, 2005 05:17PM
1620
July 27, 2005 10:28AM
1656
July 26, 2005 12:45PM
1775
July 26, 2005 08:45PM
1746
July 26, 2005 10:59PM
1795
July 25, 2005 04:30PM
1676
July 25, 2005 07:01PM
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.