Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET DEFAULT ROLE and SET ROLE set the default role and current role for user accounts. Descriptions for those forms that ...
https://dev.mysql.com/doc/refman/8.4/en/show-binlog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW BINLOG EVENTS. SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not ...
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
Caution Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except ...
https://dev.mysql.com/doc/refman/8.4/en/show-relaylog-events.html
Some events relating to the setting of user and system variables are not included in the output from SHOW RELAYLOG EVENTS. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
Any user credentials that you specified in the START GROUP_REPLICATION statement when starting Group Replication on this member are removed from memory, and must be supplied when you start Group Replication again. This statement requires the ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-statement.html
Configuration Options format_statement() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, “The sys_config Table”): statement_truncate_len, ... Given a string ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary.html
These views summarize statement activity, file I/O, and connections, grouped by host. The host_summary and x$host_summary views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying ...
https://dev.mysql.com/doc/refman/8.4/en/sys-io-by-thread-by-latency.html
The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread.
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...