MySQL Cluster :: 3 MySQL Cluster Configuration :: 3.4 MySQL Server Options and Variables for MySQL Cluster :: 3.4.1 MySQL Cluster Server Option and Variable Reference
Section Navigation [Toggle]
- 3.4 MySQL Server Options and Variables for MySQL Cluster
- 3.4.1 MySQL Cluster Server Option and Variable Reference
- 3.4.2 mysqld Command Options for MySQL Cluster
- 3.4.3 MySQL Cluster System Variables
- 3.4.4 MySQL Cluster Status Variables
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
Server Option and Variable Reference.
Table 3.8. Command Options for MySQL Cluster
| Name | Cmd-Line | Option file | System Var | Status Var | Var Scope | Dynamic |
|---|---|---|---|---|---|---|
| Handler_discover | Yes | Both | No | |||
| have_ndbcluster | Yes | Global | No | |||
| ndb_autoincrement_prefetch_sz | Yes | Yes | Yes | Both | Yes | |
| ndb-batch-size | Yes | Yes | Yes | Global | No | |
| ndb_cache_check_time | Yes | Yes | Yes | Global | Yes | |
| ndb-cluster-connection-pool | Yes | Yes | Yes | Global | No | |
| Ndb_cluster_node_id | Yes | Both | No | |||
| Ndb_config_from_host | Yes | Both | No | |||
| Ndb_config_from_port | Yes | Both | No | |||
| Ndb_conflict_fn_max | Yes | Global | No | |||
| Ndb_conflict_fn_old | Yes | Global | No | |||
| ndb-connectstring | Yes | Yes | ||||
| ndb_execute_count | Yes | Global | No | |||
| ndb_extra_logging | Yes | Yes | Yes | Global | Yes | |
| ndb_force_send | Yes | Yes | Yes | Both | Yes | |
| ndb_index_stat_cache_entries | Yes | Yes | ||||
| ndb_index_stat_enable | Yes | Yes | ||||
| ndb_index_stat_update_freq | Yes | Yes | ||||
| ndb_log_empty_epochs | Yes | Yes | Yes | Global | Yes | |
| ndb_log_orig | Yes | Global | No | |||
| ndb-log-update-as-write | Yes | Yes | Yes | Global | Yes | |
| ndb_log_updated_only | Yes | Yes | Yes | Global | Yes | |
| ndb-mgmd-host | Yes | Yes | ||||
| ndb-nodeid | Yes | Yes | Yes | Global | No | |
| Ndb_number_of_data_nodes | Yes | Global | No | |||
| ndb_optimization_delay | Yes | Global | Yes | |||
| ndb_optimized_node_selection | Yes | Yes | ||||
| ndb_pruned_scan_count | Yes | Global | No | |||
| ndb_report_thresh_binlog_epoch_slip | Yes | Yes | ||||
| ndb_report_thresh_binlog_mem_usage | Yes | Yes | ||||
| ndb_scan_count | Yes | Global | No | |||
| ndb_table_no_logging | Yes | Session | Yes | |||
| ndb_table_temporary | Yes | Session | Yes | |||
| ndb_use_copying_alter_table | Yes | Both | No | |||
| ndb_use_exact_count | Yes | Both | Yes | |||
| ndb_use_transactions | Yes | Yes | Yes | Both | Yes | |
| ndb_wait_connected | Yes | Yes | Yes | No | ||
| ndb-wait-setup | Yes | Yes | Yes | No | ||
| ndbcluster | Yes | Yes | ||||
| - Variable: have_ndbcluster | ||||||
| skip-ndbcluster | Yes | Yes | ||||
| slave-allow-batching | Yes | Yes | Global | Yes | ||
| - Variable: slave_allow_batching | Yes | Global | Yes |
