Skip navigation links
MySQL Server Version Reference :: 1 mysqld Option/Variable Reference :: 1.3 Option/Variable Changes for mysqld 5.5
1.4 Option/Variable Changes for mysqld 5.6 »
Section Navigation      [Toggle]

1.3. 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_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_direct_non_transactional_updates

    Introduced in version 5.5.2

  • 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

  • completion_type

    Value parameter changes in version 5.5.2:

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

    Value parameter changes in version 5.5.3:

    • Default is NO_CHAIN

  • concurrent_insert

    Value parameter changes in version 5.5.2:

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

    Value parameter changes in version 5.5.3:

    • Default is AUTO

  • default-storage-engine

    Value parameter changes in version 5.5.4:

    • Default is MyISAM

    Value parameter changes in version 5.5.5:

    • Default is InnoDB

  • enable-locking

    Removed in version 5.5.3

  • enable-pstack

    Removed in version 5.5.7

  • engine-condition-pushdown

    Deprecatedand replaced with optimizer_switch in version 5.5.3

  • external_user

    Introduced in version 5.5.7

  • Handler_read_last

    Introduced in version 5.5.7

  • 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.3:

    • Default is inserts

    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.4:

    • 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_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

    Value parameter changes in version 5.5.4:

    • Default is 20, minimum is 1, maximum is 5000

  • innodb_purge_threads

    Introduced in version 5.5.4

    Value parameter changes in version 5.5.4:

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

  • 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_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.2:

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

    Value parameter changes in version 5.5.2:

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

    Value parameter changes in version 5.5.3:

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

    Value parameter changes in version 5.5.3:

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

  • language

    Deprecatedand replaced with lc-messages-dir in version 5.5.0

  • 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

  • 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_stmt_cache_size

    Introduced in version 5.5.9

  • max_long_data_size

    Introduced in version 5.5.11

    Deprecated in version 5.5.11

  • metadata_locks_cache_size

    Introduced in version 5.5.19

  • myisam_mmap_size

    Introduced in version 5.5.1

  • myisam-recover

    Removed in version 5.5.3

  • myisam-recover-options

    Introduced in version 5.5.3

  • 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_conflict_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-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

  • optimizer_switch

    Value parameter changes in version 5.5.2:

    • Default is not specified

    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

  • 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

  • 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

  • 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_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.2:

    • Default is 1

    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.3:

    • Default is MyISAM

    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

  • 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.13:

    • Default is not specified

    Value parameter changes in version 5.5.16:

    • Default is not specified

  • 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

Copyright © 1997, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices