Use the Manage Servers tab to get a list of the currently monitored servers connected to the MySQL Enterprise Service Manager, and view the current MySQL version and important configuration settings for each.
The Manage Servers tab provides a list of servers, organized by groups, in a similar fashion to the main server navigation list. For each server, the following information is displayed:
Shows the Query Analyzer configuration for the server, showing whether Query Analyzer is enabled, whether the recovery of example queries is enabled, and whether explain plans for queries have been enabled.
From this display, you can also control the Query Analyzer settings for each server by clicking the Off link for each server to change the settings. This brings up the Configure Query Analyzer pop-up window. For more information, see Section 3.2.3, “Query Analyzer Settings”.
Shows the version number of the MySQL server being monitored.
Shows the time when the MySQL server was started (the server up time).
The last time communication with the MySQL server occurred.
Shows the version number of the MySQL Enterprise Monitor Agent server being monitored.
Shows the last time communication was received from the agent.
The configured MySQL port number.
The data directory path for the MySQL server.
The time between when the data was obtained by the agent when it was received by MySQL Enterprise Service Manager.
You can search and filter the server list by using the fields and pop-ups at the top of the list. You can filter using one or more of following techniques:
To filter by server name, select the match type (Contains, Regex, Doesn't Contain, or Negative Regex), and enter a string or regular expression into the Value field.
To filter based on whether the Query Analyzer functionality has been enabled or disabled, use the Query Analyzer pop-up.
To filter by MySQL server version, you can enter either an explicit version number into the MySQL Version field, or you can additional symbols to restrict the versions to different ranges. The field supports the following statements:
||Shows all MySQL servers matching the specified version. For example,
||Shows all MySQL servers matching the specific version number.|
||Shows all versions greater than the specified version.|
||Shows all versions greater than or equal to the specified version.|
||Shows all versions less than the specified version.|
||Shows all versions less than or equal to the specified version.|
||Shows all servers with the specified string in their version|
|! String or Version||
||Shows all servers not having the specified string, or not matching the specified version.|
You can combine multiple arguments to produce more complex
formats. For example, to list all of the servers of 5.1 or
higher that do not have enterprise in the version string, you
Filters the list based on the MySQL Enterprise Monitor Agent version number. This can be useful if you want to know which means require an upgrade to a later version. The Agent Version field supports the same selection criteria as the MySQL Version field, allowing to select based on specific version numbers and strings.
Filters the list based on the protocol the Agent uses to communicate with the MySQL Enterprise Service Manager. You can select either standard HTTP or HTTPS/SSL-based connections.
After you make you selection, use the filter button to filter the server list. To reset your selections to show everything, click reset.
Using the list of servers, you can create groups to more easily manage and monitor your servers according to the departments, applications or other groupings that you may want to use. For information on how to create and modify groups, see Section 220.127.116.11, “Grouping Servers”.
You can also perform simple administration on the server within the MySQL Enterprise Monitor framework, including configuring the Query Analyzer, renaming the server (as it appears within MySQL Enterprise Service Manager) or the group name, and updating the information about the server (re-inventory). All of these operations are handled by using hovering over the triangle next to the server name or group.
The pop-up provides a list of options, which are different depending on whether you select an individual server or a group. For a group of servers, you can rename the group, delete the group, or obtain a bundled version of the support diagnostics information. For individual servers, you can modify the Query Analyzer configuration, rename the server, refresh the server inventory, get the support diagnostics information, or turn the event blackout period on and off.
To change the configuration of the Query Analyzer for the server, see Section 3.2.3, “Query Analyzer Settings”. This option is not available for a group.
To rename a server, choose edit server details, or to rename a group, choose rename group. For information on renaming a server, see Section 18.104.22.168, “Renaming a Server”. To rename a group, change the name within the pop-up prompt provided.
To re-inventory your MySQL server and update version and configuration information, click the triangle and choose refresh inventory. This triggers an update of the server information without affecting the schedule inventory process. You can use this when you have upgraded or made significant configuration changes to your server to update the inventory and ensure that the correct rules and advisors are being executed on your server.
You can obtain the support diagnostics file for either
individual servers, or entire server groups. To get a
diagnostic report file, select support
diagnostics from the pop-up menu. The information
is provided as a Zip file that is downloaded to the machine.
The information contained in the report includes detailed
information about your server (or multiple servers if you
selected a server group), including configuration, hardware,
MySQL options/variables and historical graphs. To view the
information extracted, unzip the downloaded file and
For generic information about your MySQL Enterprise Monitor installation, see Diagnostic Report.
Renaming a server using the Manage Servers tab overrides all other settings, including changes made within the agent configuration.
Use the [Enable | disable] event blackout control to turn blackout periods on and off. The server name is greyed out while the blackout period is in effect. Only event reporting is affected; query analysis continues during the blackout period.