15.13. The Query Analyzer Tab

Query Analyzer lets you monitor the statements being executed on a monitored server and retrieve information about the query, number of executions and the execution times of each query. Queries are normalized, so that the unique data defined within each query has been removed. By removing the data specific elements of the queries, the generic queries can be counted and identified more easily.

Query Analyzer works by collecting information about SQL statements that your MySQL client application sends to the MySQL server, either by using the MySQL Enterprise Agent proxy service, or by using the MySQL Enterprise Monitor Plugin for a given connector that sends the information directly to MySQL Enterprise Service Manager.

Figure 15.42. MySQL Enterprise Dashboard: Query Analyzer

MySQL Enterprise Dashboard: Query Analyzer

For more information using the Query Analyzer, including how to feed and provide queries to MySQL Enterprise Service Manager, how to use the user interface, and how to drill down to find the queries and information that you need, see Using the Query Analyzer.

Copyright © 2010-2024 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout