List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:July 15 2013 1:53pm
Subject:Re: Mysql cache issues???
View as plain text  
----- Original Message -----
> From: "Egoitz Aurrekoetxea" <egoitz@stripped>
> 
> 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.
Thread
Mysql cache issues???Egoitz Aurrekoetxea15 Jul
  • Re: Mysql cache issues???Johan De Meersman15 Jul
    • Re: Mysql cache issues???Egoitz Aurrekoetxea15 Jul
  • Re: Mysql cache issues???Hartmut Holzgraefe15 Jul
    • Re: Mysql cache issues???Reindl Harald15 Jul
      • Re: Mysql cache issues???shawn green15 Jul
        • Re: Mysql cache issues???Reindl Harald15 Jul
          • Re: Mysql cache issues???Egoitz Aurrekoetxea15 Jul
            • Re: Mysql cache issues???Reindl Harald15 Jul
            • Re: Mysql cache issues???shawn green15 Jul
              • Re: Mysql cache issues???Johan De Meersman16 Jul
                • RE: Mysql cache issues???Rick James22 Jul
                  • RE: Mysql cache issues???Johan De Meersman22 Jul
    • Re: Mysql cache issues???Johan De Meersman15 Jul