Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.8Mb
PDF (RPM) - 40.1Mb
HTML Download (TGZ) - 10.1Mb
HTML Download (Zip) - 10.2Mb
HTML Download (RPM) - 8.7Mb
Man Pages (TGZ) - 244.6Kb
Man Pages (Zip) - 349.8Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  MySQL Server Administration

Chapter 5 MySQL Server Administration

Table of Contents

5.1 The MySQL Server
5.1.1 Configuring the Server
5.1.2 Server Configuration Defaults
5.1.3 Server Configuration Validation
5.1.4 Server Option, System Variable, and Status Variable Reference
5.1.5 Server System Variable Reference
5.1.6 Server Status Variable Reference
5.1.7 Server Command Options
5.1.8 Server System Variables
5.1.9 Using System Variables
5.1.10 Server Status Variables
5.1.11 Server SQL Modes
5.1.12 Connection Management
5.1.13 IPv6 Support
5.1.14 Network Namespace Support
5.1.15 MySQL Server Time Zone Support
5.1.16 Resource Groups
5.1.17 Server-Side Help Support
5.1.18 Server Tracking of Client Session State Changes
5.1.19 The Server Shutdown Process
5.2 The MySQL Data Directory
5.3 The mysql System Schema
5.4 MySQL Server Logs
5.4.1 Selecting General Query Log and Slow Query Log Output Destinations
5.4.2 The Error Log
5.4.3 The General Query Log
5.4.4 The Binary Log
5.4.5 The Slow Query Log
5.4.6 Server Log Maintenance
5.5 MySQL Components
5.5.1 Installing and Uninstalling Components
5.5.2 Obtaining Component Information
5.5.3 Error Log Components
5.5.4 Query Attribute Components
5.6 MySQL Server Plugins
5.6.1 Installing and Uninstalling Plugins
5.6.2 Obtaining Server Plugin Information
5.6.3 MySQL Enterprise Thread Pool
5.6.4 The Rewriter Query Rewrite Plugin
5.6.5 The ddl_rewriter Plugin
5.6.6 Version Tokens
5.6.7 The Clone Plugin
5.6.8 MySQL Plugin Services
5.7 MySQL Server User-Defined Functions
5.7.1 Installing and Uninstalling User-Defined Functions
5.7.2 Obtaining User-Defined Function Information
5.7.3 Query Attribute User-Defined Functions
5.8 Running Multiple MySQL Instances on One Machine
5.8.1 Setting Up Multiple Data Directories
5.8.2 Running Multiple MySQL Instances on Windows
5.8.3 Running Multiple MySQL Instances on Unix
5.8.4 Using Client Programs in a Multiple-Server Environment
5.9 Debugging MySQL
5.9.1 Debugging a MySQL Server
5.9.2 Debugging a MySQL Client
5.9.3 The LOCK_ORDER Tool
5.9.4 The DBUG Package

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 schema

  • The server log files

  • Management of multiple servers on a single machine

For additional information on administrative topics, see also: