MySQL Query-Cache Reset

Hi, I’m the administrador of a MySQL Server, it have lot’s of queries, and now it’s getting high load of processor, I try to increase the size of MySQL Query Cache, but if I put more than 128 Mb the cache it’s reseting all the time and the performance is worst. The server have 1,2 Mb of RAM and I

Re: MySQL Query-Cache Reset

Hello. In my opinion, your status variables are not so bad-looking. About a half of your queries are taken from the cache and the Key_reads/Key_read_requests ratio is less than 1%. Check that the system doesn't start swapping with high value of Query Cache size. If you run lots of queries