随笔 - 746  文章 - 0  评论 - 39  阅读 - 79万

Mysql:Changes in MySQL 5.6.1 (Not released, Milestone 5):--log -> --general-log ...

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)

 

posted on   jinzhenshui  阅读(142)  评论(0编辑  收藏  举报
编辑推荐:
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
阅读排行:
· 无需6万激活码!GitHub神秘组织3小时极速复刻Manus,手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· Manus爆火,是硬核还是营销?
· 终于写完轮子一部分:tcp代理 了,记录一下
· 【杭电多校比赛记录】2025“钉耙编程”中国大学生算法设计春季联赛(1)
历史上的今天:
2014-03-29 Oracle:create pfile from spfile:rac下要小心该操作啊!
2013-03-29 Oracle:管理 date类型 interval 动态变化的分区:查询、删除
2013-03-29 JDBC 访问 Oracle ,如果结果集 中的字段 含有【null】值,无法获得结果集

点击右上角即可分享
微信分享提示