https://dev.mysql.com/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/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 informaion about statements executed, grouped by host and statement type. By ...
https://dev.mysql.com/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/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/sys-processlist.html
They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also nonblocking. By default, rows are sorted by descending process time and descending wait time. For additional ...
https://dev.mysql.com/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/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/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/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 ...
https://dev.mysql.com/test-pluggable-authentication.html
To uninstall it, use UNINSTALL PLUGIN: UNINSTALL PLUGIN test_plugin_server; To use the test authentication plugin, create an account and name that plugin in the IDENTIFIED WITH clause: CREATE USER 'testuser'@'localhost' IDENTIFIED WITH ... MySQL ...
