Chapter 16. Advanced Server Features

A MySQL administrator is responsible for several aspects of a MySQL installation that have not been addressed by the previous chapters. These include optimizing the server for better performance and managing multiple servers (either on the same host or, in a replication setup, on different hosts). This chapter covers the following topics:

• How to obtain and interpret information that the mysqld server provides about its configuration and operation

• Setting server system variables to tune its performance

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

• Running multiple servers on a single host

• Replicating databases from one server to another

Questions on the material in this chapter make up approximately 15% of the exam.