List:General Discussion« Previous MessageNext Message »
From:Egoitz Aurrekoetxea Date:July 15 2013 2:05pm
Subject:Re: Mysql cache issues???
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 15/07/13 15:53, Johan De Meersman wrote:
> ----- 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.
> 
> 
> 
And which is the measure unit for considering a cache large??¿
normally having cached queries... mainly when are very expensive (in
resource terms, disk access or so....) that should help always!!
unless that's what I've seen sometimes now.... so.... could you know
when is considered counterproductive?... which table structures...
keys or so??
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (GNU/Linux)

iQEcBAEBAgAGBQJR5AG5AAoJEG0sn91fOssvl/wH/1lRTzEtpwY86KtZUtyI/cIe
Kj5laF/CJe94Rst6LkfrmGZBnNBPkYwc6HFQ0a618JfGUOybpdFxGqFmZElX4WpT
yKbM7YEzDGCGHjnZjgKV/4lFAhCg3CfTZ57NDzLl3D5wFijneCgkGOhM3x4zPhH8
66twuWBWbpIK+2a8bQmmK+v3/dmkQIMWGW7aKlmhLvb1kw77Fsbt7+vySNYhAdqd
kMART0b0uLcMjS+DfxXh+tQt19BoI2TIJcc51MQVYZokOU13QYmsQTFwt6mAAC/5
rMuCGF74c9zkil6aau0AbCsNramWW+IbjQsNLPylVUxt0gyiJU8TXcWgB3yG0hY=
=kaR1
-----END PGP SIGNATURE-----
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