Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
Deleting all rows (JSON property: message) For DELETE, some storage engines (such as MyISAM) support a handler method that removes all table rows in a simple and fast way. No matching rows after partition pruning (JSON property: message) For DELETE ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, UPDATE, and TABLE statements. EXPLAIN ANALYZE can be used with SELECT ...In ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
The permissible priv_type values at the table level are ALTER, CREATE VIEW, CREATE, DELETE, DROP, GRANT OPTION, INDEX, INSERT, REFERENCES, SELECT, SHOW VIEW, TRIGGER, and UPDATE. Thus, although u1 has the DELETE privilege, that is not included in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
If another transaction deletes a row and commits after your timepoint was assigned, you do not see the row as having been deleted. If you insert or modify some rows and then commit that transaction, a DELETE or UPDATE statement issued from another ... A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 14.9.6, “Fine-Tuning MySQL Full-Text ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
It does not contain any uncommitted values, old versions of values, or values marked for deletion but not yet removed from the old index. DROP PARTITION with ALGORITHM=INPLACE deletes data stored in the partition and drops the partition. It merely ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
Avoid performing rollbacks after inserting, updating, or deleting huge numbers of rows. Set innodb_change_buffering=all so that update and delete operations are buffered in addition to inserts. Consider issuing COMMIT statements periodically during ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
SQL statements supporting explicit partition selection are listed here: SELECT DELETE INSERT REPLACE UPDATE LOAD DATA. When the PARTITION option is used with DELETE statements, only those partitions (and subpartitions, if any) listed with the option ... Explicit selection of partitions and subpartitions for rows matching a given WHERE condition is ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysqlrouter_keyring.html
set: Add or overwrite account of the user in the keyring file delete: Delete user from the keyring. The mysqlrouter_keyring utility is a command line application to manage MySQL Router key rings. Keyring commands; all commands also accept ...