Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has the same name as the other member, plus a x$ prefix. The view with the x$ prefix ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-file-io-type.html
These views summarize file I/O, grouped by user and event type. By default, rows are sorted by user and descending total latency. The user_summary_by_file_io_type and x$user_summary_by_file_io_type views have these columns: user The client user ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-file-io.html
By default, rows are sorted by descending total file I/O latency. The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-stages.html
By default, rows are sorted by user and descending total stage latency. The user_summary_by_stages and x$user_summary_by_stages views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-latency.html
The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-type.html
These views summarize information about statements executed, grouped by user and statement type. By default, rows are sorted by user and descending total latency. The user_summary_by_statement_type and x$user_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table ...
https://dev.mysql.com/doc/refman/8.4/en/sys-wait-classes-global-by-avg-latency.html
These views summarize wait class average latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_avg_latency and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-wait-classes-global-by-latency.html
These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_latency and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-waits-by-host-by-latency.html
These views summarize wait events, grouped by host and event. By default, rows are sorted by host and descending total latency. The waits_by_host_by_latency and x$waits_by_host_by_latency views have these columns: host The host from which the ...