MySQL Workbench: Status and System Variables

The Status and System Variables tab of MySQL Workbench lists all server variables for the MySQL connection. This tab allows you to copy all variables to your clipboard if required.

To display the Status and System Variables tab, click Status and System Variables on the Management tab:

You should see a screen like this:

The Status and System Variables screen displays a list of all server variables. These are separated into Status Variables and System Variables. You can view each type by clicking on either Status Variables or Server Variables as required.

Filtering the Variables

You can use the search facility to narrow the number of variables down. Here's an example:

The SHOW VARIABLES Command

You can run a query using the SHOW VARIABLES command to return a list of variables. You can also filter it using the LIKE operator.

Example: