-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 15/07/13 15:53, Johan De Meersman wrote: > ----- Original Message ----- >> From: "Egoitz Aurrekoetxea" <ego...@ramattack.net> >> >> 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----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
