MySQL Workbench Manual  /  Administrative Tasks  /  Status and System Variables

6.4 Status and System Variables

The Administration - Status and System Variables tab lists the full set of server variables for the MySQL connection. You may also copy all or selected variables to your clipboard.

You can access this tab from either the Navigator panel, or by clicking Server and then Status and System Variables from the menu. The following figure shows the Status Variables tab selected.

Figure 6.8 Navigator Management: Status Variables

Content is described in the surrounding text.

The next figure shows the System Variables tab selected.

Figure 6.9 Navigator Management: System Variables

Content is described in the surrounding text.

Custom Variable Grouping

The status and system variables are each categorized by groups (such as InnoDB or Logging), and you may also create your own custom groups. Right-click a variable, choose the custom group (or create a new one), and then add the variable to the aforementioned group. Your custom groups are listed along with the pre-existing groups.

The following figure shows an example of a custom group titled My Variables, which is being added to the Created_tmp_variables variable.

Figure 6.10 Navigator Management: Adding A Variable To A Custom Group

Content is described in the surrounding text.


User Comments
Sign Up Login You must be logged in to post a comment.