Category Archives: Community

Proposal to change additional defaults in MySQL 5.7 (February Edition)

Following on from my two earlier posts, in the MySQL team we are proposing a new set of changes to defaults for MySQL 5.7: Setting Old Default New Default log_slow_admin_statements OFF ON log_slow_slave_statements OFF ON long-query-time 10 2 log-queries-not-using-indexes OFF ON min-examined-row-limit 0 1000 MySQL Command Line Client - +show_warnings group_concat_max_len 1024 1M max_allowed_packet 4M […]

Proposal to change additional defaults in MySQL 5.7

Following on from my earlier proposal to change Replication + InnoDB settings, in the MySQL team, we are proposing to make the following additional changes to defaults in MySQL 5.7: Setting Old Default New Default binlog_error_action IGNORE_ERROR ABORT_SERVER innodb_checksum_algorithm INNODB CRC32 innodb_page_cleaners 1 4 innodb_purge_threads 1 4 innodb_strict_mode OFF ON innodb_log_file_size 48M 128M innodb_buffer_pool_dump_at_shutdown OFF […]

Proposal to change Replication and InnoDB Settings in MySQL 5.7

In the MySQL Team, we are currently evaluating potential changes to the default server configuration for MySQL 5.7. For more context, please see my earlier post here. One of the specific changes we would like to make is with the following three related replication and InnoDB settings: Setting Old Default New Default binlog_format STATEMENT ROW […]

MySQL 5.6.22 Community Release Notes

Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.22. In particular: Thank you to Ramesh Sivaraman for reporting that setting the innodb_limit_optimistic_insert_debug debug configuration option to 1 caused an infinite B-tree page split. Ramesh also provided a […]

Proposal to deprecate collation_database and character_set_database settings

In the MySQL team, we are currently discussing deprecating the ability to change the collation_database and character_set_database settings. As part of our plan, mysql clients will still be able to access these variables, but they will be read-only. Introduction The MySQL manual summarizes these two variables as saying: This option is dynamic, but only the […]

MySQL 5.6.21 Community Release Notes

Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.21. In particular: Thank you to Yoshinori Matsunobu who reported that during recovery GTID-based replication would need to scan all binary logs. We have since introduced an option for […]

Announcing Planet MySQL: Meta

A couple of months back, I wrote that we were looking to improve the quality of Planet MySQL. Today, I am very excited to share the results of this with the announcement of Planet MySQL: Meta. What is Meta? Meta is a new category of posts that appear on Planet MySQL, which is intended for […]

Proposed changes to user management in MySQL 5.7

In May we proposed deprecating and removing the old password format in MySQL 5.7. I am happy to report, that this proposal has gone ahead, and can already be seen in the 5.7 DMR5 release notes! With old passwords removed, and with recent versions of MySQL also offering new options for authenticating to MySQL, today […]