Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Lists the Statement Processing configuration metrics and provides a brief description of each. Big Selects Enabled If set to 0, MySQL aborts SELECT statements that are likely to take a very long time to execute (that is, statements for which the ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
The minimum requirements for a valid CREATE EVENT statement are as follows: The keywords CREATE EVENT plus an event name, which uniquely identifies the event in a database schema. A DO clause, which contains the SQL statement to be executed by an ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
[IGNORE UNKNOWN USER] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names” } The REVOKE statement enables system administrators to revoke privileges and roles, which can be ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
To check the stored key distribution cardinality, use the SHOW INDEX statement or the INFORMATION_SCHEMA STATISTICS table. See Section 15.7.7.23, “SHOW INDEX Statement”, and Section 28.3.34, “The INFORMATION_SCHEMA STATISTICS Table”. ANALYZE ...ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-adminstatementactivity-category.html
Assign To Keycache (Delta) The total number of CACHE INDEX statements executed. Preload Keys (Delta) The total number of LOAD INDEX INTO CACHE statements executed. Lists the Admin Statement Activity metrics and provides a brief description of each.
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...CHANGE REPLICATION FILTER requires the REPLICATION_SLAVE_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. Note REPLACE makes sense only if a table has a ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
SHOW REPLICA STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. The statement requires the REPLICATION CLIENT privilege (or the deprecated SUPER privilege). If you issue this ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...Generally, the view references must be updatable, meaning that they may be merged and not ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
FOR EXPORT } table_synonym: { TABLE | TABLES } The FLUSH statement has several variant forms that clear or reload various internal caches, flush tables, or acquire locks. Note It is not possible to issue FLUSH statements within stored functions or ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...