Hudzilla.org - the homepage of Paul Hudson

18.2.19 Upgrade MySQL

This is NOT the latest copy of this book; click here for the latest version.

The developers of MySQL make big leaps forward with each release, and regularly address the issue of performance. MySQL 4 brought with it the new query cache, which stores the results of each of your SELECT queries in RAM. If the same query comes in again and the table hasn't changed, MySQL will simply load the result from RAM and return that - much, much quicker than having to perform the whole query from scratch.

If you do a lot of SELECT queries, and have queries that return the same results all the time or even some of the time, the query cache will raise your performance substantially.

<< 18.2.18 Normalisation		18.2.20 Increase your buffers >>
Table of Contents

Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.

My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!

A PHP User ;ls - 06 Sep 2008

thanks for the tutorial

Add comment
Please note that by posting a comment here you are committing it to the public domain. This is important so that others can make use of your code themselves, and also so that I can incorporate helpful notes directly into the main text. Comments are limited to 2000 characters in length.

If you are reporting an error in the content, please tell me directly.