top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Mysql cache issues?

+1 vote
286 views

Could Mysql cache cause a performance penalty, when invalidating queries of a big Mysql cache zone?. I mean... I had a server with 16GB of cache memory and when a big table full update was done... a performance issue was suffered (seem not to be due to cache invalidation!!)... apparently this performance issue was much more notorious when the cache had been feeding some time and was near the top of the cache (arriving to 16GB) than when the query cache memory usage for example was much far more smaller... for example of 2GB ram... of cached content....

Does it exist any kind of explanation for this sensation?.

posted Jul 15, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Spot on. I tend to keep 200MB caches for some webservers, and that's already considered fairly large.

The qcache does lookups based on the EXACT query text, I presume by using a hash index; but that makes it highly inefficient at removing the cache entries for a particular table.

1 Answer

+1 vote
 
Best answer

Could Mysql cache cause a performance penalty, when invalidating queries of a big Mysql cache zone?

can, and *will* ... see also http://dom.as/tech/query-cache-tuner/ cache is locked while entries are being purged to prevent handing out cached results that may already be out-of-date, and the more active cache entries that need to be purged the longer it stays locked ...

answer Jul 15, 2013 by anonymous
Similar Questions
+3 votes

How can we implement an LRU cache using just a single container i.e. map or unordered_map?

Expected operations:
1. find(key_t) - find a certain value in cache
2. insert(key_t, value_t) - insert a new value to the cache

+4 votes

how to clear cache memory from browser using php?

+1 vote

My system is set to go directly to the OpenDNS name servers for DNS resolution. However, the results I get from "nslookup" differ from what I get if I query the same name server from another machine with the same resolv.conf settings.

That leads me to believe that DNS info is being cached locally somewhere. I don't have bind or nscd installed.

Where is this caching taking place and how can I clear/flush it?

...