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.
Like with any Advisor, this may be set globally, or for a group or particular MySQL server.
Thee configuration options are:
Enable Example Query displays more information about individual queries. When enabled, queries and their data items (rather than the canonical form shown by default) are provided. Enabling this option could expose the full query statements and therefore could present a security issue.
With the Example Query option enabled, an additional tab is available within the query summary details. For more information, see Section 21.3.1, “Getting Detailed Query Information”.
If you enable Example Query, you can also enable Example Explain. To enable this tab, select the Enable Example Explain checkbox.
Enable Example Explain provides another
tab when viewing a query where you can view the output from
EXPLAIN output from MySQL for the selected
query. This shows the full query and how the query was
executed within the servers.
Enabling this option might add overhead to the execution of
your server, as the server runs an
statement each time it identifies a long running query. For
more information, see Appendix A, MySQL Enterprise Monitor Frequently Asked Questions.
Auto-Explain Threshold: Explains will be generated for queries with a runtime above this threshold. (Format: hh:mm:ss.msec)
QRTi Threshold: Optimal time for response time index. For more information about QRTi, see Section 21.2, “Query Response Time index (QRTi)”.