Turning off the Query Cache works in Percona Server 5.1 , before MySQL Server 5.5

In a previous blog post I wrote that is not possible to completely turn off the Query Cache in MySQL before 5.5 .

Although, it is possible to completely turn off the Query Cache with Percona Server 5.1 .

MySQL bug #38551 reports that the change is incompatible with MySQL 5.1 . In this case the incompatibily is only related to how the server behaves: if Query Cache is disabled at startup it  cannot be enable at runtime. 

Thanks to Kenny Gryp from Percona for pointing this out and for the clarifications provided.

Comments

MySQL is a database. There are several versions but the main difference is some are open source (and free to use) and some cost money to use. In brief, it is similar to Oracle and other Enterprise class databases. There are 800 page books written about it so there is not way to explain it here. If you go to the link below you can download the Open Source versions of MySQL and documentation to get you started. You can run MySQL in windows but it is much more complicated than most programs you would run. MySQL is developed for, and runs best in, Linux.~Grace W. McMahan, taking CPR training Dallas

Grace W. McMahan
Sun, 05/20/2012 - 20:10

Works like a charm on my machine, thanks for this tutorial!phone number lookup

Irene
Tue, 11/29/2011 - 04:20

Reply

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.
Website by Digital Loom