This chapter covers how to perform operations involved in administering a MySQL server:
General server configuration
The plug-in interface
Controlling server logging
Backup and recovery
The chapter doesn’t cover managing MySQL user accounts. That is an administrative task, but is covered in Chapter 23.
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
SUPER privilege. For this
reason, to carry out the operations described here, you’ll likely need
to connect to the server as
rather than as
You want to change the server settings, and also verify that your changes took effect.
To change settings, specify them at server startup or at runtime. To verify the changes, examine the relevant system variables at runtime.
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.
To configure the server at startup time, specify ...