update defaults and simplify mysqld config parameters

Description

Poor MySQL has received some negative feedback over the years 1 2. As entertaining as it is watching and listening to developers struggle and whine, I think it's about time we changed some of the defaults and made the config easier to understand.

Oracle are working on changing more defaults in 5.7 3 4 5, I think we should too.

Something else they have done, is to radically change the simplicity of the default server config file, /etc/my.cnf:
https://raw.githubusercontent.com/mysql/mysql-server/5.7/support-files/my-default.cnf.sh

It's quite clear there, the sql_mode has been set, which will satisfy most developers and users looking for an ACID compliant database with little tweaking, and a rough note on increasing or decreasing RAM needed for InnoDB. MariaDB now probably needs something similar for Galera, CONNET and TokuDB.

  1. http://sql-info.de/mysql/gotchas.html

  2. http://blog.ionelmc.ro/2014/12/28/terrible-choices-mysql/

  3. http://www.tocker.ca/2015/01/23/proposal-to-change-additional-defaults-in-mysql-5-7.html

  4. http://www.tocker.ca/2015/01/14/proposal-to-change-replication-and-innodb-settings-in-mysql-5-7.html

  5. http://www.tocker.ca/2015/02/24/proposal-to-change-additional-defaults-in-mysql-5-7-february-edition.html

Environment

None

Status

Assignee

Unassigned

Reporter

Richard Bensley

Labels

None

External issue ID

None

External issue ID

None

Time tracking

80h

Fix versions

Priority

Major