Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics.html
By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these columns: table_schema The schema that contains the table. total_latency The ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore.partial.html
Table-Level Recovery (TLR) allows selected tables (or schemas) to be restored from a backup (be it a full backup, a partial backup, or a backup created using transportable tablespaces (TTS)) using the --include-tables and --exclude-tables options.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-generate-table.html
The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in parallel. This topic contains the following sections: ML_GENERATE_TABLE Syntax Syntax Examples See Also To learn about the privileges you need to ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. To work around this issue, use the --result-file option, which ...It ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...The optimization occurs because the query sent to the remote server includes the contents of the WHERE clause and is sent to the remote server and subsequently executed ...
https://dev.mysql.com/doc/internals/en/select-derived.html
Derived tables is the internal name for subqueries in the FROM clause. The processing of derived tables is now included in the table opening process (open_and_lock_tables() call). Routine of execution derived tables and substituting temporary table ...If it is not explain, then cleanup JOIN structures after execution (EXPLAIN needs data of optimization phase and cleanup them after whole query ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. If you have UNIQUE constraints on secondary keys, you can speed up table ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
Options that can be used with ndb_restore are shown in the following table. --allow-pk-changes Command-Line Format --allow-pk-changes[=0|1] Type Integer Default Value 0 Minimum Value 0 Maximum Value 1 When this option is set to 1, ndb_restore allows ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-options-tab.html
Figure 8.19 The Options Tab Table options are grouped into the following sections: General Options Row Options Storage Options Merge Table Options The following sections describe these options in more detail. The AUTO_INCREMENT and delayed key ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-unload-tables.html
Unload Tables Unloading a table from MySQL HeatWave may be necessary to replace an existing table, to reload a table, to free up memory, or simply to remove a table that is no longer used. To unload a table manually, specify the SECONDARY_UNLOAD ...