4.1 Query Analyzer

The Query Analyzer provides a point-in-time snapshot of queries on the monitored database, enabling you to monitor SQL statements executed on a MySQL server and see details of each query, number of executions, and execution times. Each row within the table provides the statistical information for one normalized query. Selecting a query loads additional data for that query, including Average Execution Time, Total Executions, and Rows Affected over time. It also allows running an explain plan on the specified query. If the query is normalized and needs to be de-normalized, then you can edit it in the Query Text box.

Important

This report retrieves data from the sys.x$statement_analysis view of the sys schema. If the sys schema, version 1.5.1 or higher, is not installed on the monitored MySQL server, the report is not populated.

Table 4.1 Query Analyzer Columns

Column Name	Description
Database	The default database for the statement, or NULL if there is none.
Exec Count	The total number of times the statement has executed.
Error Count	The total number of errors produced by occurrences of the statement.
Warning Count	The total number of warnings produced by occurrences of the statement.
Total Latency	The total wait time of timed occurrences of the statement.
Max Latency	The maximum single wait time of timed occurrences of the statement.
Avg Latency	The average wait time per timed occurrence of the statement.
Full Scan	The total number of full table scans performed by occurrences of the statement.
Lock Latency	The total time waiting for locks by timed occurrences of the statement.
Rows Affected	The total number of rows affected by occurrences of the statement.
Rows Examined	The total number of rows read from storage engines by occurrences of the statement.
Rows Sent	The total number of rows returned by occurrences of the statement.
Rows Sorted	The total number of rows sorted by occurrences of the statement.
Sort Merge Passes	The total number of sort merge passes by occurrences of the statement.
Tmp Disk Tables	The total number of internal on-disk temporary tables created by occurrences of the statement.
Tmp Tables	The total number of internal in-memory temporary tables created by occurrences of the statement.
First Seen	The time at which the statement was first seen.
Last Seen	The time at which the statement was most recently seen.
Digest	The statement digest. For more information, see Performance Schema Statement Digests and Sampling.