Skip navigation links
17.3.4.2 MySQL Server Options for MySQL Cluster »
Section Navigation      [Toggle]

17.3.4.1. MySQL Cluster mysqld 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.13. MySQL Server Option and Variable Reference 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_api_bytes_received_count       Yes Global No
Ndb_api_bytes_received_count_session       Yes Session No
Ndb_api_bytes_received_count_slave       Yes Global No
Ndb_api_bytes_sent_count       Yes Global No
Ndb_api_bytes_sent_count_session       Yes Session No
Ndb_api_bytes_sent_count_slave       Yes Global No
Ndb_api_event_bytes_count       Yes Global No
Ndb_api_event_bytes_count_injector       Yes Global No
Ndb_api_event_data_count       Yes Global No
Ndb_api_event_data_count_injector       Yes Global No
Ndb_api_event_nondata_count       Yes Global No
Ndb_api_event_nondata_count_injector       Yes Global No
Ndb_api_pk_op_count       Yes Global No
Ndb_api_pk_op_count_session       Yes Session No
Ndb_api_pk_op_count_slave       Yes Global No
Ndb_api_pruned_scan_count       Yes Global No
Ndb_api_pruned_scan_count_session       Yes Session No
Ndb_api_pruned_scan_count_slave       Yes Global No
Ndb_api_range_scan_count       Yes Global No
Ndb_api_range_scan_count_session       Yes Session No
Ndb_api_range_scan_count_slave       Yes Global No
Ndb_api_read_row_count       Yes Global No
Ndb_api_read_row_count_session       Yes Session No
Ndb_api_read_row_count_slave       Yes Global No
Ndb_api_scan_batch_count       Yes Global No
Ndb_api_scan_batch_count_session       Yes Session No
Ndb_api_scan_batch_count_slave       Yes Global No
Ndb_api_table_scan_count       Yes Global No
Ndb_api_table_scan_count_session       Yes Session No
Ndb_api_table_scan_count_slave       Yes Global No
Ndb_api_trans_abort_count       Yes Global No
Ndb_api_trans_abort_count_session       Yes Session No
Ndb_api_trans_abort_count_slave       Yes Global No
Ndb_api_trans_close_count       Yes Global No
Ndb_api_trans_close_count_session       Yes Session No
Ndb_api_trans_close_count_slave       Yes Global No
Ndb_api_trans_commit_count       Yes Global No
Ndb_api_trans_commit_count_session       Yes Session No
Ndb_api_trans_commit_count_slave       Yes Global No
Ndb_api_trans_local_read_row_count       Yes Global No
Ndb_api_trans_local_read_row_count_session       Yes Session No
Ndb_api_trans_local_read_row_count_slave       Yes Global No
Ndb_api_trans_start_count       Yes Global No
Ndb_api_trans_start_count_session       Yes Session No
Ndb_api_trans_start_count_slave       Yes Global No
Ndb_api_uk_op_count       Yes Global No
Ndb_api_uk_op_count_session       Yes Session No
Ndb_api_uk_op_count_slave       Yes Global No
Ndb_api_wait_exec_complete_count       Yes Global No
Ndb_api_wait_exec_complete_count_session       Yes Session No
Ndb_api_wait_exec_complete_count_slave       Yes Global No
Ndb_api_wait_meta_request_count       Yes Global No
Ndb_api_wait_meta_request_count_session       Yes Session No
Ndb_api_wait_meta_request_count_slave       Yes Global No
Ndb_api_wait_nanos_count       Yes Global No
Ndb_api_wait_nanos_count_session       Yes Session No
Ndb_api_wait_nanos_count_slave       Yes Global No
Ndb_api_wait_scan_result_count       Yes Global No
Ndb_api_wait_scan_result_count_session       Yes Session No
Ndb_api_wait_scan_result_count_slave       Yes Global No
ndb_autoincrement_prefetch_sz Yes Yes Yes   Both Yes
ndb-batch-size Yes Yes Yes   Global No
ndb-blob-read-batch-bytes Yes Yes Yes   Both Yes
ndb-blob-write-batch-bytes Yes Yes Yes   Both Yes
ndb_cache_check_time Yes Yes Yes   Global Yes
ndb-cluster-connection-pool Yes Yes Yes Yes Global No
Ndb_cluster_node_id       Yes Both No
Ndb_config_from_host       Yes Both No
Ndb_conflict_fn_epoch       Yes Global No
Ndb_conflict_fn_epoch_trans       Yes Global No
Ndb_conflict_fn_max       Yes Global No
Ndb_conflict_fn_old       Yes Global No
Ndb_conflict_trans_conflict_commit_count       Yes Global No
Ndb_conflict_trans_detect_iter_count       Yes Global No
Ndb_conflict_trans_reject_count       Yes Global No
Ndb_conflict_trans_row_conflict_count       Yes Global No
Ndb_conflict_trans_row_reject_count       Yes Global No
ndb-connectstring Yes Yes        
ndb-deferred-constraints Yes Yes     Both Yes
- Variable: ndb_deferred_constraints     Yes   Both Yes
ndb_deferred_constraints Yes Yes Yes   Both Yes
ndb_distribution Yes Yes Yes   Both Yes
ndb-distribution Yes Yes     Both Yes
- Variable: ndb_distribution     Yes   Both 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_join_pushdown     Yes   Global No
ndb-log-apply-status Yes Yes     Global No
- Variable: ndb_log_apply_status     Yes   Global No
ndb_log_bin Yes   Yes   Both Yes
ndb_log_binlog_index Yes   Yes   Global Yes
ndb_log_empty_epochs Yes Yes Yes   Global Yes
ndb-log-empty-epochs Yes Yes Yes   Global Yes
ndb_log_orig     Yes   Global No
ndb-log-transaction-id Yes Yes     Global No
- Variable: ndb_log_transaction_id     Yes   Global No
ndb_log_transaction_id     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_pushed_queries_defined       Yes Global No
Ndb_pushed_queries_dropped       Yes Global No
Ndb_pushed_queries_executed       Yes Global No
ndb_pushed_reads       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   Global No
ndb-wait-setup Yes Yes Yes   Global No
ndbcluster Yes Yes        
- Variable: have_ndbcluster            
ndbinfo_database     Yes   Global No
ndbinfo_max_bytes Yes   Yes   Both Yes
ndbinfo_max_rows Yes   Yes   Both Yes
ndbinfo_show_hidden Yes   Yes   Both Yes
ndbinfo_table_prefix Yes   Yes   Both Yes
ndbinfo_version     Yes   Global No
server-id-bits Yes Yes     Global No
- Variable: server_id_bits     Yes   Global No
skip-ndbcluster Yes Yes        
slave_allow_batching Yes Yes Yes   Global Yes
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices