Search Results
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/9.7/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/9.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
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 ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. It also ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. Options that can be used with ndb_drop_index are shown in the following table. --database, -d ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...
https://dev.mysql.com/doc/refman/9.7/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-utilities-load-dump.html
MySQL Shell's dump loading utility util.loadDump() supports the import into a MySQL HeatWave Service DB System or a MySQL Server instance of schemas or tables dumped using MySQL Shell's Section 12.5, “Instance Dump Utility, Schema Dump Utility, ...To get the best functionality, always use the most recent version available of MySQL Shell's dump and dump loading ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-secondary-indexes.html
Even with additional write costs, secondary indexes on virtual columns may be preferable to generated stored columns, which are materialized in the clustered index, resulting in larger tables that require more disk space and memory. row ...A ...