Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-storage-requirements.html
Note The OPTIMIZE TABLE statement does not have any effect on Disk Data tables. The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this is equal to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-importing-data.html
You should be aware that the methods described previously in this section are not optimized for very large data sets or large transactions. It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
However, this memory can be made available for general re-use by performing OPTIMIZE TABLE. In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard MySQL. Memory consumed when ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
In such cases, statistical information is not generated, which means a nonoptimal execution plan may be selected. The other partitioning extensions to ALTER TABLE—ADD PARTITION, REORGANIZE PARTITION, and COALESCE PARTITION—are supported for NDB ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
NDB API applications can read the values of the counters for use in optimization or monitoring. A number of types of statistical counters relating to actions performed by or affecting Ndb objects are available. Such actions include starting and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-innodb-engines.html
The NDB storage engine is implemented using a distributed, shared-nothing architecture, which causes it to behave differently from InnoDB in a number of ways. For those unaccustomed to working with NDB, unexpected behaviors can arise due to its ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
SpinMethod Version (or later) NDB 8.4.0 Type or units enumeration Default StaticSpinning Range CostBasedSpinning, LatencyOptimisedSpinning, DatabaseMachineSpinning, StaticSpinning Restart Type Node Restart: Requires a rolling restart of the cluster.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memory-per-fragment.html
OPTIMIZE TABLE can be used to defragment a table's variable-sized pages; this moves row variable-sized parts between pages so that some whole pages can be freed for re-use. memory_per_fragment Table: Notes memory_per_fragment Table: Examples The ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-operations.html
This does not perform any defragmentation, which requires an OPTIMIZE TABLE or null ALTER TABLE statement. MySQL NDB Cluster supports online table schema changes using ALTER TABLE ... NDB Cluster handles COPY and INPLACE as described in the next ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
SchedulerResponsiveness: Set NDB scheduler response optimization 0-10; higher values provide better response time but lower throughput. The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections ...