This documentation is for an older version. If you're using the most current version, select the documentation for that version with the version switch in the upper right corner of the online documentation, or by downloading a newer PDF or EPUB file.

Chapter 5 MySQL Server Administration

Table of Contents

5.1 The MySQL Server
5.1.1 Server Option and Variable Reference
5.1.2 Server Configuration Defaults
5.1.3 Server Command Options
5.1.4 Server System Variables
5.1.5 Using System Variables
5.1.6 Server Status Variables
5.1.7 Server SQL Modes
5.1.8 Server-Side Help
5.1.9 Server Response to Signals
5.1.10 The Server Shutdown Process
5.2 MySQL Server Logs
5.2.1 The Error Log
5.2.2 The General Query Log
5.2.3 The Binary Log
5.2.4 The Slow Query Log
5.2.5 Server Log Maintenance
5.3 Running Multiple MySQL Instances on One Machine
5.3.1 Setting Up Multiple Data Directories
5.3.2 Running Multiple MySQL Instances on Windows
5.3.3 Running Multiple MySQL Instances on Unix
5.3.4 Using Client Programs in a Multiple-Server Environment

End of Product Lifecycle. Active development for MySQL Database Server version 5.0 has ended. Oracle offers various support offerings which may be of interest. For details and more information, see the MySQL section of the Lifetime Support Policy for Oracle Technology Products ( Please consider upgrading to a recent version.

MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation. This chapter provides an overview of MySQL Server and covers general server administration:

For additional information on administrative topics, see also: