Chapter 5 MySQL Server Administration Table of Contents 637 5.1 The MySQL Server ................................................................................................................... 638 5.1.1 Configuring the Server ................................................................................................... 639 5.1.2 Server Configuration Defaults ......................................................................................... 640 5.1.3 Server Configuration Validation ....................................................................................... 640 5.1.4 Server Option, System Variable, and Status Variable Reference ....................................... 641 5.1.5 Server System Variable Reference ................................................................................. 690 5.1.6 Server Status Variable Reference ................................................................................... 715 5.1.7 Server Command Options .............................................................................................. 732 5.1.8 Server System Variables ................................................................................................ 761 5.1.9 Using System Variables ................................................................................................. 916 5.1.10 Server Status Variables ................................................................................................ 947 5.1.11 Server SQL Modes ...................................................................................................... 970 5.1.12 Connection Management .............................................................................................. 982 5.1.13 IPv6 Support ................................................................................................................ 990 5.1.14 Network Namespace Support ....................................................................................... 994 5.1.15 MySQL Server Time Zone Support ............................................................................... 999 5.1.16 Resource Groups ....................................................................................................... 1005 5.1.17 Server-Side Help Support ........................................................................................... 1010 5.1.18 Server Tracking of Client Session State Changes ........................................................ 1010 5.1.19 The Server Shutdown Process .................................................................................... 1014 5.2 The MySQL Data Directory ..................................................................................................... 1015 5.3 The mysql System Schema ..................................................................................................... 1016 5.4 MySQL Server Logs ............................................................................................................... 1021 5.4.1 Selecting General Query Log and Slow Query Log Output Destinations ........................... 1022 5.4.2 The Error Log .............................................................................................................. 1025 5.4.3 The General Query Log ............................................................................................... 1045 5.4.4 The Binary Log ............................................................................................................ 1046 5.4.5 The Slow Query Log .................................................................................................... 1063 5.4.6 Server Log Maintenance .............................................................................................. 1067 5.5 MySQL Components ............................................................................................................... 1068 5.5.1 Installing and Uninstalling Components ......................................................................... 1069 5.5.2 Obtaining Component Information ................................................................................. 1070 5.5.3 Error Log Components ................................................................................................. 1070 5.5.4 Query Attribute Components ......................................................................................... 1072 5.6 MySQL Server Plugins ............................................................................................................ 1072 5.6.1 Installing and Uninstalling Plugins ................................................................................. 1074 5.6.2 Obtaining Server Plugin Information .............................................................................. 1078 5.6.3 MySQL Enterprise Thread Pool .................................................................................... 1079 5.6.4 The Rewriter Query Rewrite Plugin ............................................................................... 1086 5.6.5 The ddl_rewriter Plugin ................................................................................................. 1095 5.6.6 Version Tokens ............................................................................................................ 1098 5.6.7 The Clone Plugin ......................................................................................................... 1110 5.6.8 The Keyring Proxy Bridge Plugin .................................................................................. 1135 5.6.9 MySQL Plugin Services ................................................................................................ 1135 5.7 MySQL Server Loadable Functions .......................................................................................... 1143 5.7.1 Installing and Uninstalling Loadable Functions ............................................................... 1144 5.7.2 Obtaining Information About Loadable Functions ........................................................... 1145 5.8 Running Multiple MySQL Instances on One Machine ................................................................ 1146