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 ...
Get MySQL Cookbook, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.