Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 27.1Mb
PDF (A4) - 27.2Mb
PDF (RPM) - 25.6Mb
HTML Download (TGZ) - 6.4Mb
HTML Download (Zip) - 6.5Mb
HTML Download (RPM) - 5.5Mb
Man Pages (TGZ) - 159.1Kb
Man Pages (Zip) - 262.7Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
Excerpts from this Manual

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

18.1.5 Options, Variables, and Parameters Added, Deprecated or Removed in NDB 7.2

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

Node Configuration Parameters Introduced in NDB 7.2

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

  • ConnectBackoffMaxTime: Specifies longest time in milliseconds (~100ms resolution) to allow between connection attempts to any given data node by this API node. Excludes time elapsed while connection attempts are ongoing, which in worst case can take several seconds. Disable by setting to 0. If no data nodes are currently connected to this API node, StartConnectBackoffMaxTime is used instead. Added in NDB 7.2.18.

  • CrashOnCorruptedTuple: When enabled, forces node to shut down whenever it detects a corrupted tuple. Added in NDB 7.2.1.

  • DefaultHashMapSize: Set size (in buckets) to use for table hash maps. Three values are supported: 0, 240, and 3840. Intended primarily for upgrades and downgrades within NDB 7.2. Added in NDB 7.2.11.

  • DefaultHashMapSize: Set size (in buckets) to use for table hash maps. Three values are supported: 0, 240, and 3840. Intended primarily for upgrades and downgrades within NDB 7.2. Added in NDB 7.2.11.

  • DiskPageBufferEntries: Number of 32K page entries to allocate in DiskPageBufferMemory. Very large disk transactions may require increasing this value. Added in NDB 7.2.19.

  • ExtraSendBufferMemory: Memory to use for send buffers in addition to any allocated by TotalSendBufferMemory or SendBufferMemory. Default (0) allows up to 16MB. Added in NDB 7.2.14.

  • ExtraSendBufferMemory: Memory to use for send buffers in addition to any allocated by TotalSendBufferMemory or SendBufferMemory. Default (0) allows up to 16MB. Added in NDB 7.2.14.

  • ExtraSendBufferMemory: Memory to use for send buffers in addition to any allocated by TotalSendBufferMemory or SendBufferMemory. Default (0) allows up to 16MB. Added in NDB 7.2.5.

  • HeartbeatIntervalMgmdMgmd: Time between management node-to-management node heartbeats; the connection between management node is considered lost after 3 missed heartbeats. Added in NDB 7.2.12.

  • IndexStatAutoCreate: Enable/disable automatic statistics collection when indexes are created. Added in NDB 7.2.1.

  • IndexStatAutoUpdate: Monitor indexes for changes and trigger automatic statistics updates Added in NDB 7.2.1.

  • IndexStatSaveScale: Scaling factor used in determining size of stored index statistics. Added in NDB 7.2.1.

  • IndexStatSaveSize: Maximum size in bytes for saved statistics per index. Added in NDB 7.2.1.

  • IndexStatTriggerPct: Threshold percent change in DML operations for index statistics updates. The value is scaled down by IndexStatTriggerScale. Added in NDB 7.2.1.

  • IndexStatTriggerScale: Scale down IndexStatTriggerPct by this amount, multiplied by the base 2 logarithm of the index size, for a large index. Set to 0 to disable scaling. Added in NDB 7.2.1.

  • IndexStatUpdateDelay: Minimum delay between automatic index statistics updates for a given index. 0 means no delay. Added in NDB 7.2.1.

  • LcpScanProgressTimeout: Maximum time that local checkpoint fragment scan can be stalled before node is shut down to ensure systemwide LCP progress. Use 0 to disable. Added in NDB 7.2.14.

  • MaxBufferedEpochBytes: Total number of bytes allocated for buffering epochs. Added in NDB 7.2.13.

  • MinFreePct: The percentage of memory resources to keep in reserve for restarts. Added in NDB 7.2.3.

  • NoOfFragmentLogParts: Number of redo log file groups belonging to this data node; value must be an even multiple of 4. Added in NDB 7.2.5.

  • RestartSubscriberConnectTimeout: Amount of time for data node to wait for subscribing API nodes to connect. Set to 0 to disable timeout, which is always resolved to nearest full second. Added in NDB 7.2.17.

  • StartConnectBackoffMaxTime: Same as ConnectBackoffMaxTime except that this parameter is used in its place if no data nodes are connected to this API node. Added in NDB 7.2.18.

  • ThreadConfig: Used for configuration of multithreaded data nodes (ndbmtd). Default is an empty string; see documentation for syntax and other information. Added in NDB 7.2.3.

  • TimeBetweenGlobalCheckpointsTimeout: Minimum timeout for group commit of transactions to disk Added in NDB 7.2.20.

Node Configuration Parameters Deprecated in NDB 7.2

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

  • ReservedSendBufferMemory: This parameter is present in NDB code but is not enabled, and is now deprecated.. Deprecated as of NDB 7.2.5.

MySQL Server Options and Variables Removed in NDB 7.2

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

MySQL Server Options and Variables Introduced in NDB 7.2

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

  • Ndb_conflict_fn_epoch: Number of rows that have been found in conflict by the NDB$EPOCH() conflict detection function Added in NDB 7.2.1.

  • Ndb_conflict_fn_epoch_trans: Number of rows that have been found in conflict by the NDB$EPOCH_TRANS() conflict detection function Added in NDB 7.2.1.

  • Ndb_conflict_trans_conflict_commit_count: Number of epoch transactions committed after requiring transactional conflict handling Added in NDB 7.2.1.

  • Ndb_conflict_trans_detect_iter_count: Number of internal iterations required to commit an epoch transaction. Should be (slightly) greater than or equal to Ndb_conflict_trans_conflict_commit_count Added in NDB 7.2.1.

  • Ndb_conflict_trans_reject_count: Number of transactions rejected after being found in conflict by a transactional conflict function Added in NDB 7.2.1.

  • Ndb_conflict_trans_row_reject_count: Total number of rows realigned after being found in conflict by a transactional conflict function. Includes Ndb_conflict_trans_row_conflict_count and any rows included in or dependent on conflicting transactions. Added in NDB 7.2.1.

  • Ndb_pushed_queries_defined: Number of joins that API nodes have attempted to push down to the data nodes Added in NDB 7.2.0.

  • Ndb_pushed_queries_dropped: Number of joins that API nodes have tried to push down, but failed Added in NDB 7.2.0.

  • Ndb_pushed_queries_executed: Number of joins successfully pushed down and executed on the data nodes Added in NDB 7.2.0.

  • Ndb_pushed_reads: Number of reads executed on the data nodes by pushed-down joins Added in NDB 7.2.0.

  • ndb-log-transaction-id: Write NDB transaction IDs in the binary log. Requires --log-bin-v1-events=OFF. Added in NDB 7.2.1.

  • ndb-transid-mysql-connection-map: Enable or disable the ndb_transid_mysql_connection_map plugin; that is, enable or disable the INFORMATION_SCHEMA table having that name Added in NDB 7.2.2.

  • ndb_eventbuffer_max_alloc: Maximum memory that can be allocated for buffering events by the NDB API. Defaults to 0 (no limit). Added in NDB 7.2.14.

  • ndb_index_stat_option: Comma-separated list of tunable options for NDB index statistics; the list should contain no spaces Added in NDB 7.2.1.

  • ndb_join_pushdown: Enables pushing down of joins to data nodes Added in NDB 7.2.0.

  • ndb_log_transaction_id: Whether NDB transaction IDs are written into the binary log (Read-only.) Added in NDB 7.2.1.

MySQL Server Options and Variables Deprecated in NDB 7.2

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

Node Configuration Parameters Removed in NDB 7.2

No node configuration parameters have been removed from NDB 7.2.