Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7635

update defaults and simplify mysqld config parameters

    XMLWordPrintable

Details

    • 5.5.51 & 10.2.2, 10.2.2-1, 10.2.3-1, 10.2.3-2, 10.2.4-4, 10.2.4-1, 10.2.4-5, 10.0.29

    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

      Proposed new defaults:

      innodb_autoinc_lock_mode            = 2         (was: 1)
      innodb_buffer_pool_dump_at_shutdown = ON        (was: OFF)
      innodb_buffer_pool_dump_pct         = 25        (was: 100)
      innodb_buffer_pool_load_at_startup  = ON        (was: OFF)
      innodb_checksum_algorithm           = CRC32     (was: INNODB)
      innodb_file_format                  = Barracuda (was: Antelope)
      innodb_file_format_max              = Barracuda (was: Antelope)
      innodb_large_prefix                 = ON        (was: OFF)
      innodb_log_compressed_pages         = ON        (was: OFF)
      innodb_purge_threads                = 4         (was: 1)
      innodb_strict_mode                  = ON        (was: OFF)
       
      binlog_annotate_row_events          = ON        (was: OFF)
      binlog_format                       = MIXED     (was: STATEMENT)
      group_concat_max_len                = 1M        (was: 1025)
      lock_wait_timeout                   = 86400(1day)(was: 1year)
      log_slow_admin_statements           = ON        (was: OFF)
      log_slow_slave_statements           = ON        (was: OFF)
      log_warnings                        = 2         (was: 1)
      max_allowed_packet                  = 16M       (was: 4M)
      replicate_annotate_row_events       = ON        (was: OFF)
      slave_net_timeout                   = 60        (was: 3600)
      sync_binlog                         = 1         (was: 0)
      aria_recover                        = FORCE, BACKUP (was: NORMAL)
      myisam_recover_options              = FORCE, BACKUP (was: OFF)
      

      Attachments

        Issue Links

          Activity

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              mathnode Richard Bensley
              Votes:
              3 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.