MySQL NDB Cluster 8.0  /  NDB Cluster Overview  /  Options, Variables, and Parameters Added, Deprecated or Removed in NDB 8.0

3.5 Options, Variables, and Parameters Added, Deprecated or Removed in NDB 8.0

The next few sections contain information about NDB node configuration parameters and NDB-specific mysqld options and variables that have been added to, deprecated in, or removed from NDB 8.0.

Node Configuration Parameters Introduced in NDB 8.0

The following node configuration parameters have been added in NDB 8.0.

  • DiskDataUsingSameDisk: Set to false if Disk Data tablespaces are located on separate physical disks. Added in NDB 8.0.19.

  • MaxDiskDataLatency: Maximum allowed mean latency of disk access (ms) before starting to abort transactions. Added in NDB 8.0.19.

  • NodeGroupTransporters: Number of transporters to use between nodes in same node group. Added in NDB 8.0.20.

  • ReservedConcurrentIndexOperations: Number of simultaneous index operations having dedicated resources on one data node. Added in NDB 8.0.16.

  • ReservedConcurrentOperations: Number of simultaneous operations having dedicated resources in transaction coordinators on one data node. Added in NDB 8.0.16.

  • ReservedConcurrentScans: Number of simultaneous scans having dedicated resources on one data node. Added in NDB 8.0.16.

  • ReservedConcurrentTransactions: Number of simultaneous transactions having dedicated resources on one data node. Added in NDB 8.0.16.

  • ReservedFiredTriggers: Number of triggers having dedicated resources on one data node. Added in NDB 8.0.16.

  • ReservedLocalScans: Number of simultaneous fragment scans having dedicated resources on one data node. Added in NDB 8.0.16.

  • ReservedTransactionBufferMemory: Dynamic buffer space (in bytes) for key and attribute data allocated to each data node. Added in NDB 8.0.16.

  • SpinMethod: Determines spin method used by data node; see documentation for details. Added in NDB 8.0.20.

  • TcpSpinTime: Time to spin before going to sleep when receiving. Added in NDB 8.0.20.

  • TransactionMemory: Memory allocated for transactions on each data node. Added in NDB 8.0.19.

Node Configuration Parameters Deprecated in NDB 8.0

The following node configuration parameters have been deprecated in NDB 8.0.

  • BatchSizePerLocalScan: Used to calculate number of lock records for scan with hold lock. Deprecated as of NDB 8.0.19.

  • MaxNoOfConcurrentIndexOperations: Total number of index operations that can execute simultaneously on one data node. Deprecated as of NDB 8.0.19.

  • MaxNoOfConcurrentTransactions: Maximum number of transactions executing concurrently on this data node, total number of transactions that can be executed concurrently is this value times number of data nodes in cluster. Deprecated as of NDB 8.0.19.

  • MaxNoOfFiredTriggers: Total number of triggers that can fire simultaneously on one data node. Deprecated as of NDB 8.0.19.

  • MaxNoOfLocalOperations: Maximum number of operation records defined on this data node. Deprecated as of NDB 8.0.19.

  • MaxNoOfLocalScans: Maximum number of fragment scans in parallel on this data node. Deprecated as of NDB 8.0.19.

  • ReservedTransactionBufferMemory: Dynamic buffer space (in bytes) for key and attribute data allocated to each data node. Deprecated as of NDB 8.0.19.

Node Configuration Parameters Removed in NDB 8.0

No node configuration parameters have been removed from NDB 8.0.

MySQL Server Options and Variables Introduced in NDB 8.0

The following mysqld system variables, status variables, and options have been added in NDB 8.0.

  • Ndb_metadata_blacklist_size: Number of NDB metadata objects that NDB binlog thread has failed to synchronize; renamed in NDB 8.0.22 as Ndb_metadata_excluded_count. Added in NDB 8.0.18.

  • Ndb_metadata_detected_count: Number of times NDB metadata change monitor thread has detected changes. Added in NDB 8.0.16.

  • Ndb_metadata_excluded_count: Number of NDB metadata objects that NDB binlog thread has failed to synchronize. Added in NDB 8.0.22.

  • Ndb_metadata_synced_count: Number of NDB metadata objects which have been synchronized. Added in NDB 8.0.18.

  • Ndb_trans_hint_count_session: Number of transactions using hints that have been started in this session. Added in NDB 8.0.17.

  • ndb-log-fail-terminate: Terminate mysqld process if complete logging of all found row events is not possible. Added in NDB 8.0.21.

  • ndb-schema-dist-timeout: How long to wait before detecting timeout during schema distribution. Added in NDB 8.0.17.

  • ndb_dbg_check_shares: Check for any lingering shares (debug builds only). Added in NDB 8.0.13.

  • ndb_metadata_check: Enable auto-detection of NDB metadata changes with respect to MySQL data dictionary; enabled by default. Added in NDB 8.0.16.

  • ndb_metadata_check_interval: Interval in seconds to perform check for NDB metadata changes with respect to MySQL data dictionary. Added in NDB 8.0.16.

  • ndb_schema_dist_lock_wait_timeout: Time during schema distribution to wait for lock before returning error. Added in NDB 8.0.18.

  • ndb_schema_dist_timeout: Time to wait before detecting timeout during schema distribution. Added in NDB 8.0.16.

  • ndb_schema_dist_upgrade_allowed: Allow schema distribution table upgrade when connecting to NDB. Added in NDB 8.0.17.

  • ndbinfo: Enable ndbinfo plugin, if supported. Added in NDB 8.0.13.

MySQL Server Options and Variables Deprecated in NDB 8.0

No system variables, status variables, or options have been deprecated in NDB 8.0.

MySQL Server Options and Variables Removed in NDB 8.0

The following mysqld system variables, status variables, and options have been removed in NDB 8.0.

  • Ndb_metadata_blacklist_size: Number of NDB metadata objects that NDB binlog thread has failed to synchronize; renamed in NDB 8.0.22 as Ndb_metadata_excluded_count. Removed in NDB 8.0.22.