23.3.4 Query Analyzer Settings

There are a number of settings related to the Query Analyzer data. To configure the Query Analyzer, go to the Configuration, Advisors page and select the Query Analysis Advisor category. Then choose Edit Advisor Configuration from the context menu of the Query Analysis Reporting Advisor.

Figure 23.8 MySQL Enterprise Monitor User Interface: Query Analyzer Configuration

MySQL Enterprise Monitor User Interface: Query Analyzer Configuration

Like with any Advisor, this may be set globally, or for a group or particular MySQL server.

Thee configuration options are:

You can also define a schedule for the advisor's data collection. For more information, see Section 19.4, “Advisor Schedules”


If this advisor is disabled, Query Analysis data is no longer collected from the monitored instances. The Query Analyzer continues displaying data collected prior to the advisor being disabled.

If disabled, a message is displayed on the Query Analyzer page: "N of the selected servers do not have query analyzer enabled." where N is the number of servers.