Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-overview.html
However, if no columns are listed in the PARTITION BY KEY or PARTITION BY LINEAR KEY clause of the CREATE TABLE or ALTER TABLE statement used to create or modify a user-partitioned NDB table, then the table is not required to have an explicit ...The ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
You can use a number of extensions to ALTER TABLE for performing operations of this type on one or more partitions directly, as described in the following list: Rebuilding partitions. If you have deleted a large number of rows from a partition or if ... A number of table and partition maintenance tasks can be carried out on partitioned tables using SQL statements intended for such ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name (col_name column_definitions) ENGINE=NDBCLUSTER; Alternatively, for an existing table that uses a different storage engine, use ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
If the pointer size is too small for an existing table, you can change the options with ALTER TABLE to increase a table's maximum permissible size. ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only ... The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
For example, if an NDB Cluster has 4 data nodes, then the ALTER TABLESPACE statement just shown creates 4 data files, 1 each in the data directory of each of the 4 data nodes; each of these files is named data_2.dat, and each file is 48 MB in size.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-run-chat.html
Running the Chat To run GenAI Chat, perform the following steps: Optionally, to speed up vector processing, load the vector store or embedding tables that you want use with GenAI Chat in MySQL AI Engine: mysql> ALTER TABLE TableName SECONDARY_LOAD; ...GenAI Chat also lets you use your own embedding tables for context ... When ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
This applies to statements such as UPDATE, INSERT, or DELETE (as before), but now also to statements such as ALTER TABLE and LOAD DATA. For example, BENCHMARK(10, (SELECT * FROM t)) fails if the table t has more than one column or more than one row.
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/alter-database.html
TEMPORARY tables; it is possible to create, alter, drop, and write to TEMPORARY tables in a read-only database. alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | ...If the database name is omitted, the statement applies to the default ...