Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. For InnoDB tables, both tables must use the same row format. To determine the row format of an InnoDB table, query ...There are no rows in nt that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
As of MySQL 9.4.0, you can set external table options using SQL syntax. The following options apply to CREATE TABLE and ALTER TABLE statements. For ALTER TABLE statements, ADD COLUMN is not supported for external tables. This topic contains the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...This statement cannot be used with HASH or KEY partitions; instead, use COALESCE PARTITION (see later in this ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible ...See Section 26.6.2, “Partitioning Limitations Relating to Storage Engines”, for more ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
Normal operations can continue while the hash table is emptied, and executing queries that were using the hash table access the index B-trees directly instead. When the adaptive hash index is re-enabled, the hash table is populated again during ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES table has these columns: TABLE_ID An identifier for the InnoDB table. NAME The name of the table, preceded by ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-handles-table.html
The Performance Schema exposes table lock information through the table_handles table to show the table locks currently in effect for each opened table handle. This information shows which table handles the server has open, how they are locked, and ...The value is one of READ, READ WITH SHARED LOCKS, READ HIGH PRIORITY, READ NO INSERT, WRITE ALLOW WRITE, WRITE CONCURRENT INSERT, WRITE LOW PRIORITY, or ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-rpd-tables-table.html
The rpd_tables table provides the system change number (SCN) and load pool type for tables loaded in the MySQL AI Engine (AI engine). The rpd_tables table has these columns: ID A unique identifier for the table. The SCN is an internal number that ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table. The exact changes made to each table depend on the storage engine used by that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. The number of indexed columns in a table The number of partitions. If a table has no partitions, the number ...Note innodb_stats_persistent_sample_pages defines the number of pages sampled at a global ...