MySQL Server Version Reference  /  mysqld Option/Variable Reference  /  Option/Variable Changes for mysqld 5.1

1.2 Option/Variable Changes for mysqld 5.1

The list below details the changes in specific options/variables within MySQL 5.1

  • bdb-data-direct

    Introduced in version 5.1.4

  • bdb-log-direct

    Introduced in version 5.1.4

  • binlog_direct_non_transactional_updates

    Introduced in version 5.1.44

  • binlog-format

    Introduced in version 5.1.5

    Value parameter changes in version 5.1.8:

    • Default is STATEMENT

    Value parameter changes in version 5.1.12:

    • Default is MIXED

    Value parameter changes in version 5.1.29:

    • Default is STATEMENT

    Value parameter changes in version 5.1.14-ndb-6.1.0:

    • Default is MIXED

    Value parameter changes in version 5.1.16-ndb-6.2.0:

    • Default is MIXED

    Value parameter changes in version 5.1.19-ndb-6.3.0:

    • Default is MIXED

    Value parameter changes in version 5.1.32-ndb-7.0.4:

    • Default is MIXED

    Value parameter changes in version 5.1.39-ndb-7.1.0:

    • Default is MIXED

  • binlog-row-event-max-size

    Introduced in version 5.1.5

  • character-set-filesystem

    Introduced in version 5.1.6

  • Com_call_procedure

    Introduced in version 5.1.19

  • Com_show_logs

    Removed in version 5.1.3

  • Com_show_profile

    Introduced in version 5.1.24

  • Com_show_profiles

    Introduced in version 5.1.24

  • Com_stmt_reprepare

    Introduced in version 5.1.25

  • connect_timeout

    Value parameter changes in version 5.1.23:

    • Default is 10, minimum is 2, maximum is 31536000

  • debug_sync

    Introduced in version 5.1.41

  • debug-sync-timeout

    Introduced in version 5.1.41

  • enable-pstack

    Deprecated in version 5.1.54

  • event-scheduler

    Introduced in version 5.1.6

  • federated

    Introduced in version 5.1.26

  • general-log

    Introduced in version 5.1.12

  • general_log_file

    Introduced in version 5.1.12

  • have_archive

    Removed in version 5.1.14

  • have_blackhole_engine

    Removed in version 5.1.14

  • have_community_features

    Introduced in version 5.1.24

  • have_dynamic_loading

    Introduced in version 5.1.10

  • have_example_engine

    Removed in version 5.1.14

  • have_federated_engine

    Removed in version 5.1.14

  • have_isam

    Removed in version 5.1.7

  • have_merge_engine

    Removed in version 5.1.3

  • have_partition_engine

    Introduced in version 5.1.1

    Deprecated in version 5.1.6 and replaced with have_partitioning

  • have_partitioning

    Introduced in version 5.1.6

  • have_raid

    Removed in version 5.1.7

  • have_row_based_replication

    Introduced in version 5.1.5

    Removed in version 5.1.15

  • have_ssl

    Introduced in version 5.1.17

  • hostname

    Introduced in version 5.1.17

  • ignore-builtin-innodb

    Introduced in version 5.1.33

  • innodb

    Value parameter changes in version 5.1.36:

    • Default is ON

  • innodb_adaptive_flushing

    Introduced in version 5.1.38

  • innodb_adaptive_hash_index

    Introduced in version 5.1.24

  • innodb_autoinc_lock_mode

    Introduced in version 5.1.22

  • innodb_buffer_pool_awe_mem_mb

    Removed in version 5.1.13

  • Innodb_buffer_pool_read_ahead

    Introduced in version 5.1.42

  • Innodb_buffer_pool_read_ahead_evicted

    Introduced in version 5.1.42

  • innodb_buffer_pool_size

    Value parameter changes in version 5.1.28:

    • Default is 134217728, minimum is 1048576, maximum is 2**32-1

    Value parameter changes in version 5.1.28:

    • Default is 134217728, minimum is 1048576, maximum is 2**64-1

  • innodb_change_buffering

    Introduced in version 5.1.38

  • innodb_change_buffering_debug

    Introduced in version 5.1.53

  • innodb_file_format

    Introduced in version 5.1.38

  • innodb_file_format_check

    Introduced in version 5.1.38

    Value parameter changes in version 5.1.42:

    • Default is Barracuda

  • innodb_flush_method

    Value parameter changes in version 5.1.24:

    • Default is NULL

  • Innodb_have_atomic_builtins

    Introduced in version 5.1.38

  • innodb_io_capacity

    Introduced in version 5.1.38

  • innodb_limit_optimistic_insert_debug

    Introduced in version 5.1.68

  • innodb_log_arch_dir

    Removed in version 5.1.21

  • innodb_log_archive

    Removed in version 5.1.18

  • innodb_old_blocks_pct

    Introduced in version 5.1.41

  • innodb_old_blocks_time

    Introduced in version 5.1.41

  • innodb_random_read_ahead

    Introduced in version 5.1.59

  • innodb_read_ahead_threshold

    Introduced in version 5.1.38

  • innodb_read_io_threads

    Introduced in version 5.1.38

  • innodb_replication_delay

    Introduced in version 5.1.38

  • innodb_rollback_on_timeout

    Introduced in version 5.1.15

  • innodb_spin_wait_delay

    Introduced in version 5.1.38

  • innodb_stats_method

    Introduced in version 5.1.56

  • innodb_stats_on_metadata

    Introduced in version 5.1.17

  • innodb_stats_sample_pages

    Introduced in version 5.1.38

  • innodb_strict_mode

    Introduced in version 5.1.38

  • innodb_trx_purge_view_update_only_debug

    Introduced in version 5.1.68

  • innodb_trx_rseg_n_slots_debug

    Introduced in version 5.1.62

  • innodb_use_legacy_cardinality_algorithm

    Introduced in version 5.1.35

  • innodb_use_sys_malloc

    Introduced in version 5.1.38

  • innodb_version

    Introduced in version 5.1.38

  • innodb_write_io_threads

    Introduced in version 5.1.38

  • join_buffer_size

    Value parameter changes in version 5.1.23:

    • Default is 131072, minimum is 8200, maximum is 4294967295

    Value parameter changes in version 5.1.23:

    • Default is 131072, minimum is 8228, maximum is 4294967295

    Value parameter changes in version 5.1.23:

    • Default is 131072, minimum is 8200, maximum is 4294967295

    Value parameter changes in version 5.1.23:

    • Default is 131072, minimum is 8228, maximum is 18446744073709547520

  • keep_files_on_create

    Introduced in version 5.1.21

  • key_buffer_size

    Value parameter changes in version 5.1.23:

    • Default is 8388608, minimum is 8, maximum is 4294967295

    Value parameter changes in version 5.1.23:

    • Default is 8388608, minimum is 8, maximum is OS_PER_PROCESS_LIMIT

  • lc_time_names

    Introduced in version 5.1.12

  • log

    Deprecated in version 5.1.29 and replaced with general-log

  • log-bin-use-v1-row-events

    Introduced in version 5.1.56-ndb-7-0-27, 5.1.56-ndb-7.1.16

  • log_bin_use_v1_row_events

    Introduced in version 5.1.56-ndb-7-0-27, 5.1.56-ndb-7.1.16

  • log-output

    Introduced in version 5.1.6

  • log-slow-queries

    Deprecated in version 5.1.29 and replaced with slow-query-log

  • log-slow-slave-statements

    Introduced in version 5.1.21

  • master-connect-retry

    Deprecated in version 5.1.17

  • master-host

    Deprecated in version 5.1.17

  • master-password

    Deprecated in version 5.1.17

  • master-port

    Deprecated in version 5.1.17

  • master-ssl

    Deprecated in version 5.1.17

  • master-ssl-ca

    Deprecated in version 5.1.17

  • master-ssl-capath

    Deprecated in version 5.1.17

  • master-ssl-cert

    Deprecated in version 5.1.17

  • master-ssl-cipher

    Deprecated in version 5.1.17

  • master-ssl-key

    Deprecated in version 5.1.17

  • master-user

    Deprecated in version 5.1.17

  • max_binlog_cache_size

    Value parameter changes in version 5.1.36:

    • Default is 18446744073709547520, minimum is 4096, maximum is 18446744073709547520

  • max_connections

    Value parameter changes in version 5.1.15:

    • Default is 151, minimum is 1, maximum is 16384

    Value parameter changes in version 5.1.17:

    • Default is 151, minimum is 1, maximum is 100000

  • max_long_data_size

    Introduced in version 5.1.57

    Deprecated in version 5.1.57

  • max_prepared_stmt_count

    Introduced in version 5.1.10

  • merge

    Introduced in version 5.1.12

    Removed in version 5.1.14

  • min-examined-row-limit

    Introduced in version 5.1.21

  • myisam_mmap_size

    Introduced in version 5.1.43

  • myisam_use_mmap

    Introduced in version 5.1.4

  • Ndb_api_bytes_received_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_bytes_received_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_bytes_received_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_bytes_sent_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_bytes_sent_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_bytes_sent_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_event_bytes_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_event_bytes_count_injector

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_event_data_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_event_data_count_injector

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_event_nondata_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_event_nondata_count_injector

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_pk_op_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_pk_op_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_pk_op_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_pruned_scan_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_pruned_scan_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_pruned_scan_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_range_scan_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_range_scan_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_range_scan_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_read_row_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_read_row_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_read_row_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_scan_batch_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_scan_batch_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_scan_batch_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_table_scan_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_table_scan_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_table_scan_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_abort_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_abort_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_abort_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_close_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_close_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_close_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_commit_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_commit_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_commit_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_local_read_row_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_local_read_row_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_local_read_row_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_start_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_start_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_trans_start_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_uk_op_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_uk_op_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_uk_op_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_exec_complete_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_exec_complete_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_exec_complete_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_meta_request_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_meta_request_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_meta_request_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_nanos_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_nanos_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_nanos_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_scan_result_count

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_scan_result_count_session

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • Ndb_api_wait_scan_result_count_slave

    Introduced in version 5.1.51-ndb-7.0.22, 5.1.51-ndb-7.1.11

  • ndb_autoincrement_prefetch_sz

    Value parameter changes in version 5.1.1:

    • Default is 32, minimum is 1, maximum is 256

    Value parameter changes in version 5.1.23:

    • Default is 1, minimum is 1, maximum is 256

    Value parameter changes in version 5.1.16-ndb-6.2.0:

    • Default is 32, minimum is 1, maximum is 256

    Value parameter changes in version 5.1.23-ndb-6.2.10:

    • Default is 1, minimum is 1, maximum is 256

    Value parameter changes in version 5.1.19-ndb-6.3.0:

    • Default is 32, minimum is 1, maximum is 256

    Value parameter changes in version 5.1.23-ndb-6.3.7:

    • Default is 1, minimum is 1, maximum is 256

    Value parameter changes in version 5.1.41-ndb-6.3.31:

    • Default is 1, minimum is 1, maximum is 65536

    Value parameter changes in version 5.1.30-ndb-6.4.0:

    • Default is 32, minimum is 1, maximum is 256

    Value parameter changes in version 5.1.41-ndb-7.0.11:

    • Default is 1, minimum is 1, maximum is 65536

  • ndb-batch-size

    Introduced in version 5.1.23-ndb-6.3.8

  • ndb-blob-read-batch-bytes

    Introduced in version 5.1.51-ndb-7.0.21, 5.1.51-ndb-7.1.10

  • ndb-blob-write-batch-bytes

    Introduced in version 5.1.51-ndb-7.0.21, 5.1.51-ndb-7.1.10

  • ndb-cluster-connection-pool

    Introduced in version 5.1.19-ndb-6.2.2

  • Ndb_config_from_host

    Introduced in version 5.1.12

  • Ndb_config_from_port

    Introduced in version 5.1.12

  • Ndb_conflict_fn_epoch

    Introduced in version 5.1.56-ndb-7.1.16

  • Ndb_conflict_fn_epoch_trans

    Introduced in version 5.1.56-ndb-7.1.16

  • Ndb_conflict_fn_max

    Introduced in version 5.1.22-ndb-6.3.3

  • Ndb_conflict_fn_old

    Introduced in version 5.1.22-ndb-6.3.4

  • Ndb_conflict_trans_conflict_commit_count

    Introduced in version 5.1.56-ndb-7.1.16

  • Ndb_conflict_trans_detect_iter_count

    Introduced in version 5.1.56-ndb-7.1.16

  • Ndb_conflict_trans_reject_count

    Introduced in version 5.1.56-ndb-7.1.16

  • Ndb_conflict_trans_row_reject_count

    Introduced in version 5.1.56-ndb-7.1.16

  • ndb-deferred-constraints

    Introduced in version 5.1.56-ndb-7.0.28, 5.1.56-ndb-7.1.14

  • ndb_deferred_constraints

    Introduced in version 5.1.56-ndb-7.0.28, 5.1.56-ndb-7.1.14

  • ndb-distribution

    Introduced in version 5.1.32-ndb-7.0.4

  • ndb_distribution

    Introduced in version 5.1.32-ndb-7.0.4

  • ndb_eventbuffer_max_alloc

    Introduced in version 5.1.72-ndb-7.1.29

  • Ndb_execute_count

    Introduced in version 5.1.22-ndb-6.3.6

  • ndb_extra_logging

    Introduced in version 5.1.6

    Value parameter changes in version 5.1.19-ndb-6.3.0:

    • Default is 1, minimum is not specified, maximum is not specified

  • ndb_index_stat_cache_entries

    Removed in version 5.1.73-ndb-7.1.31

    Deprecated in version 5.1.19

  • ndb_index_stat_option

    Introduced in version 5.1.1.56-ndb-7.1.15

    Value parameter changes in version 5.1.56-ndb-7.1.17:

    • Default is loop_checkon=1000ms,loop_idle=1000ms,loop_busy=100ms, update_batch=1,read_batch=4,idle_batch=32,check_batch=32, check_delay=1m,delete_batch=8,clean_delay=0,error_batch=4, error_delay=1m,evict_batch=8,evict_delay=1m,cache_limit=32M, cache_lowpct=90

  • ndb_index_stat_update_freq

    Removed in version 5.1.73-ndb-7.1.31

    Deprecated in version 5.1.19

  • ndb_join_pushdown

    Introduced in version 5.1.51-ndb-7.2.0

  • ndb-log-apply-status

    Introduced in version 5.1.51-ndb-7.0.21, 5.1.51-ndb-7.1.10

  • ndb_log_apply_status

    Introduced in version 5.1.51-ndb-7.0.21, 5.1.51-ndb-7.1.10

  • ndb_log_bin

    Introduced in version 5.1.6

  • ndb_log_binlog_index

    Introduced in version 5.1.6

  • ndb-log-empty-epochs

    Introduced in version 5.1.31-ndb-6.3.21, 5.1.31-ndb-6.4.1

  • ndb_log_empty_epochs

    Introduced in version 5.1.31-ndb-6.3.21, 5.1.31-ndb-6.4.1

  • ndb-log-orig

    Introduced in version 5.1.22-ndb-6.3.2

  • ndb_log_orig

    Introduced in version 5.1.22-ndb-6.3.2

  • ndb-log-transaction-id

    Introduced in version 5.1.56-ndb-7.1.16

  • ndb_log_transaction_id

    Introduced in version 5.1.56-ndb-7.1.16

  • ndb-log-update-as-write

    Introduced in version 5.1.19-ndb-6.3.0, 5.1.22-ndb-6.2.5

  • ndb_log_updated_only

    Introduced in version 5.1.19-ndb-6.3.0

  • ndb-nodeid

    Introduced in version 5.1.15

  • Ndb_number_of_data_nodes

    Introduced in version 5.1.12

  • ndb_optimization_delay

    Introduced in version 5.1.23-ndb-6.3.7

  • ndb_optimized_node_selection

    Value parameter changes in version 5.1.22-ndb-6.3.4:

    • Default is 3, minimum is not specified, maximum is 3

  • Ndb_pruned_scan_count

    Introduced in version 5.1.34-ndb-6.3.25, 5.1.32-ndb-7.0.5

  • Ndb_pushed_queries_defined

    Introduced in version 5.1.51-ndb-7.2.0

  • Ndb_pushed_queries_dropped

    Introduced in version 5.1.51-ndb-7.2.0

  • Ndb_pushed_queries_executed

    Introduced in version 5.1.51-ndb-7.2.0

  • Ndb_pushed_reads

    Introduced in version 5.1.51-ndb-7.2.0

  • Ndb_scan_count

    Introduced in version 5.1.34-ndb-6.3.25, 5.1.32-ndb-7.0.5

  • ndb_table_no_logging

    Introduced in version 5.1.23-ndb-6.3.8

  • ndb_table_temporary

    Introduced in version 5.1.23-ndb-6.3.8

  • ndb-transid-mysql-connection-map

    Introduced in version 5.1.56-ndb-7.1.17

  • ndb_use_copying_alter_table

    Introduced in version 5.1.12

  • ndb_use_exact_count

    Value parameter changes in version 5.1.47-ndb-7.1.8:

    • Default is OFF

  • ndb_version

    Introduced in version 5.1.16-ndb-7.1.19

  • ndb_version_string

    Introduced in version 5.1.16-ndb-7.1.19

  • ndb-wait-connected

    Introduced in version 5.1.16-ndb-6.2.0

    Value parameter changes in version 5.1.56-ndb-7.1.16, 5.1.56-ndb-7.0.27:

    • Default is 30, minimum is not specified, maximum is 31536000

  • ndb-wait-setup

    Introduced in version 5.1.39-ndb-6.2.19, 5.1.39-ndb-6.3.28, 5.1.39-ndb-7.0.9

    Value parameter changes in version 5.1.56-ndb-7.0.27, 5.1.56-ndb-7.1.16:

    • Default is 30, minimum is not specified, maximum is 31536000

  • ndbinfo_database

    Introduced in version 5.1.41-ndb-7.1.1

  • ndbinfo_max_bytes

    Introduced in version 5.1.41-ndb-7.1.1

  • ndbinfo_max_rows

    Introduced in version 5.1.41-ndb-7.1.1

  • ndbinfo_offline

    Introduced in version 5.1.41-ndb-7.1.1

  • ndbinfo_show_hidden

    Introduced in version 5.1.41-ndb-7.1.1

  • ndbinfo_table_prefix

    Introduced in version 5.1.41-ndb-7.1.1

  • ndbinfo_version

    Introduced in version 5.1.41-ndb-7.1.1

  • old

    Introduced in version 5.1.18

  • Open_table_definitions

    Introduced in version 5.1.3

  • Opened_files

    Introduced in version 5.1.21

  • Opened_table_definitions

    Introduced in version 5.1.24

  • optimizer_switch

    Introduced in version 5.1.34

  • plugin_dir

    Introduced in version 5.1.2

  • plugin-load

    Introduced in version 5.1.18

  • port-open-timeout

    Introduced in version 5.1.5

  • Prepared_stmt_count

    Introduced in version 5.1.14

  • prepared_stmt_count

    Introduced in version 5.1.10

    Removed in version 5.1.13

  • profiling

    Introduced in version 5.1.24

  • profiling_history_size

    Introduced in version 5.1.24

  • Queries

    Introduced in version 5.1.31

  • secure-file-priv

    Introduced in version 5.1.17

  • server-id-bits

    Introduced in version 5.1.47-ndb-7.0.17, 5.1.47-ndb-7.1.6

  • server_id_bits

    Introduced in version 5.1.47-ndb-7.0.17, 5.1.47-ndb-7.1.6

  • skip-merge

    Introduced in version 5.1.12

    Removed in version 5.1.14

  • skip-thread-priority

    Deprecated in version 5.1.29

  • slave_allow_batching

    Introduced in version 5.1.19-ndb-6.2.3

  • slave_exec_mode

    Introduced in version 5.1.23-ndb-6.2.14, 5.1.23-ndb-6.3.11, 5.1.24

  • Slave_heartbeat_period

    Introduced in version 5.1.22-ndb-6.3.4

  • slave-max-allowed-packet

    Introduced in version 5.1.64

  • slave_max_allowed_packet

    Introduced in version 5.1.64

  • Slave_received_heartbeats

    Introduced in version 5.1.22-ndb-6.3.4

  • slave-skip-errors

    Value parameter changes in version 5.1.61-ndb-7.0.33,5.1.61-ndb-7.1.22:

    • Default is OFF

  • slave_type_conversions

    Introduced in version 5.1.44-ndb-6.3.33, 5.1.44-ndb-7.0.14, 5.1.44-ndb-7.1.3

  • slow-query-log

    Introduced in version 5.1.12

  • slow_query_log_file

    Introduced in version 5.1.12

  • sort_buffer_size

    Value parameter changes in version 5.1.23:

    • Default is 2097144, minimum is 32768, maximum is 4294967295

    Value parameter changes in version 5.1.23:

    • Default is 2097144, minimum is 32768, maximum is 4294967295

    Value parameter changes in version 5.1.23:

    • Default is 2097144, minimum is 32768, maximum is 18446744073709551615

  • ssl-ca

    Introduced in version 5.1.11

  • ssl-capath

    Introduced in version 5.1.11

  • ssl-cert

    Introduced in version 5.1.11

  • ssl-cipher

    Introduced in version 5.1.11

  • ssl-key

    Introduced in version 5.1.11

  • sysdate-is-now

    Introduced in version 5.1.8

  • table_cache

    Removed in version 5.1.3

    Deprecated in version 5.1.3 and replaced with table_open_cache

  • table_definition_cache

    Introduced in version 5.1.3

    Value parameter changes in version 5.1.25:

    • Default is 256, minimum is 256, maximum is 524288

  • table_open_cache

    Introduced in version 5.1.3

  • thread_handling

    Introduced in version 5.1.17

  • tmp_table_size

    Value parameter changes in version 5.1.12:

    • Default is 16777216, minimum is 1024, maximum is 4294967295

    Value parameter changes in version 5.1.37:

    • Default is 16777216, minimum is 1024, maximum is 9223372036854775807

    Value parameter changes in version 5.1.56:

    • Default is 16777216, minimum is 1024, maximum is 18446744073709551615

  • transaction_allow_batching

    Introduced in version 5.1.23-ndb-6.3.7

  • Uptime_since_flush_status

    Introduced in version 5.1.23-ndb-6.2.14, 5.1.24

  • validate_user_plugins

    Introduced in version 5.1.1