← Back to team overview

maria-discuss team mailing list archive

configuration changes to consider in 10.2


As major versions are really the only time to consider changing default
settings perhaps getting onto the following MDEV soon.


My main objective is to move the required configuration file down to
approximately 0 settings and to work for the majority of people.

The sql_mode will cause pain because years of bad practice haven't been
fixed, however MySQL-5.7 has gone first and common frameworks are
beginning to fix their implementations. They are usually fairly simple
fixes to work with the sql_mode of "ONLY_FULL_GROUP_BY
Finding/making some documentation to describe how to fix this would be
good so the google answer doesn't become set sql_mode=''.

Lots of suggestions here model MySQL-5.7 defaults with a few of my
additions. Please let the list know which changes you agree with,
disagree with (any why).