MySQL Cookbook, 3rd Edition

Chapter 22. Server Administration

Introduction

This chapter covers how to perform operations involved in administering a MySQL server:

• General server configuration

• The plug-in interface

• Controlling server logging

• Server monitoring

• Backup and recovery

The chapter doesn’t cover managing MySQL user accounts. That is an administrative task, but is covered in Chapter 23.

Note

Many of the techniques shown here require administrative access, such as the ability to modify tables in the mysql system database or use statements that require the SUPER privilege. For this reason, to carry out the operations described here, you’ll likely need to connect to the server as root rather than as cbuser.

Configuring the Server

Problem

You want to change the server settings, and also verify that your changes took effect.

Solution

To change settings, specify them at server startup or at runtime. To verify the changes, examine the relevant system variables at runtime.

Discussion

The MySQL server places many configuration parameters under your control. For example, resources that require memory can be adjusted up or down to tailor resource usage. A heavily used server requires more memory; a lightly used one, less. You can set command options and system variables at server startup, and many system variables are settable at runtime as well. You can also examine your settings at runtime to verify that the configuration is as you intend.

Configuration control at server startup

To configure the server at startup time, specify ...