What defaults would you like to see changed in MySQL 5.7?

In MySQL 5.6, one of the most well received changes was improving the default configuration to be safer, and easier to use.

We are seeking community feedback for improvements that can be made to the default configuration in MySQL 5.7. Please leave a comment, or get in touch with me via email.

For elimination of confusion, please state both the setting you would like changed, and the new desired value.


Published by


I joined MySQL AB in 2006, left, and am now back at Oracle working on the MySQL team. I've also worked at Percona and InPowered.

  • miguelangelnieto

    As we already discussed, slave_net_timeout should be 60. And I think that heartbeat should be enabled by default too.

    • http://www.tocker.ca/ Morgan Tocker

      Thank you!

      Just one question: Do you have a suggested value for MASTER_HEARTBEAT_PERIOD?

      • miguelangelnieto

        That's a difficult one. One second should be good enough. I think that's like 7kB of data per minute. But we should also take in account slow networks.

  • Justin Swanhart

    I personally think innodb_log_file_size should be increased further. It is still too small.

    • http://www.tocker.ca/ Morgan Tocker

      Any suggestions for a new value?

      I can see that if it gets too large, developers with small SSDs may complain.. but 48MB x2 should still be considered quite reasonable.

      • Justin Swanhart

        I personally think 128M is a good default, even for SSD, .25 GB is not so bad.

        • http://www.tocker.ca/ Morgan Tocker

          Sounds good :) With innodb-buffer-pool-size resizable online in 5.7, having a larger log file makes sense too.

  • http://databaseblog.myname.nl/ Daniël van Eeden

    Some ideas:

    For clients:

    Make it possible to use SSL w/o less configuration (if servercert is signed by public CA)
    Make the prompt more useful (show the database name)
    prompt="u@h [d] > "

    We all know STATEMENT is not really safe:

    binlog_format=ROW (or MIXED? at least not STATEMENT)

    This makes it easier to troubleshoot replication:

    The whole internet is UTF-8.. (alternative utf8mb4..)

    Do a dump/restore of the bufferpool:

    To use compression and the dynamic row format:

    Be strict by default:

    Some steps to allow crash safe replication by default:

    Don't eat the whole disk by default:


    For security: make it harder to create users by trying to grant privileges to nonexistend users.

    sql_mode += 'NO_AUTO_CREATE_USER'

    Also disable symlinks and local infile by default (a secure by default installation)

    I think many of the defaults have already changed to be more secure by default :)

  • http://databaseblog.myname.nl/ Daniël van Eeden

    A good test would be to create a 5.6 or 5.7 instance with default settings and then monitor it with MySQL Enterprise Monitor and see which advisor rules fire

  • fakename

    --skip-name-resolve by default

  • Daniel Black


    expire_logs_days=30 (something not 0 and not < 14)




  • Greg Lane

    I know it's not really a default change but why can't the mysqld_safe file be edited to contain the interleave fix that Jeremy Cole has suggested?

  • http://karwin.blogspot.com Bill Karwin

    Quick suggestion: query_cache_size = 0

    I don't understand why 5.6 changed to default query_cache_size=1M at the same time as query_cache_type=OFF.

  • Shlomi Noach