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

Default config file for deb packages turns ON binary logging

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5.27
    • 10.0.0, 5.5.28
    • None
    • debian/ubuntu

    Description

      debian/additions/my.cnf file turns on log-bin by default:

      log_bin                 = /var/log/mysql/mariadb-bin
      log_bin_index           = /var/log/mysql/mariadb-bin.index

      Unless it was done on purpose, it's not a great idea because
      a) it obviously affects performance for those who doesn't need the binlog;
      b) it causes unpleasant side-effects, due to statement logging being unsafe for various configurations and statements (warnings in the error log, errors on using InnoDB + READ-COMMITTED);
      c) it's different from MySQL setup.

      If it's possible to do it carefully now (without overriding custom cnf files on upgrade), it would be good to fix it in 5.5. In 10.0 it should be safe enough to fix, since it's only alpha.

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.