Chapter 13: Configuring and Optimizing MySQL

Overview

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