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

1.1 Option/Variable Changes for mysqld 5.0

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

  • allow-suspicious-udfs

    Introduced in version 5.0.3

  • auto_increment_increment

    Introduced in version 5.0.2

  • auto_increment_offset

    Introduced in version 5.0.2

  • automatic_sp_privileges

    Introduced in version 5.0.3

  • character-set-filesystem

    Introduced in version 5.0.19

  • Com_call_procedure

    Introduced in version 5.0.44

  • Com_create_user

    Introduced in version 5.0.30

  • Com_stmt_close

    Introduced in version 5.0.8

  • Com_stmt_execute

    Introduced in version 5.0.8

  • Com_stmt_fetch

    Introduced in version 5.0.8

  • Com_stmt_prepare

    Introduced in version 5.0.8

  • Com_stmt_reset

    Introduced in version 5.0.8

  • Com_stmt_send_long_data

    Introduced in version 5.0.8

  • completion_type

    Introduced in version 5.0.3

  • Compression

    Introduced in version 5.0.16

  • concurrent_insert

    Value parameter changes in version 5.0.6:

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

  • connect_timeout

    Value parameter changes in version 5.0.52:

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

  • default-character-set

    Deprecated in version 5.0.0

  • default-table-type

    Deprecated in version 5.0.0 and replaced with default-storage-engine

  • defaults-group-suffix

    Introduced in version 5.0.10

  • div_precision_increment

    Introduced in version 5.0.6

  • engine-condition-pushdown

    Introduced in version 5.0.3

  • Handler_prepare

    Introduced in version 5.0.3

  • Handler_savepoint

    Introduced in version 5.0.3

  • Handler_savepoint_rollback

    Introduced in version 5.0.3

  • have_community_features

    Introduced in version 5.0.82

  • have_federated_engine

    Introduced in version 5.0.6

  • have_merge_engine

    Introduced in version 5.0.24

  • have_profiling

    Introduced in version 5.0.82

  • have_ssl

    Introduced in version 5.0.38

  • hostname

    Introduced in version 5.0.38

  • innodb_adaptive_hash_index

    Introduced in version 5.0.52

  • Innodb_buffer_pool_pages_data

    Introduced in version 5.0.2

  • Innodb_buffer_pool_pages_dirty

    Introduced in version 5.0.2

  • Innodb_buffer_pool_pages_flushed

    Introduced in version 5.0.2

  • Innodb_buffer_pool_pages_free

    Introduced in version 5.0.2

  • Innodb_buffer_pool_pages_latched

    Introduced in version 5.0.2

  • Innodb_buffer_pool_pages_misc

    Introduced in version 5.0.2

  • Innodb_buffer_pool_pages_total

    Introduced in version 5.0.2

  • Innodb_buffer_pool_read_ahead_rnd

    Introduced in version 5.0.2

  • Innodb_buffer_pool_read_ahead_seq

    Introduced in version 5.0.2

  • Innodb_buffer_pool_read_requests

    Introduced in version 5.0.2

  • Innodb_buffer_pool_reads

    Introduced in version 5.0.2

  • Innodb_buffer_pool_wait_free

    Introduced in version 5.0.2

  • Innodb_buffer_pool_write_requests

    Introduced in version 5.0.2

  • innodb_checksums

    Introduced in version 5.0.3

  • innodb_commit_concurrency

    Introduced in version 5.0.12

  • innodb_concurrency_tickets

    Introduced in version 5.0.3

  • Innodb_data_fsyncs

    Introduced in version 5.0.2

  • Innodb_data_pending_fsyncs

    Introduced in version 5.0.2

  • Innodb_data_pending_reads

    Introduced in version 5.0.2

  • Innodb_data_pending_writes

    Introduced in version 5.0.2

  • Innodb_data_read

    Introduced in version 5.0.2

  • Innodb_data_reads

    Introduced in version 5.0.2

  • Innodb_data_writes

    Introduced in version 5.0.2

  • Innodb_data_written

    Introduced in version 5.0.2

  • Innodb_dblwr_pages_written

    Introduced in version 5.0.2

  • Innodb_dblwr_writes

    Introduced in version 5.0.2

  • innodb_doublewrite

    Introduced in version 5.0.3

  • innodb_log_arch_dir

    Deprecated in version 5.0.24

  • Innodb_log_waits

    Introduced in version 5.0.2

  • Innodb_log_write_requests

    Introduced in version 5.0.2

  • Innodb_log_writes

    Introduced in version 5.0.2

  • Innodb_os_log_fsyncs

    Introduced in version 5.0.2

  • Innodb_os_log_pending_fsyncs

    Introduced in version 5.0.2

  • Innodb_os_log_pending_writes

    Introduced in version 5.0.2

  • Innodb_os_log_written

    Introduced in version 5.0.2

  • Innodb_page_size

    Introduced in version 5.0.2

  • Innodb_pages_created

    Introduced in version 5.0.2

  • Innodb_pages_read

    Introduced in version 5.0.2

  • Innodb_pages_written

    Introduced in version 5.0.2

  • innodb_rollback_on_timeout

    Introduced in version 5.0.32

  • Innodb_row_lock_current_waits

    Introduced in version 5.0.3

  • Innodb_row_lock_time

    Introduced in version 5.0.3

  • Innodb_row_lock_time_avg

    Introduced in version 5.0.3

  • Innodb_row_lock_time_max

    Introduced in version 5.0.3

  • Innodb_row_lock_waits

    Introduced in version 5.0.3

  • Innodb_rows_deleted

    Introduced in version 5.0.2

  • Innodb_rows_inserted

    Introduced in version 5.0.2

  • Innodb_rows_read

    Introduced in version 5.0.2

  • Innodb_rows_updated

    Introduced in version 5.0.2

  • innodb-safe-binlog

    Removed in version 5.0.3

    Deprecated in version 5.0.3

  • innodb_support_xa

    Introduced in version 5.0.3

  • innodb_sync_spin_loops

    Introduced in version 5.0.3

  • innodb_thread_concurrency

    Value parameter changes in version 5.0.8:

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

    Value parameter changes in version 5.0.19:

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

    Value parameter changes in version 5.0.21:

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

  • innodb_thread_sleep_delay

    Introduced in version 5.0.3

    Value parameter changes in version 5.0.8:

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

    Value parameter changes in version 5.0.19:

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

    Value parameter changes in version 5.0.21:

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

  • innodb_use_legacy_cardinality_algorithm

    Introduced in version 5.0.82

  • keep_files_on_create

    Introduced in version 5.0.48

  • large_page_size

    Introduced in version 5.0.3

  • large-pages

    Introduced in version 5.0.3

  • Last_query_cost

    Introduced in version 5.0.1

    Value parameter changes in version 5.0.7:

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

  • lc_time_names

    Introduced in version 5.0.25

  • log-bin-trust-function-creators

    Introduced in version 5.0.16

  • log-bin-trust-routine-creators

    Introduced in version 5.0.6

    Deprecated in version 5.0.16

  • log-tc

    Introduced in version 5.0.3

  • log-tc-size

    Introduced in version 5.0.3

  • log-update

    Deprecated in version 5.0.0 and replaced with log-bin

  • long_query_time

    Value parameter changes in version 5.0.21:

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

  • max_prepared_stmt_count

    Introduced in version 5.0.21

  • max_sp_recursion_depth

    Introduced in version 5.0.17

  • merge

    Introduced in version 5.0.24

  • multi_range_count

    Introduced in version 5.0.3

  • myisam_data_pointer_size

    Value parameter changes in version 5.0.6:

    • Default is 6, minimum is 2, maximum is 7

  • myisam_max_extra_sort_file_size

    Deprecated in version 5.0.6

  • myisam_mmap_size

    Introduced in version 5.0.90

  • myisam_stats_method

    Introduced in version 5.0.14

  • ndb_autoincrement_prefetch_sz

    Value parameter changes in version 5.0.56:

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

  • Ndb_config_from_host

    Introduced in version 5.0.23

  • Ndb_config_from_port

    Introduced in version 5.0.23

  • ndb-nodeid

    Introduced in version 5.0.45

  • old-style-user-limits

    Introduced in version 5.0.3

  • optimizer_prune_level

    Introduced in version 5.0.1

  • optimizer_search_depth

    Introduced in version 5.0.1

  • plugin_dir

    Introduced in version 5.0.67

  • port-open-timeout

    Introduced in version 5.0.19

  • Prepared_stmt_count

    Introduced in version 5.0.32

  • prepared_stmt_count

    Introduced in version 5.0.21

    Removed in version 5.0.31

  • profiling

    Introduced in version 5.0.37

  • profiling_history_size

    Introduced in version 5.0.37

  • Queries

    Introduced in version 5.0.76

  • replicate-same-server-id

    Introduced in version 5.0.1

  • secure-file-priv

    Introduced in version 5.0.38

  • set-variable

    Deprecated in version 5.0.0

  • skip-character-set-client-handshake

    Introduced in version 5.0.13

  • skip-merge

    Introduced in version 5.0.24

  • Slave_retried_transactions

    Introduced in version 5.0.4

  • slave_transaction_retries

    Introduced in version 5.0.3

  • sql_log_update

    Deprecated in version 5.0.0 and replaced with sql_log_bin

  • sql_notes

    Introduced in version 5.0.3

  • ssl-ca

    Introduced in version 5.0.23

  • ssl-capath

    Introduced in version 5.0.23

  • ssl-cert

    Introduced in version 5.0.23

  • ssl-cipher

    Introduced in version 5.0.23

  • ssl-key

    Introduced in version 5.0.23

  • sync_binlog

    Introduced in version 5.0.1

  • sysdate-is-now

    Introduced in version 5.0.20

  • table_lock_wait_timeout

    Introduced in version 5.0.10

  • tc-heuristic-recover

    Introduced in version 5.0.3

  • Tc_log_max_pages_used

    Introduced in version 5.0.3

  • Tc_log_page_size

    Introduced in version 5.0.3

  • Tc_log_page_waits

    Introduced in version 5.0.3

  • timed_mutexes

    Introduced in version 5.0.3

  • tmp_table_size

    Value parameter changes in version 5.0.86:

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

  • updatable_views_with_limit

    Introduced in version 5.0.2

  • Uptime_since_flush_status

    Introduced in version 5.0.35

  • use-symbolic-links

    Deprecated in version 5.0.0 and replaced with symbolic-links

  • warnings

    Deprecated in version 5.0.0 and replaced with log-warnings