HoneySoftware

In the Variables Tab of Server Properties Form MySQL® variables are listed. Many server system variables can be set at runtime; these variables are the so called Dynamic Variables.

HoneyMonitor v.1.0.7-beta will include four new columns in Variables list: "Dynamic", "Type", "Handle" and "Description".

In the "Dynamic" column you can see if a variable is dynamic or not; in the "Type" column you can see the value-type of the variable (string, boolean, ...); in the "Handle" column you can see if the current variable is a global or session variable; in the "Description" column you can see a short description of the current variable.

If you click on a row, a useful popup menu will be showed ; this popup contains a (long) description of the current variable; by double-cliccking on a row you'll can edit variable's value.

Dynamic variables can be of the following type:

• string
• enumeration
• boolean
• numeric

String variables con contain a string value (Fig. 1) or a comma separated list of string values (Fig. 2). Enumeration variables should be set to one of the available values for the variable (Fig. 3); if for whatever reason the value you want to set isn't listed in the combo-box, you can write it manually (Fig. 4). Variables that have a type of “boolean” can be set to 0, 1, ON or OFF (Fig. 5); numeric variables take a numeric value (Fig. 6).

Some variables are "Session" variables, other "Global" variables, other can be both "Session" and "Global". The "Set Value for Variable Dialog" will enable / disable session or global options on the basis of the current variable.