Guys, My server's CPU is getting hammered and I was wondering if someone might provide some insight into my query caching The cache size is currently 32mb Qcache_free_blocks 42 ----------------------------------- Qcache_free_memory 21952888 ----------------------------------- Qcache_hits 66444045 ----------------------------------- Qcache_inserts 23278553 ----------------------------------- Qcache_lowmem_prunes 240535 ----------------------------------- Qcache_not_cached 496730 ----------------------------------- Qcache_queries_in_cache 10365 ----------------------------------- Qcache_total_block 20907 Code (markup): My server has 1 gig (Plesk shows 2.6 gigs, so I may be mistaken), and I'm wondering if it is safe to increase the query cache size, and if it is advisable to do so. Also, if someone could point me to some easy to understand MYSQL optimization guides, I would be grateful
Hi fordP The data for your query cache doesn't look too bad to me. Maybe the reason for the CPU thrash is elsewhere. Download the MySQL Performance Tuning Primer Script from http://www.day32.com/MySQL/ and run it against your server. It may highlight other resource issues that would cause a CPU thrash. Also, is this server dedicated to MySQL or is it shared, and is it a real server or virtual? Petey