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

1.1 Option/Variable Changes for mysqld 5.5

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

  • audit-log

    Introduced in version 5.5.28

  • audit_log_buffer_size

    Introduced in version 5.5.28

  • audit_log_file

    Introduced in version 5.5.28

  • audit_log_flush

    Introduced in version 5.5.28

  • audit_log_format

    Introduced in version 5.5.34

  • audit_log_policy

    Introduced in version 5.5.28

  • audit_log_rotate_on_size

    Introduced in version 5.5.28

  • audit_log_strategy

    Introduced in version 5.5.28

  • authentication_windows_log_level

    Introduced in version 5.5.16

  • authentication_windows_use_principal_name

    Introduced in version 5.5.16

  • binlog_cache_size

    Value parameter changes in version 5.5.3:

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

  • binlog_direct_non_transactional_updates

    Introduced in version 5.5.2

  • binlog-format

    Value parameter changes in version 5.5.15-ndb-7.2.1:

    • Default is STATEMENT

    Value parameter changes in version 5.5.31-ndb-7.2.13:

    • Default is MIXED

  • binlog-row-event-max-size

    Value parameter changes in version 5.5.3:

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

  • Binlog_stmt_cache_disk_use

    Introduced in version 5.5.9

  • binlog_stmt_cache_size

    Introduced in version 5.5.9

  • Binlog_stmt_cache_use

    Introduced in version 5.5.9

  • bulk_insert_buffer_size

    Value parameter changes in version 5.5.3:

    • Default is 8388608, minimum is not specified, maximum is 18446744073709551615

  • completion_type

    Value parameter changes in version 5.5.3:

    • Default is NO_CHAIN

  • concurrent_insert

    Value parameter changes in version 5.5.3:

    • Default is AUTO

  • default-character-set

    Removed in version 5.5.3

  • default-storage-engine

    Value parameter changes in version 5.5.5:

    • Default is InnoDB

  • delayed_insert_limit

    Value parameter changes in version 5.5.3:

    • Default is 100, minimum is 1, maximum is 18446744073709551615

  • delayed_queue_size

    Value parameter changes in version 5.5.3:

    • Default is 1000, minimum is 1, maximum is 18446744073709551615

  • enable-locking

    Removed in version 5.5.3

  • enable-pstack

    Removed in version 5.5.7

  • engine-condition-pushdown

    Deprecated in version 5.5.3 and replaced with optimizer_switch

  • external_user

    Introduced in version 5.5.7

  • group_concat_max_len

    Value parameter changes in version 5.5.3:

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

  • Handler_read_last

    Introduced in version 5.5.7

  • ignore-builtin-innodb

    Deprecated in version 5.5.22

  • init-rpl-role

    Deprecated in version 5.5.3

  • Innodb_buffer_pool_bytes_data

    Introduced in version 5.5.30

  • Innodb_buffer_pool_bytes_dirty

    Introduced in version 5.5.30

  • innodb_buffer_pool_instances

    Introduced in version 5.5.4

  • innodb_change_buffering

    Value parameter changes in version 5.5.4:

    • Default is all

  • innodb_file_format

    Value parameter changes in version 5.5.7:

    • Default is Antelope

  • innodb_file_format_check

    Value parameter changes in version 5.5.1:

    • Default is Barracuda

    Value parameter changes in version 5.5.5:

    • Default is ON

  • innodb_file_format_max

    Introduced in version 5.5.5

  • innodb_file_io_threads

    Removed in version 5.5.0

  • innodb_file_per_table

    Value parameter changes in version 5.5.7:

    • Default is OFF

  • innodb_force_load_corrupted

    Introduced in version 5.5.18

  • innodb_large_prefix

    Introduced in version 5.5.14

  • innodb_print_all_deadlocks

    Introduced in version 5.5.30

  • innodb_purge_batch_size

    Introduced in version 5.5.4

  • innodb_purge_threads

    Introduced in version 5.5.4

  • innodb_random_read_ahead

    Introduced in version 5.5.16

  • innodb_rollback_segments

    Introduced in version 5.5.11

  • innodb_stats_method

    Introduced in version 5.5.10

  • innodb_stats_on_metadata

    Introduced in version 5.5.4

  • innodb_thread_sleep_delay

    Value parameter changes in version 5.5.37:

    • Default is 10000, minimum is not specified, maximum is 1000000

  • Innodb_truncated_status_writes

    Introduced in version 5.5.7

  • innodb_use_native_aio

    Introduced in version 5.5.4

  • join_buffer_size

    Value parameter changes in version 5.5.3:

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

    Value parameter changes in version 5.5.3:

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

    Value parameter changes in version 5.5.3:

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

  • key_cache_age_threshold

    Value parameter changes in version 5.5.3:

    • Default is 300, minimum is 100, maximum is 18446744073709551615

  • language

    Deprecated in version 5.5.0 and replaced with lc-messages-dir

  • lock_wait_timeout

    Introduced in version 5.5.3

  • log-bin-trust-routine-creators

    Removed in version 5.5.3

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

    Introduced in version 5.5.15-ndb-7.2.1

  • log_bin_use_v1_row_events

    Introduced in version 5.5.15-ndb-7.2.1

  • log-tc-size

    Value parameter changes in version 5.5.3:

    • Default is 24576, minimum is not specified, maximum is 18446744073709551615

  • log-warnings

    Value parameter changes in version 5.5.3:

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

  • master-connect-retry

    Removed in version 5.5.3

  • master-host

    Removed in version 5.5.3

  • master-password

    Removed in version 5.5.3

  • master-port

    Removed in version 5.5.3

  • master-ssl

    Removed in version 5.5.3

  • master-ssl-ca

    Removed in version 5.5.3

  • master-ssl-capath

    Removed in version 5.5.3

  • master-ssl-cert

    Removed in version 5.5.3

  • master-ssl-cipher

    Removed in version 5.5.3

  • master-ssl-key

    Removed in version 5.5.3

  • master-user

    Removed in version 5.5.3

  • max_binlog_cache_size

    Value parameter changes in version 5.5.3:

    • Default is 18446744073709551615, minimum is 4096, maximum is 18446744073709551615

  • max_binlog_stmt_cache_size

    Introduced in version 5.5.9

  • max_connect_errors

    Value parameter changes in version 5.5.3:

    • Default is 10, minimum is 1, maximum is 18446744073709551615

  • max_long_data_size

    Introduced in version 5.5.11

    Deprecated in version 5.5.11

  • max_seeks_for_key

    Value parameter changes in version 5.5.3:

    • Default is 18446744073709551615, minimum is 1, maximum is 18446744073709551615

  • max_write_lock_count

    Value parameter changes in version 5.5.3:

    • Default is 18446744073709551615, minimum is 1, maximum is 18446744073709551615

  • metadata_locks_cache_size

    Introduced in version 5.5.19

  • min-examined-row-limit

    Value parameter changes in version 5.5.3:

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

  • myisam_mmap_size

    Introduced in version 5.5.1

    Value parameter changes in version 5.5.3:

    • Default is 18446744073709551615, minimum is 7, maximum is 18446744073709551615

  • myisam-recover

    Removed in version 5.5.3

  • myisam-recover-options

    Introduced in version 5.5.3

  • myisam_repair_threads

    Value parameter changes in version 5.5.3:

    • Default is 1, minimum is 1, maximum is 18446744073709551615

  • myisam_sort_buffer_size

    Value parameter changes in version 5.5.22:

    • Default is 8388608, minimum is 4096, maximum is 18446744073709551615

    Value parameter changes in version 5.5.3:

    • Default is 8388608, minimum is 4096, maximum is 18446744073709551615

  • ndb_autoincrement_prefetch_sz

    Value parameter changes in version 5.5.15-ndb-7.2.1:

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

  • Ndb_conflict_fn_epoch

    Introduced in version 5.5.15-ndb-7.2.1

  • Ndb_conflict_fn_epoch_trans

    Introduced in version 5.5.15-ndb-7.2.1

  • Ndb_conflict_trans_conflict_commit_count

    Introduced in version 5.5.15-ndb-7.2.1

  • Ndb_conflict_trans_detect_iter_count

    Introduced in version 5.5.15-ndb-7.2.1

  • Ndb_conflict_trans_reject_count

    Introduced in version 5.5.15-ndb-7.2.1

  • Ndb_conflict_trans_row_reject_count

    Introduced in version 5.5.15-ndb-7.2.1

  • ndb_eventbuffer_max_alloc

    Introduced in version 5.5.34-ndb-7.2.14

  • ndb_index_stat_cache_entries

    Removed in version 5.5.36-ndb-7.2.16

  • ndb_index_stat_enable

    Value parameter changes in version 5.5.15-ndb-7.2.1:

    • Default is ON

  • ndb_index_stat_option

    Introduced in version 5.5.15-ndb-7.2.1

  • ndb_index_stat_update_freq

    Removed in version 5.5.36-ndb-7.2.16

  • ndb-log-transaction-id

    Introduced in version 5.5.15-ndb-7.2.1

  • ndb_log_transaction_id

    Introduced in version 5.5.15-ndb-7.2.1

  • ndb-transid-mysql-connection-map

    Introduced in version 5.5.16-ndb-7.2.2

  • net_retry_count

    Value parameter changes in version 5.5.3:

    • Default is 10, minimum is 1, maximum is 18446744073709551615

  • optimizer_switch

    Value parameter changes in version 5.5.3:

    • Default is not specified

  • performance_schema

    Introduced in version 5.5.3

  • Performance_schema_cond_classes_lost

    Introduced in version 5.5.3

  • Performance_schema_cond_instances_lost

    Introduced in version 5.5.3

  • performance_schema_events_waits_history_long_size

    Introduced in version 5.5.3

  • performance_schema_events_waits_history_size

    Introduced in version 5.5.3

  • Performance_schema_file_classes_lost

    Introduced in version 5.5.3

  • Performance_schema_file_handles_lost

    Introduced in version 5.5.3

  • Performance_schema_file_instances_lost

    Introduced in version 5.5.3

  • Performance_schema_locker_lost

    Introduced in version 5.5.3

  • performance_schema_max_cond_classes

    Introduced in version 5.5.3

  • performance_schema_max_cond_instances

    Introduced in version 5.5.3

  • performance_schema_max_file_classes

    Introduced in version 5.5.3

  • performance_schema_max_file_handles

    Introduced in version 5.5.3

  • performance_schema_max_file_instances

    Introduced in version 5.5.3

  • performance_schema_max_mutex_classes

    Introduced in version 5.5.3

  • performance_schema_max_mutex_instances

    Introduced in version 5.5.3

  • performance_schema_max_rwlock_classes

    Introduced in version 5.5.3

    Value parameter changes in version 5.5.7:

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

  • performance_schema_max_rwlock_instances

    Introduced in version 5.5.3

  • performance_schema_max_table_handles

    Introduced in version 5.5.3

  • performance_schema_max_table_instances

    Introduced in version 5.5.3

  • performance_schema_max_thread_classes

    Introduced in version 5.5.3

  • performance_schema_max_thread_instances

    Introduced in version 5.5.3

  • Performance_schema_mutex_classes_lost

    Introduced in version 5.5.3

  • Performance_schema_mutex_instances_lost

    Introduced in version 5.5.3

  • Performance_schema_rwlock_classes_lost

    Introduced in version 5.5.3

  • Performance_schema_rwlock_instances_lost

    Introduced in version 5.5.3

  • Performance_schema_table_handles_lost

    Introduced in version 5.5.3

  • Performance_schema_table_instances_lost

    Introduced in version 5.5.3

  • Performance_schema_thread_classes_lost

    Introduced in version 5.5.3

  • Performance_schema_thread_instances_lost

    Introduced in version 5.5.3

  • plugin_dir

    Value parameter changes in version 5.5.5:

    • Default is BASEDIR/lib/plugin

  • proxy_user

    Introduced in version 5.5.7

  • pseudo_slave_mode

    Introduced in version 5.5.30

  • query_alloc_block_size

    Value parameter changes in version 5.5.3:

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

  • query_cache_limit

    Value parameter changes in version 5.5.3:

    • Default is 1048576, minimum is not specified, maximum is 18446744073709551615

  • query_cache_min_res_unit

    Value parameter changes in version 5.5.3:

    • Default is 4096, minimum is 512, maximum is 18446744073709551615

  • query_cache_size

    Value parameter changes in version 5.5.3:

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

  • query_prealloc_size

    Value parameter changes in version 5.5.3:

    • Default is 8192, minimum is 8192, maximum is 18446744073709551615

  • range_alloc_block_size

    Value parameter changes in version 5.5.3:

    • Default is 4096, minimum is 4096, maximum is 18446744073709551615

  • read_rnd_buffer_size

    Value parameter changes in version 5.5.3:

    • Default is 262144, minimum is 1, maximum is 2147483647

  • relay_log_space_limit

    Value parameter changes in version 5.5.3:

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

  • report-port

    Value parameter changes in version 5.5.23:

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

  • rpl_recovery_rank

    Deprecated in version 5.5.3

  • Rpl_status

    Deprecated in version 5.5.3

  • safe-mode

    Deprecated in version 5.5.26

  • safe-show-database

    Removed in version 5.5.3

  • safemalloc-mem-limit

    Removed in version 5.5.6

  • set-variable

    Removed in version 5.5.3

  • skip-locking

    Removed in version 5.5.3

  • skip-safemalloc

    Removed in version 5.5.6

  • skip-symlink

    Removed in version 5.5.3

  • slave-max-allowed-packet

    Introduced in version 5.5.26

  • slave_max_allowed_packet

    Introduced in version 5.5.26

  • slave-skip-errors

    Value parameter changes in version 5.5.15-ndb-7.2.1:

    • Default is OFF

    Value parameter changes in version 5.5.22-ndb-7.2.6:

    • Default is OFF

  • slave_transaction_retries

    Value parameter changes in version 5.5.3:

    • Default is 10, minimum is not specified, maximum is 18446744073709551615

  • slave_type_conversions

    Introduced in version 5.5.3

  • slow-start-timeout

    Introduced in version 5.5.20

  • sql_auto_is_null

    Value parameter changes in version 5.5.3:

    • Default is not specified

  • sql_log_update

    Removed in version 5.5.3

  • storage_engine

    Value parameter changes in version 5.5.5:

    • Default is InnoDB

  • stored_program_cache

    Introduced in version 5.5.21

  • super-large-pages

    Introduced in version 5.5.3

  • sync_binlog

    Value parameter changes in version 5.5.3:

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

  • sync_master_info

    Value parameter changes in version 5.5.3:

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

  • sync_relay_log

    Value parameter changes in version 5.5.3:

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

  • sync_relay_log_info

    Value parameter changes in version 5.5.3:

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

  • table_lock_wait_timeout

    Removed in version 5.5.3

  • table_type

    Removed in version 5.5.3

  • thread_handling

    Value parameter changes in version 5.5.16:

    • Default is one-thread-per-connection

  • thread_pool_algorithm

    Introduced in version 5.5.16

  • thread_pool_high_priority_connection

    Introduced in version 5.5.16

  • thread_pool_max_unused_threads

    Introduced in version 5.5.16

  • thread_pool_prio_kickup_timer

    Introduced in version 5.5.16

  • thread_pool_size

    Introduced in version 5.5.16

  • thread_pool_stall_limit

    Introduced in version 5.5.16

  • thread_stack

    Value parameter changes in version 5.5.3:

    • Default is 262144, minimum is 131072, maximum is 18446744073709551615

  • timed_mutexes

    Deprecated in version 5.5.39

  • transaction_alloc_block_size

    Value parameter changes in version 5.5.43:

    • Default is 8192, minimum is 1024, maximum is 131072

    Value parameter changes in version 5.5.3:

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

  • transaction_prealloc_size

    Value parameter changes in version 5.5.43:

    • Default is 4096, minimum is 1024, maximum is 131072

    Value parameter changes in version 5.5.3:

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

  • warnings

    Value parameter changes in version 5.5.3:

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