List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:July 15 2013 2:28pm
Subject:Re: Mysql cache issues???
View as plain text  

Am 15.07.2013 16:00, schrieb Hartmut Holzgraefe:
> 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/

Optimal size for your query cache: 0

thats ridiculous

> 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 ...

but in most cases the benefit outbeats this overhead massive
since you have more read than write

[OK] Query cache efficiency: 93.6% (40M cached / 42M selects)
nobody can tell me that all these 40M queries would have been
faster without cache by reduce the overhead


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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