MySQL 8.0 Reference Manual 4.7.1 mysql_config — Display Options for Compiling Clients ............................................. 627 4.7.2 my_print_defaults — Display Options from Option Files ........................................... 629 4.8 Miscellaneous Programs ................................................................................................... 630 4.8.1 lz4_decompress — Decompress mysqlpump LZ4-Compressed Output ..................... 630 4.8.2 perror — Display MySQL Error Message Information ............................................... 630 4.8.3 zlib_decompress — Decompress mysqlpump ZLIB-Compressed Output ................... 631 4.9 Environment Variables ...................................................................................................... 631 4.10 Unix Signal Handling in MySQL ....................................................................................... 634 5 MySQL Server Administration ...................................................................................................... 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 vi