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

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

    Value parameters were changed from version (5.1.4)

    • Default is now not specified

  • bdb-log-direct

    Value parameters were changed from version (5.1.4)

    • Default is now not specified

  • binlog-format

    Value parameters were changed from version (5.1.7)

    • Default is now STATEMENT

    Value parameters were changed from version (5.1.11)

    • Default is now STATEMENT

    Value parameters were changed from version (5.1.28)

    • Default is now MIXED

    Value parameters were changed from version (5.1.29)

    • Default is now STATEMENT

  • connect_timeout

    Value parameters were changed from version (5.1.22)

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

    Value parameters were changed from version (5.1.23)

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

  • enable-pstack

    Deprecated from version 5.1.54

  • have_partition_engine

    Deprecated and replaced with have_partitioning from version 5.1.6

    Value parameters were changed from version (5.1.6)

    • Default is now not specified

  • innodb

    Value parameters were changed from version (5.1.35)

    • Default is now not specified

    Value parameters were changed from version (5.1.36)

    • Default is now not specified

  • innodb_buffer_pool_size

    Value parameters were changed from version (5.1.27)

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

    Value parameters were changed from version (5.1.28)

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

    Value parameters were changed from version (5.1.28)

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

  • innodb_file_format

    Value parameters were changed from version (5.1.38)

    • Default is now Antelope

  • innodb_file_format_check

    Value parameters were changed from version (5.1.41)

    • Default is now Antelope

    Value parameters were changed from version (5.1.42)

    • Default is now Barracuda

  • innodb_flush_method

    Value parameters were changed from version (5.1.23)

    • Default is now fdatasync

    Value parameters were changed from version (5.1.23)

    • Default is now fdatasync

    Value parameters were changed from version (5.1.23)

    • Default is now fdatasync

  • key_buffer_size

    Value parameters were changed from version (5.1.22)

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

    Value parameters were changed from version (5.1.23)

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

    Value parameters were changed from version (5.1.23)

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

  • log

    Deprecated and replaced with general-log from version 5.1.29

  • log-slow-queries

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

  • long_query_time

    Value parameters were changed from version (5.1.21)

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

  • master-connect-retry

    Deprecated from version 5.1.17

  • master-host

    Deprecated from version 5.1.17

  • master-password

    Deprecated from version 5.1.17

  • master-port

    Deprecated from version 5.1.17

  • master-ssl

    Deprecated from version 5.1.17

  • master-ssl-ca

    Deprecated from version 5.1.17

  • master-ssl-capath

    Deprecated from version 5.1.17

  • master-ssl-cert

    Deprecated from version 5.1.17

  • master-ssl-cipher

    Deprecated from version 5.1.17

  • master-ssl-key

    Deprecated from version 5.1.17

  • master-user

    Deprecated from version 5.1.17

  • max_binlog_cache_size

    Value parameters were changed from version (5.1.35)

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

    Value parameters were changed from version (5.1.35)

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

    Value parameters were changed from version (5.1.36)

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

  • max_connections

    Value parameters were changed from version (5.1.14)

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

    Value parameters were changed from version (5.1.15)

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

    Value parameters were changed from version (5.1.17)

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

  • ndb-nodeid

    Value parameters were changed from version (5.1.5)

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

  • ndb-wait-connected

    Value parameters were changed from version (5.1.56-ndb-7.0.26)

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

    Value parameters were changed from version (5.1.56-ndb-7.1.15)

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

    Value parameters were changed from version (5.1.56-ndb-7.0.27)

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

    Value parameters were changed from version (5.1.56-ndb-7.1.16)

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

  • ndb-wait-setup

    Value parameters were changed from version (5.1.56-ndb-7.0.26)

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

    Value parameters were changed from version (5.1.56-ndb-7.1.15)

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

    Value parameters were changed from version (5.1.56-ndb-7.0.27)

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

    Value parameters were changed from version (5.1.56-ndb-7.1.16)

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

  • ndb_autoincrement_prefetch_sz

    Value parameters were changed from version (5.1.22)

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

    Value parameters were changed from version (5.1.24)

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

  • ndb_join_pushdown

    Value parameters were changed from version (5.1.51-ndb-7.2.0)

    • Default is now TRUE

  • ndb_optimized_node_selection

    Value parameters were changed from version (5.1.22-ndb-6.3.3)

    • Default is now ON

    Value parameters were changed from version (5.1.22-ndb-6.3.4)

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

  • plugin_dir

    Value parameters were changed from version (5.1.2)

    • Default is now BASEDIR/lib/mysql/plugin

    Value parameters were changed from version (5.1.2)

    • Default is now BASEDIR/lib/plugin

  • skip-thread-priority

    Deprecated from version 5.1.29

  • slave-skip-errors

    Value parameters were changed from version (5.1.61-ndb-7.0.33,5.1.61-ndb-7.1.22)

    • Default is now OFF

  • table_cache

    Deprecated and replaced with table_open_cache from version 5.1.3

  • table_definition_cache

    Value parameters were changed from version (5.1.24)

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

    Value parameters were changed from version (5.1.25)

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

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