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.