December 2002
Beginner
640 pages
16h 41m
English
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 ...