----- Original Message ----- > From: "Egoitz Aurrekoetxea" <ego...@ramattack.net> > > Could Mysql cache cause a performance penalty, when invalidating > queries of a big Mysql cache zone?.
Yep, 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. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
