Chapter 8. Database Optimization
There have probably been tens of thousands of pages written on the subject of database optimization, a good portion of them relating to MySQL. In one chapter of this book, we will never be able to cover the entire breadth of this subject.
Instead we will focus on what is relevant to you as a PHP programmer, and see if we can provide some tools and rules of thumb that make sure that you can deal with the basics, and not create any problems of performance with your application that may require expensive surgery at a later date to rectify.
In this chapter, we will learn about how MySQL uses memory, and show you a tool that allows you to optimize the configuration of your MySQL server to maximize its performance. We ...