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
2441
July 22, 2005 04:28PM
4001
July 22, 2005 05:40PM
1660
July 23, 2005 12:14AM
1743
July 24, 2005 09:56AM
1495
July 24, 2005 12:46PM
1653
July 24, 2005 04:56PM
1719
July 25, 2005 10:47AM
1850
July 25, 2005 06:56PM
1808
July 26, 2005 12:36PM
1726
July 26, 2005 08:23PM
1613
July 26, 2005 10:53PM
1930
July 27, 2005 10:23AM
1687
July 30, 2005 12:07PM
1626
July 30, 2005 05:17PM
1609
July 27, 2005 10:28AM
1645
July 26, 2005 12:45PM
1767
July 26, 2005 08:45PM
1738
July 26, 2005 10:59PM
1781
July 25, 2005 04:30PM
1667
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.