25.6.11 NDB Cluster Disk Data Tables (original) (raw)

25.6.11 NDB Cluster Disk Data Tables

NDB Cluster supports storing nonindexed columns ofNDB tables on disk, rather than in RAM. Column data and logging metadata are kept in data files and undo log files, conceptualized as tablespaces and log file groups, as described in the next section—seeSection 25.6.11.1, “NDB Cluster Disk Data Objects”.

NDB Cluster Disk Data performance can be influenced by a number of configuration parameters. For information about these parameters and their effects, seeDisk Data Configuration Parameters, andDisk Data and GCP Stop errors.

You should also set theDiskDataUsingSameDisk data node configuration parameter to false when using separate disks for Disk Data files.

See alsoDisk Data file system parameters.

NDB 8.0 provides improved support when using Disk Data tables with solid-state drives, in particular those using NVMe. See the following documentation for more information:

• Disk Data latency parameters
• Section 25.6.16.31, “The ndbinfo diskstat Table”
• Section 25.6.16.32, “The ndbinfo diskstats_1sec Table”
• Section 25.6.16.49, “The ndbinfo pgman_time_track_stats Table”