Sams Teach Yourself MySQL in 21 Days, Second Edition

Summary

In today's lesson, you learned that many things influence performance, from query and table design, to hardware and operating system choices. You looked at these things somewhat in isolation because any analysis has to concentrate on one thing at a time.

However, when trying to improve performance, it's much more difficult to take a single course of action and expect performance to get better. Taking the use of indexes as a case in point, the optimal configuration for one query may not be the best for all.

Most frustrating is that there's no one “right answer.” Your strategy needs to consider real-world scenarios and take into account a number of factors. Remember to measure the speed of your system before and after because this is likely ...