Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.1Mb
PDF (A4) - 43.2Mb
Man Pages (TGZ) - 295.4Kb
Man Pages (Zip) - 400.6Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

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

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

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.

  • AutomaticThreadConfig: Use automatic thread configuration; overrides any settings for ThreadConfig and MaxNoOfExecutionThreads, and disables ClassicFragmentation. Added in NDB 8.0.23.

  • ClassicFragmentation: When true, use traditional table fragmentation; set false to enable flexible distribution of fragments among LDMs. Disabled by AutomaticThreadConfig. Added in NDB 8.0.23.

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

  • EnableMultithreadedBackup: Enable multi-threaded backup. Added in NDB 8.0.16.

  • EncryptedFileSystem: Encrypt local checkpoint and tablespace files. EXPERIMENTAL; NOT SUPPORTED IN PRODUCTION. Added in NDB 8.0.29.

  • KeepAliveSendInterval: Time between keep-alive signals on links between data nodes, in milliseconds. Set to 0 to disable. Added in NDB 8.0.27.

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

  • NumCPUs: Specify number of CPUs to use with AutomaticThreadConfig. Added in NDB 8.0.23.

  • PartitionsPerNode: Determines the number of table partitions created on each data node; not used if ClassicFragmentation is enabled. Added in NDB 8.0.23.

  • PreferIPVersion: Indicate DNS resolver preference for IP version 4 or 6. Added in NDB 8.0.26.

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

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 in NDB 8.0.19.

  • MaxAllocate: No longer used; has no effect. Deprecated in NDB 8.0.27.

  • MaxNoOfConcurrentIndexOperations: Total number of index operations that can execute simultaneously on one data node. Deprecated in 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 in NDB 8.0.19.

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

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

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

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

  • UndoDataBuffer: Unused; has no effect. Deprecated in NDB 8.0.27.

  • UndoIndexBuffer: Unused; has no effect. Deprecated in NDB 8.0.27.

Parameters Removed in NDB 8.0

No node configuration parameters have been removed in NDB 8.0.

Options and Variables Introduced in NDB 8.0

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

Options and Variables Deprecated in NDB 8.0

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

Options and Variables Removed in NDB 8.0

The following 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.