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 ...
Get Pro PHP Application Performance Tuning PHP Web Projects for Maximum Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
