3.2.3 Query Analyzer Settings

There are a number of settings related to the Query Analyzer data. You can configure the Query Analyzer operation by using the configure query analyzer link within the Query Analyzer tab, or through the configure query analyzer button within the Manage Servers tab within the Settings tab. Both methods provide you with the same dialog:

Figure 3.13 MySQL Enterprise Monitor User Interface: Query Analyzer Configuration

MySQL Enterprise Monitor User Interface: Query Analyzer Configuration

Through either solution, the configuration options that you select are applied to the individual server or server group selected within the Serversnavigation panel.

There are three configuration options available through either method:

To enable or disable Query Analyzer for an individual server, go to the Settings tab and click the Manage Servers link. To configure all the properties, click the configure query analyzer link next to server you want modify.

Alternatively, for each server, the Query Analyzer column shows the current setting, On or Off, and whether the Example and Explain functionality is enabled. To change any setting, click the current status to toggle between the On/Off position.

To disable or enable Query Analyzer for the selected servers, use the disable query analyzer or enable query analyzer buttons within the Settings tab. You must have selected one or more servers from the list of available servers before selecting these buttons.

You can use the options that you have just selected as the default for all new servers that register with MySQL Enterprise Service Manager by using select the Make this the default for all new servers checkbox. By default, when a new server registers with MySQL Monitor, the server is automatically configured to supply Query Analyzer data. This can have impact on the performance of your monitor and agent as it increases the amount of information supplied to the MySQL Monitor.

Configuration of Query Analyzer occurs through the configure defaults button from within the Query Analyzer tab.