You can only really claim to understand MySQL if you grasp the intricacies of the mysqld variables and how they impact MySQL's performance. This chapter shows you how to configure and optimize MySQL by explaining how to set the variables and what to look for if you need a boost in performance.
Featured in this chapter:
The mysqld options and variables
A detailed look optimizing the table_cache, key_buffer_size, delayed_queue, back_log, and sort_buffer variables.
Handling more connections
Changing the variables without restarting the server.
Configuring InnoDB tables
Making hardware improvements
Running benchmarks
Running MySQL in ANSI mode
Using different languages and character sets