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

1.3. Option/Variable Changes for mysqld 5.4

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

  • innodb

    Value parameters were changed from version (5.4.1)

    • Default is now not specified

    Value parameters were changed from version (5.4.2)

    • Default is now not specified

  • innodb_autoextend_increment

    Value parameters were changed from version (5.4.2)

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

  • innodb_buffer_pool_size

    Value parameters were changed from version (5.4.1)

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

    Value parameters were changed from version (5.4.2)

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

    Value parameters were changed from version (5.4.3)

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

  • innodb_log_buffer_size

    Value parameters were changed from version (5.4.1)

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

    Value parameters were changed from version (5.4.2)

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

    Value parameters were changed from version (5.4.3)

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

  • innodb_log_file_size

    Value parameters were changed from version (5.4.1)

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

    Value parameters were changed from version (5.4.2)

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

    Value parameters were changed from version (5.4.3)

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

  • innodb_log_files_in_group

    Value parameters were changed from version (5.4.2)

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

    Value parameters were changed from version (5.4.3)

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

  • innodb_read_io_threads

    Value parameters were changed from version (5.4.2)

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

    Value parameters were changed from version (5.4.3)

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

  • innodb_sync_spin_loops

    Value parameters were changed from version (5.4.1)

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

    Value parameters were changed from version (5.4.2)

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

  • innodb_write_io_threads

    Value parameters were changed from version (5.4.2)

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

    Value parameters were changed from version (5.4.3)

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

  • max_binlog_cache_size

    Value parameters were changed from version (5.4.1)

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

    Value parameters were changed from version (5.4.2)

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

  • optimizer_switch

    Value parameters were changed from version (5.4.2)

    • Default is now not specified

  • table_open_cache

    Value parameters were changed from version (5.4.1)

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

    Value parameters were changed from version (5.4.2)

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