Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
Table-level options for controlling read from any replica and partition balance can be embedded in a table comment using NDB_TABLE. NDB_TABLE can be used in a table comment to set options relating to partition balance and whether the table is fully ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/cache-index.html
| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ... You can assign one or more indexes for one, several, or all ...| ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
Each table is normally partitioned into the same number of fragments as there are data nodes in the cluster. (This also means that DataMemory pages, once allocated to a given table, cannot be used by other tables.) Performing a data node recovery ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
Table::getDefaultNoPartitionsFlag() Description This method is used to find out whether the default number of partitions is used for the table. Table::getMinRows() Description This method gets the minimum number of rows that the table can hold, for ... This section provides information about the Table class, which models a database table in the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
ALGORITHM=INPLACE, REORGANIZE PARTITION does not work on tables that were created with the MAX_ROWS option. Keep in mind that using MAX_ROWS to set the number of partitions per table is deprecated, and you should use PARTITION_BALANCE instead; see ... In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
A frame is a subset of the current partition and the frame clause specifies how to define the subset. Frames are determined with respect to the current row, which enables a frame to move within a partition depending on the location of the current ...
https://dev.mysql.com/doc/refman/8.4/en/load-index.html
tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ... LOAD INDEX INTO CACHE applies only to MyISAM tables, including partitioned ...| ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [[AS] tbl_alias] [PARTITION (partition_name [, partition_name] ...)] [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] The DELETE statement deletes rows from tbl_name ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Column::getPartitionKey() Description This method is used to check whether the column is part of the table's partitioning key. A partitioning key is a set of attributes used to distribute the tuples onto the data nodes. An example where this would ... This section provides information about the Column class, which models a column in an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
DROP PARTITION with old_alter_table=ON rebuilds the partitioned table and attempts to move data from the dropped partition to another partition with a compatible PARTITION ... DROP PARTITION with old_alter_table=ON deletes data stored in the ... The ...