Changes in MySQL 5.6.1 (Not released, Milestone 5)

Functionality Added or Changed

  • Incompatible Change: The following obsolete constructs have been removed. Where alternatives are shown, applications should be updated to use them.

    • The --log server option and the log system variable. Instead, use the general_log system variable to enable the general query log and the general_log_file system variable to set the general query log file name.

    • The log_slow_queries system variable. Instead, use the slow_query_log system variable to enable the slow query log and the slow_query_log_file system variable to set the slow query log file name.

    • The --one-thread server option. Use --thread_handling=no-threads instead.

    • The --skip-thread-priority server option.

    • The engine_condition_pushdown system variable. Use the engine_condition_pushdown flag of the optimizer_switch variable instead.

    • The have_csv, have_innodb, have_ndbcluster, and have_partitioning system variables. Use SHOW ENGINES instead.

    • The sql_big_tables system variable. Use big_tables instead.

    • The sql_low_priority_updates system variable. Use low_priority_updates instead.

    • The sql_max_join_size system variable. Use max_join_size instead.

    • The SLAVE START and SLAVE STOP statements. Use the START SLAVE and STOP SLAVE statements instead.

    • The ONE_SHOT modifier for the SET statement.

  • Important Change; Replication: Replication filtering options such as --replicate-do-db, --replicate-rewrite-db, and --replicate-do-table were not consistent with one another in regard to case sensitivity. Now all --replicate-* options follow the same rules for case sensitivity applying to names of databases and tables elsewhere in the MySQL server, including the effects of the lower_case_table_names system variable. (Bug #51639, Bug #11759334)