Chapter 39. Optimizing the Server

This chapter discusses how to gather performance information from MySQL Server and how to change its configuration to improve performance. The chapter covers the following exam topics:

• Obtaining and interpreting information that MySQL Server provides about its configuration and operation

• Assessing server load

• Setting server system variables for performance tuning

• Using the query cache to increase performance of queries that clients issue repeatedly