Previous Section  < Day Day Up >  Next Section

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.

    Previous Section  < Day Day Up >  Next Section