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 Plugins
5.1.9 IPv6 Support
5.1.10 Server-Side Help
5.1.11 Server Response to Signals
5.1.12 The Shutdown Process
5.2 MySQL Server Logs
5.2.1 Selecting General Query and Slow Query Log Output Destinations
5.2.2 The Error Log
5.2.3 The General Query Log
5.2.4 The Binary Log
5.2.5 The Slow Query Log
5.2.6 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
5.4 Tracing mysqld Using DTrace
5.4.1 mysqld DTrace Probe Reference

This chapter provides an overview of MySQL Server, the mysqld command that does most of the work in a MySQL installation. It covers administration topics for mysqld and for the MySQL tables and indexes containing your data:

For additional information on administrative topics, see also: