17.3.4.1 MySQL Cluster Server Option and Variable Reference

The following table provides a list of the command-line options, server and status variables applicable within mysqld when it is running as an SQL node in a MySQL Cluster. For a table showing all command-line options, server and status variables available for use with mysqld, see Section 5.1.1, “Server Option and Variable Reference”.

Table 17.8 MySQL Cluster mysqld Options and Variables: MySQL 5.0

Option or Variable NameCommand LineSystem VariableScope
Option FileStatus VariableDynamic
Notes

Handler_discover

NNBoth
NYN

The number of times that tables have been discovered

ndb_autoincrement_prefetch_sz

YYBoth
YNY

NDB auto-increment prefetch size

ndb_cache_check_time

YYGlobal
YNY

The number of milliseconds between checks of cluster SQL nodes made by the MySQL query cache

ndb_force_send

YYBoth
YNY

Forces sending of buffers to NDB immediately, without waiting for other threads

ndb_use_exact_count

NYBoth
NNY

Use exact row count when planning queries

ndb-nodeid

YNGlobal
YYN

MySQL Cluster node ID for this MySQL server

ndb-mgmd-host

YN 
YNN

Set the host (and port, if desired) for connecting to the management server

ndbcluster

YN 
YNN

Enable NDB Cluster (if this version of MySQL supports it)

have_ndbcluster

NYGlobal
NNN

Whether mysqld supports NDB Cluster tables (set by --ndbcluster option)

ndb_index_stat_cache_entries

YN 
YNN

Sets the granularity of the statistics by determining the number of starting and ending keys

ndb_index_stat_enable

YN 
YNN

Use NDB index statistics in query optimization

ndb_index_stat_update_freq

YN 
YNN

How often to query data nodes instead of the statistics cache

ndb_optimized_node_selection

YN 
YNN

Determines how an SQL node chooses a cluster data node to use as transaction coordinator

ndb_report_thresh_binlog_epoch_slip

YN 
YNN

This is a threshold on the number of epochs to be behind before reporting binlog status

ndb_report_thresh_binlog_mem_usage

YN 
YNN

This is a threshold on the percentage of free memory remaining before reporting binlog status

ndb_use_transactions

YYBoth
YNY

Forces NDB to use a count of records during SELECT COUNT(*) query planning to speed up this type of query

Ndb_cluster_node_id

NNBoth
NYN

If the server is acting as a MySQL Cluster node, then the value of this variable its node ID in the cluster

Ndb_config_from_host

NNBoth
NYN

The host name or IP address of the Cluster management server. Formerly Ndb_connected_host

Ndb_config_from_port

NNBoth
NYN

The port for connecting to the Cluster management server. Formerly Ndb_connected_port

Com_show_ndb_status

NNBoth
NYN

Count of SHOW NDB STATUS statements