The Server Properties window shows current server properties and status of variables etc. It also allows you to perform FLUSH operations without the need to connect to your MySQL server yourself.
The window shows three parts:
•Info
In addition to the information displays, it allows you to FLUSH. Refreshing the information can be done via the Refresh button on the toolbar of the window.
Server Properties - Info
Server Properties: Info
The Info tab shows information some information about your MySQL server process. Check the MySQL documentation for the exact meaning of this information.
Server Properties - Status
Server Properties: Status
The Status tab shows information as returned by MySQL from the SHOW STATUS command. You can sort the values by clicking on the header of the columns, at the bottom there are 2 tabs showing either the grouped values (click a node in the treeview on the left) or all properties.
Server Properties - Variables
Server Properties: Variables
The Status tab shows information as returned by MySQL from the SHOW VARIABLES command. You can sort the values by clicking on the header of the columns, at the bottom there are 2 tabs showing either the grouped values (click a node in the treeview on the left) or all properties.
Performing a FLUSH
If you want to perform a FLUSH command, you can do that very easily by using the drop down button from the toolbar. Selecting one of the menu options from the drop down menu results in performing the corresponding FLUSH flushoption command.