Day 18. Optimizing Performance
By now you should have learned how to design and build MySQL database applications that serve a variety of different requirements. However, so far you have spent only a little time here and there considering database performance.
In today's lesson, you will focus on attaining the goal of high performance. You will look at the various things that influence it, so that at the end of the lesson you have some techniques for running MySQL with far greater efficiency, even in high-load, performance-critical situations.
In particular, you will learn:
The principal factors that influence performance
How to improve your table designs to speed up database access
How to write applications that run faster
How to use MySQL's performance ...
Get Sams Teach Yourself MySQL in 21 Days, Second Edition 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.
