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

Good afternoon,

Could Mysql cache cause a performance penalty, when invalidating
queries of a big Mysql cache zone?. I mean... I had a server with 16GB
of cache memory and when a big table full update was done... a
performance issue was suffered (seem not to be due to cache
invalidation!!)... apparently this performance issue was much more
notorious when the cache had been feeding some time and was near the
top of the cache (arriving to 16GB) than when the query cache memory
usage for example was much far more smaller... for example of 2GB
ram... of cached content....

Does it exist any kind of explanation for this sensation?.

Best regards,
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (GNU/Linux)

iQEcBAEBAgAGBQJR4/mUAAoJEG0sn91fOssvDmsH/jCRp5yY05S6uI5dVoiKOG/m
pnwbqH3MyE8V283UTAzskHuQKJZ5FTtgco5FdZHomjNEzW9ZL4Kw3HD/Ed53awPQ
cO+7AtMd91QCagXt6IszGvG6ANsru/P8zb+u8SS6WENDrQgLCfTIcjKLQ2EIJfHn
5mTDf1SplaPdhnJoSbpXYfJVT0GGv1I2z36D3l0eTEwN0eUdjNVe1LUpJGOJNP77
DjpzljMn4iBjxfseiKyJ2SnvKg2kQYfSBYFL8PzlIy2ICfwGLZ5tMprLTKBWCMWw
ICXbkz8M0CMFFeDOz4Vb8+PHUHk6Q29698Bo2s0UmXUxGStKDcwvq773I8rBccs=
=W3Jp
-----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