Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. Design your tables to minimize their space on the disk. Smaller tables normally ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
This can be done by issuing a statement such as ALTER TABLE mysql.ndb_apply_status ENGINE=MyISAM on the replica. In the event of a node failure, errors in replication of NDB tables without primary keys can still occur, due to the possibility of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
DROP PARTITION, see Section 15.1.9, “ALTER TABLE Statement”.) NULL is also treated in this way for partitioning expressions that use SQL functions. If you insert a row into a table partitioned by RANGE such that the column value used to ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-rag.html
For example: mysql> ALTER TABLE demo_db.demo_embeddings SECONDARY_LOAD; This accelerates processing of vector distance function used to compare vector embeddings and generate relevant output later in this section. For example: mysql> ALTER TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
The row format of a table can also be defined explicitly using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. If you create the table, load data, and then run ALTER TABLE to add a primary key later, that operation is much ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-tableconfiguration-category.html
Old Alter Table Enabled Whether to revert to using a temporary table, copying over the data, and then renaming the temporary table to the original, as used by MySQL 5.0 and earlier. Lists the Table Configuration configuration metrics and provides a ...Explicit Defaults For Timestamp Enabled Sets whether TIMESTAMP columns has an explicit DEFAULT ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
(This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no implicit commit occurs, neither can the statement be rolled back, which means that the use of such ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
To identify such tables, execute this query: SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE ENGINE NOT IN ('innodb', 'ndbcluster') AND CREATE_OPTIONS LIKE '%partitioned%'; Any table reported by the query must be altered to use ...Preliminary checks: The following issues must not be present: There must be no tables that use obsolete data types or ... Before upgrading to the latest MySQL 8.4 release, ensure the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
Important For a key-partitioned table, you cannot execute an ALTER TABLE DROP PRIMARY KEY, as doing so generates the error ERROR 1466 (HY000): Field in list of fields for partition function not found in table. NDB Cluster uses MD5() for this ...