Configuring the Server For listings of MySQL server variables and options that have been added, deprecated, or removed in MySQL 8.0, see Section 1.4, “Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0” . Not all storage engines are supported by all MySQL server binaries and configurations. To find out how to determine which storage engines your MySQL server installation supports, see Section 13.7.7.16, “SHOW ENGINES Statement” . The MySQL server,  mysqld , has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and system variable values used by the server, execute this command: The command produces a list of all  mysqld  options and configurable system variables. Its output includes the default option and variable values and looks something like this: To see the current system variable values actually used by the server as it runs, connect to it and execute this statement: To see some statistical and status indicators for a running server, execute this statement: System variable and status information also is available using the  mysqladmin  command: For a full description of all command options, system variables, and status variables, see these sections: 639 •Section 5.1.8, “Server System Variables” •Section 5.1.7, “Server Command Options” shell>  mysqladmin variables shell>  mysqladmin extended-status mysql>  SHOW STATUS; mysql>  SHOW VARIABLES; abort-slave-event-count 0 allow-suspicious-udfs FALSE archive ON auto-increment-increment 1 auto-increment-offset 1 autocommit TRUE automatic-sp-privileges TRUE avoid-temporal-upgrade FALSE back-log 80 basedir /home/jon/bin/mysql-8.0/ ... tmpdir /tmp transaction-alloc-block-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size 4096 transaction-read-only FALSE transaction-write-set-extraction XXHASH64 updatable-views-with-limit YES validate-user-plugins TRUE verbose TRUE wait-timeout 28800 shell>  mysqld --verbose --help 5.1.1 Configuring the Server Note