Skip navigation links
MySQL Server Version Reference :: 1 mysqld Options/Variables Reference :: 1.4 Option/Variable Changes for mysqld 5.6
2 Reserved Words »
Section Navigation      [Toggle]

1.4. Option/Variable Changes for mysqld 5.6

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

  • innodb_additional_mem_pool_size

    Deprecated from version 5.6.3

  • innodb_file_format

    Value parameters were changed from version (5.6.1)

    • Default is now Antelope

  • innodb_file_per_table

    Value parameters were changed from version (5.6.1)

    • Default is now OFF

  • innodb_locks_unsafe_for_binlog

    Deprecated from version 5.6.3

  • innodb_log_file_size

    Value parameters were changed from version (5.6.3)

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

  • innodb_purge_batch_size

    Value parameters were changed from version (5.6.3)

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

  • innodb_purge_threads

    Value parameters were changed from version (5.6.2)

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

    Value parameters were changed from version (5.6.5)

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

  • innodb_sort_buffer_size

    Value parameters were changed from version (5.6.4)

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

    Value parameters were changed from version (5.6.5)

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

  • innodb_stats_sample_pages

    Deprecated from version 5.6.3

  • innodb_use_sys_malloc

    Deprecated from version 5.6.3

  • language

    Deprecated from version 5.6.1

  • master-retry-count

    Deprecated from version 5.6.1

  • optimizer_switch

    Value parameters were changed from version (5.6.2)

    • Default is now not specified

    Value parameters were changed from version (5.6.3)

    • Default is now not specified

  • report-port

    Value parameters were changed from version (5.6.5)

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

  • secure-auth

    Value parameters were changed from version (5.6.4)

    • Default is now OFF

    Value parameters were changed from version (5.6.5)

    • Default is now ON

  • thread_concurrency

    Deprecated from version 5.6.1

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