Chapter 6 MySQL Server Administration

Table of Contents [+/-]

6.1 The MySQL Server [+/-]

6.1.1 Server Option and Variable Reference
6.1.2 Server Configuration Defaults
6.1.3 Server Command Options
6.1.4 Server System Variables
6.1.5 Using System Variables
6.1.6 Server Status Variables
6.1.7 Server SQL Modes
6.1.8 IPv6 Support
6.1.9 Server-Side Help
6.1.10 Server Response to Signals
6.1.11 The Server Shutdown Process

6.2 The MySQL Data Directory

6.3 The mysql System Database

6.4 MySQL Server Logs [+/-]

6.4.1 Selecting General Query and Slow Query Log Output Destinations
6.4.2 The Error Log
6.4.3 The General Query Log
6.4.4 The Binary Log
6.4.5 The Slow Query Log
6.4.6 The DDL Log
6.4.7 Server Log Maintenance

6.5 MySQL Server Plugins [+/-]

6.5.1 Server Plugins Available
6.5.2 Installing and Uninstalling Plugins
6.5.3 Obtaining Server Plugin Information
6.5.4 MySQL Enterprise Thread Pool
6.5.5 The Rewriter Query Rewrite Plugin
6.5.6 Version Tokens

6.6 Running Multiple MySQL Instances on One Machine [+/-]

6.6.1 Setting Up Multiple Data Directories
6.6.2 Running Multiple MySQL Instances on Windows
6.6.3 Running Multiple MySQL Instances on Unix
6.6.4 Using Client Programs in a Multiple-Server Environment

6.7 Tracing mysqld Using DTrace [+/-]

6.7.1 mysqld DTrace Probe Reference

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:

Server configuration
The data directory, particularly the mysql system database
The server log files
Management of multiple servers on a single machine

For additional information on administrative topics, see also:

PREV HOME UP NEXT

User Comments