Chapter 5 MySQL Server Administration

5.1 The MySQL Server
5.2 The MySQL Data Directory
5.3 The mysql System Database
5.4 MySQL Server Logs
5.5 MySQL Server Plugins
5.6 MySQL Server User-Defined Functions
- 5.6.1 Installing and Uninstalling User-Defined Functions
- 5.6.2 Obtaining User-Defined Function Information
5.7 Running Multiple MySQL Instances on One Machine
5.8 Debugging MySQL

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:

Chapter 6, Security
Section 14.8, “InnoDB Configuration”
Chapter 7, Backup and Recovery
Chapter 17, Replication
Chapter 19, Partitioning