Factors Affecting Performance
The performance of your system will be affected by a number of factors. Here are the main factors, roughly in order of impact:
How your columns and tables are defined, and what table types they have
How your application uses MySQL
How your application runs its queries and how the MySQL optimizer processes them
The MySQL system variables
Your operating system and hardware
How mysqld is compiled
We will go through these factors in turn. This should enable you to get a good grasp of them, and you will learn what you can do in each respect to improve performance.
Whatever tactics you may come to use, always run benchmark tests to measure the impact of any change. Carry out timings before and after any adjustment. You will ...
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.
