content_image/741740.jpg content_image/741736.jpg
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” . 

## 5.1.1 Configuring the Server 

<img src='content_image/741740.jpg'>

## Note 

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: 

shell> mysqld --verbose --help 

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: 

<img src='content_image/741736.jpg'>

To see the current system variable values actually used by the server as it runs, connect to it and execute this statement: 

mysql> SHOW VARIABLES; 

To see some statistical and status indicators for a running server, execute this statement: 

mysql> SHOW STATUS; 

System variable and status information also is available using the mysqladmin  command: 

shell> mysqladmin variables shell> mysqladmin extended-status 

For a full description of all command options, system variables, and status variables, see these sections: 

•Section 5.1.7, “Server Command Options” 

•Section 5.1.8, “Server System Variables” 

