Additional languages
MySQL 5.1 Reference Manual :: 15 MySQL Cluster :: 15.11 MySQL Cluster Disk Data Tables :: 15.11.3 Disk Data Configuration Parameters
« 15.11.2 Disk Data Storage Requirements
15.12 Using High-Speed Interconnects with MySQL Cluster »
Section Navigation      [Toggle]

15.11.3. Disk Data Configuration Parameters

Configuration parameters affecting Disk Data behaviour include the following:

  • DiskPageBufferMemory

    This determines the amount of space used for caching pages on disk, and is set in the [NDBD] or [NDBD DEFAULT] section of the config.ini file. It is measured in bytes. Each page takes up 32 KB. This means that Cluster Disk Data storage always uses N * 32 KB memory where N is some non-negative integer.

  • SharedGlobalMemory

    This determines the amount of memory that is used for log buffers, disk operations (such as page requests and wait queues), and metadata for tablespaces, log file groups, UNDO files, and data files. It can be set in the [NDBD] or [NDBD DEFAULT] section of the config.ini configuration file, and is measured in bytes.

    The default value is 20M.

Note

The OPTIMIZE TABLE statement does not have any effect on Disk Data tables.