Search Results
MySQL 8.4 Reference Manual :: 30.4.3.4 The host_summary_by_stages and x$host_summary_by_stages Views
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-stages.html
The host_summary_by_stages and x$host_summary_by_stages views have these columns: host The host from which the client connected. By default, rows are sorted by host and descending total latency. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-type.html
The host_summary_by_statement_type and x$host_summary_by_statement_type views have these columns: host The host from which the client connected. These views summarize information about statements executed, grouped by host and statement type. By ...
https://dev.mysql.com/doc/refman/8.4/en/sys-latest-file-io.html
The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections). These views summarize file I/O activity, grouped by file and thread.
https://dev.mysql.com/doc/refman/8.4/en/sys-memory-by-host-by-current-bytes.html
The memory_by_host_by_current_bytes and x$memory_by_host_by_current_bytes views have these columns: host The host from which the client connected. By default, rows are sorted by descending amount of memory used. Rows for which the HOST column in the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, ...
https://dev.mysql.com/doc/refman/8.4/en/sys-waits-by-host-by-latency.html
The waits_by_host_by_latency and x$waits_by_host_by_latency views have these columns: host The host from which the connection originated. These views summarize wait events, grouped by host and event. By default, rows are sorted by host and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-waits-by-user-by-latency.html
The waits_by_user_by_latency and x$waits_by_user_by_latency views have these columns: user The user associated with the connection. These views summarize wait events, grouped by user and event. By default, rows are sorted by user and descending ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
default_roles: This table lists default roles to be activated after a user connects and authenticates, or executes SET ROLE DEFAULT. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
To specify that all updates issued in a specific connection should be done with low priority, set the low_priority_updates server system variable equal to 1. InnoDB tables use row-level locking so that multiple sessions and applications can read ...