This tab provides information about the system variables of the MySQL server. In the left box of the working area, you can find categories and subcategories. Double click on a category name to expand or collapse its subcategories.
For each category, and each subcategory, the system variables are
listed in the right box of the working area, together with their
values and a short explanation. See
SHOW VARIABLES
Syntax, for more information on system
variables.
System variables that can be set at runtime are marked as
editable, that is they are prefixed with an icon different from
the variables that cannot be set at runtime. Double clicking on
editable variables will open a dialog box allowing you to specify
another value for the variable. The changes you make will take
effect as soon as you confirm the changes by clicking the
OK button. Click
Abort if you want to keep the current
value. Changes made in this manner will only persist until the
server is restarted, after which the server will revert to it's
startup settings. In MySQL Administrator, system variables are set on
a global level only. Note that you need appropriate privileges to
change variables globally. See SET
Syntax.
Use the Refresh button to make MySQL Administrator retrieve the variables and their values once again.
Right clicking in the right box allows you to copy variables to the clipboard.