Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
Considerations for NDB Cluster This statement is used to create a tablespace, which can contain one or more data files, providing storage space for NDB Cluster Disk Data tables (see Section 25.6.11, “NDB Cluster Disk Data Tables”). One data file ...The precise syntax and semantics depend on the storage engine ...
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/import-table.html
In that case, modify the import procedure using one of these alternatives before executing the IMPORT TABLE statement: Put the data and index files into the same directory on the import server host as on the export server host, and create symlinks ...The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata ...
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] ...
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/insert-select.html
SELECT, you can quickly insert many rows into a table from the result of a SELECT statement, which can select from one or many tables. For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE ... INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
The following clauses work essentially the same way for LOAD XML as they do for LOAD DATA: LOW_PRIORITY or CONCURRENT LOCAL REPLACE or IGNORE CHARACTER SET SET See Section 15.2.9, “LOAD DATA Statement”, for more information about these clauses.
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
A given SELECT statement can contain at most one INTO clause, although as shown by the SELECT syntax description (see Section 15.2.13, “SELECT Statement”), the INTO can appear in different positions: Before FROM. Example: SELECT * FROM t1 FOR ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session. SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
Like START REPLICA, this statement may be used with the IO_THREAD and SQL_THREAD options to name the replication thread or threads to be stopped. This can be used to avoid deadlocks between STOP REPLICA and other SQL statements using different ...] ...