Skip navigation links
MySQL Server Version Reference :: 1 mysqld Options/Variables Reference :: 1.1 Option/Variable Changes for mysqld 5.0
1.2 Option/Variable Changes for mysqld 5.1 »
Section Navigation      [Toggle]

1.1. Option/Variable Changes for mysqld 5.0

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

  • Compression

    Value parameters were changed from version (5.0.16)

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

  • Handler_prepare

    Value parameters were changed from version (5.0.3)

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

  • Last_query_cost

    Value parameters were changed from version (5.0.7)

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

    Value parameters were changed from version (5.0.7)

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

  • concurrent_insert

    Value parameters were changed from version (5.0.5)

    • Default is now TRUE

    Value parameters were changed from version (5.0.6)

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

  • connect_timeout

    Value parameters were changed from version (5.0.51)

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

    Value parameters were changed from version (5.0.52)

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

  • default-character-set

    Deprecated from version 5.0

  • default-table-type

    Deprecated and replaced with default-storage-engine from version 5.0

  • engine-condition-pushdown

    Value parameters were changed from version (5.0.3)

    • Default is now OFF

  • innodb_log_arch_dir

    Deprecated from version 5.0.24

  • innodb_safe_binlog

    Deprecated from version 5.0.3

  • innodb_thread_concurrency

    Value parameters were changed from version (5.0.9)

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

    Value parameters were changed from version (5.0.19)

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

  • innodb_thread_sleep_delay

    Value parameters were changed from version (5.0.18)

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

    Value parameters were changed from version (5.0.20)

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

    Value parameters were changed from version (5.0.21)

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

  • log-bin-trust-routine-creators

    Deprecated and replaced with log-bin-trust-function-creators from version 5.0.16

  • log-update

    Deprecated and replaced with log-bin from version 5.0

  • long_query_time

    Value parameters were changed from version (5.0.20)

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

  • myisam_data_pointer_size

    Value parameters were changed from version (5.0.5)

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

    Value parameters were changed from version (5.0.6)

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

  • myisam_max_extra_sort_file_size

    Deprecated from version 5.0.6

    Value parameters were changed from version (5.0.6)

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

  • ndb-nodeid

    Value parameters were changed from version (5.0.45)

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

  • ndb_autoincrement_prefetch_sz

    Value parameters were changed from version (5.0.54)

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

    Value parameters were changed from version (5.0.56)

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

  • range_alloc_block_size

    Value parameters were changed from version (5.0.54)

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

    Value parameters were changed from version (5.0.54)

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

  • safe-mode

    Deprecated from version 5.0

  • set-variable

    Deprecated from version 5.0

  • sql_log_update

    Deprecated and replaced with sql_log_bin from version 5.0

  • use-symbolic-links

    Deprecated and replaced with symbolic-links from version 5.0

  • warnings

    Deprecated and replaced with log-warnings from version 5.0