List:General Discussion« Previous MessageNext Message »
From:Hartmut Holzgraefe Date:July 15 2013 2:00pm
Subject:Re: Mysql cache issues???
View as plain text  
On 15.07.2013 15:31, Egoitz Aurrekoetxea wrote:
> 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 ...


-- 
Hartmut Holzgraefe <hartmut@stripped>
Principal Support Engineer (EMEA)
SkySQL AB - http://www.skysql.com/
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