Search Results
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax. The TABLESPACE option can be used with CREATE TABLE to create tables in a general tablespaces, file-per-table tablespace, or in the system tablespace. Creating a General Tablespace General tablespaces are created using CREATE TABLESPACE ...To make an ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-load-dump.html
To do this, first use the dump loading utility to load only the DDL for the selected table, to create the table on the target server. If table data was chunked when the dump was created, multiple threads can be used for a table, otherwise each ...To ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The first index is GEN_CLUST_INDEX, which is a clustered index created by InnoDB if the table does not have a user-defined clustered index. If a file-per-table tablespace were created in a location outside the MySQL data directory using the DATA ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
File-per-table tablespace characteristics are described under the following topics in this section: File-Per-Table Tablespace Configuration File-Per-Table Tablespace Data Files File-Per-Table Tablespace Advantages File-Per-Table Tablespace ... A ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utils-copy.html
If possible, instead of managing this in the utility, consider creating primary keys in the tables on the source server before copying them. If you set the chunking option to false, chunking does not take place and the utility creates one data file ...See Section 12.5, “Instance Dump Utility, Schema Dump Utility, and Table Dump Utility” for more information on these ... This section describes the MySQL Shell copy utilities: About the Utilities Requirements and Restrictions Running the Utilities Options for Copy Control Options for Filtering Examples About the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-parallel-table.html
To do this, first use the dump loading utility to load only the DDL for the selected table, to create the table on the target server. MySQL Shell's parallel table import utility util.importTable() provides rapid data import to a MySQL relational ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-alter-table-performance-schema.html
You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ALTER TABLE. Each stage event reports a running total of WORK_COMPLETED and WORK_ESTIMATED for the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...If you drop an AUTO_INCREMENT column ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
If you use USE_FRM for a table that was created by a different version of the MySQL server than the one you are currently running, REPAIR TABLE does not attempt to repair the table. With myisamchk --safe-recover, you can also use options that REPAIR ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in memory. Characteristics of MEMORY Tables The MEMORY storage engine does not create any files on disk. DDL Operations for MEMORY ...A ...