Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
The statement supports these actions: ALTER INSTANCE {ENABLE | DISABLE} INNODB REDO_LOG This action enables or disables InnoDB redo logging. ENCRYPTION operations, and locks are taken to prevent conflicts that could arise from concurrent execution ... ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY | ROTATE BINLOG MASTER KEY | RELOAD TLS [FOR CHANNEL {mysql_main | mysql_admin}] [NO ROLLBACK ON ERROR] | RELOAD KEYRING } ALTER INSTANCE defines actions applicable to a MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/resignal.html
Otherwise, by executing an SQL statement within the handler, information that caused the handler's activation is destroyed. To retrieve information from the diagnostics area, use the GET DIAGNOSTICS statement (see Section 15.6.7.3, “GET ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
Only the threads that are started are affected by the statement. A successful START REPLICA statement causes SHOW REPLICA STATUS to show Replica_SQL_Running=Yes, but it might or might not show Replica_IO_Running=Yes, because Replica_IO_Running=Yes ... START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
VALUES row_constructor_list [ORDER BY column_designator] [LIMIT number] row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] value_list: value[, value][, ...] column_designator: column_index The VALUES statement consists of the VALUES ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-trxstatementactivity-category.html
Lists the Trx Statement Activity metrics and provides a brief description of each. Table 8.10 Trx Statement Activity Metrics NameDescriptionTarget Name Name of the OEM Target Begin (Delta) The total number of BEGIN | START TRANSACTION statements ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-trxstatementactivity-category.html
Lists the Trx Statement Activity metrics and provides a brief description of each. Table 6.46 Trx Statement Activity Metrics NameDescriptionBegin (Delta) The total number of BEGIN | START TRANSACTION statements executed. Release Savepoint (Delta) ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-sorting.html
The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed occurrences of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. Note This statement takes the place of the old RESET MASTER ...A new empty binary log file is created so that binary logging can be ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statements-with-full-table-scans.html
These views display normalized statements that have done full table scans. The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement string. db The default database for the ...By default, rows are sorted by descending percentage of time a full scan was done and descending total ...