https://dev.mysql.com/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/sys-statement-analysis.html
db The default database for the statement, or NULL if there is none. The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. full_scan The total number of full table scans performed by ...
https://dev.mysql.com/sys-statements-with-errors-or-warnings.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. The ...
https://dev.mysql.com/sys-statements-with-full-table-scans.html
db The default database for the statement, or NULL if there is none. These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total ...
https://dev.mysql.com/sys-statements-with-runtimes-in-95th-percentile.html
db The default database for the statement, or NULL if there is none. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have ...
https://dev.mysql.com/sys-statements-with-sorting.html
db The default database for the statement, or NULL if there is none. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/sys-statements-with-temp-tables.html
db The default database for the statement, or NULL if there is none. These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of ...
https://dev.mysql.com/sys-user-summary-by-file-io-type.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize file I/O, grouped by user and event type. By default, ...
https://dev.mysql.com/sys-user-summary-by-file-io.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by descending total file I/O latency. The ...
