Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_delay_after_data_drop Command-Line Format --clone-delay-after-data-drop System Variable clone_delay_after_data_drop Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 3600 Unit bytes ...
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
For example, you may still use DROP to drop the table, and TRUNCATE TABLE to empty the table. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
Whenever GIPKs are enabled, you cannot drop a generated primary key if either of the following 2 conditions would result: The table is left with no primary key. The primary key is dropped, but not the primary key column. MySQL 8.4 supports ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. Partitions can be modified, merged, added to tables, and dropped from tables. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
DROP TABLE and TRUNCATE TABLE statements on the table do not activate this trigger, because they do not use DELETE. CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
To perform the user-creation operation without either of these, drop the orphan objects, create the account and grant its privileges, and then re-create the dropped objects. CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE statement to add or drop a spatial column to or from an existing table: ALTER TABLE geom ADD pt POINT; ALTER TABLE geom DROP ... MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER ...