EMS logo

Products Navigation

SQL Manager for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

On-line Documentation

Viewing system variables


The System variables tab of the Server Properties viewer displays the list of MySQL system variables and their values.

 

Server Properties - Viewing system variables

 

 

The variables are displayed in groups: General, Connections, SQL, Memory, Table Types, Other, All. Select a group (or a sub-group) in the tree on the left side to browse the list of system variables included in this group.

 

Right-click an item within the list to call the context menu allowing you to edit a variable and to refresh the list.

 

The Set variable dialog allows you to edit the current value assigned to the variable and to specify whether the changes will be applied globally or for the current session only.

 

Server Properties - Viewing system variables - Set variable

 

 

If necessary, you can export the list of system variables to any of supported output file formats or copy the list to Windows clipboard using the corresponding items of the Navigation bar.

 

 

Hint: The status area at the bottom displays the exact MySQL server version and the server uptime.

 

 


See also:

Viewing status variables

Viewing process list

Viewing InnoDB status

Viewing general query log