Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
ndb-allow-copying-alter-table: Set to OFF to keep ALTER TABLE from using copying operations on NDB tables. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} with CREATE TABLE or ALTER TABLE to enable ...ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table ... The following list ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
ndb-allow-copying-alter-table: Set to OFF to keep ALTER TABLE from using copying operations on NDB tables. ndb_read_backup: Enable read from any replica for all NDB tables; use NDB_TABLE=READ_BACKUP={0|1} with CREATE TABLE or ALTER TABLE to enable ...ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
mysql> CREATE EXTERNAL TABLE table_1( col_1 int, col_2 int, col_3 int) FILE_FORMAT = (FORMAT csv) FILES = (URI = 'oci://mybucket@mynamespace/data_files/data_file_1.csv') AUTO_REFRESH_SOURCE = 'ocid1.stream.oc1.iad...'; mysql> ALTER TABLE table_1 ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
However, the order of the column names in the partitioning column list and the value lists does not have to be the same as the order of the table column definitions in the main part of the CREATE TABLE statement. As with table partitioned by RANGE, ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
When performing ALTER TABLE operations, mysqld creates intermediate tables (whose names are prefixed with #sql-). To cause indexes to be ignored when restoring the table data, use the --disable-indexes option. When the --epoch option (short form: ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
In addition, for each table, the ALTER TABLE statement should be followed by an OPTIMIZE TABLE to reclaim wasted space. However, in NDBCLUSTER tables that existed prior to the addition of the new nodes, neither existing nor new data is distributed ...You can verify that all existing data nodes were restarted using the updated configuration by checking the ndbinfo.nodes table in the mysql ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
In this release, the use of any such columns in the proposed partitioning key is now expressly disallowed, and causes the CREATE TABLE or ALTER TABLE statement in which it occurs to be rejected with an error. Attempting to use these together in ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
It is also possible to convert existing tables that use other storage engines to NDBCLUSTER using one or more ALTER TABLE statement. See Section 25.6.11, “NDB Cluster Disk Data Tables”, for more information. You must also remember to account for ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
In some extreme cases, you can create the indexes even faster by turning them off with ALTER TABLE ... DISABLE KEYS before loading the file into the table and re-creating the indexes with ALTER TABLE ... INTO Statement”.) To write data from a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
| | Sufficient HeatWave cluster memory available to load all tables. If Auto Parallel Load fails with an error, inspect the errors with a query to the heatwave_autopilot_report table. mysql> SELECT log FROM sys.heatwave_autopilot_report WHERE ...