Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.4Mb
PDF (A4) - 40.5Mb
PDF (RPM) - 39.8Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 244.2Kb
Man Pages (Zip) - 349.3Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  Options, Variables, and Parameters Added, Deprecated or Removed in NDB 8.0

23.1.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.

  • AllowUnresolvedHostNames: When false (default), failure by management node to resolve host name results in fatal error; when true, unresolved host names are reported as warnings only. Added in NDB 8.0.22.

  • 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.

  • PartitionsPerNode: Table partitions created on each data node. Added in NDB 8.0.23.

  • RequireEncryptedBackup: Whether backups must be encrypted (1 = encryption required, otherwise 0). Added in NDB 8.0.22.

  • 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.

MySQL Server Options and Variables Deprecated in NDB 8.0

The following mysqld system variables, status variables, and 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.