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

Deprecate and ignore innodb_log_checksums

Details

    Description

      The parameter innodb_log_checksums that was introduced in MariaDB 10.2.2 via MySQL 5.7.9 does not make much sense. The original motivation of introducing this parameter (initially called innodb_log_checksum_algorithm) was that the InnoDB redo log used the slow and insecure innodb algorithm. With hardware or SIMD assisted CRC-32C computation being available, there should be no reason to allow checksums to be disabled on the redo log.

      The parameter innodb_encrypt_log already implies innodb_log_checksums=ON.

      Let us deprecate the parameter innodb_log_checksums and always compute redo log checksums, even if innodb_log_checksums=OFF is specified.

      Attachments

        Issue Links

          Activity

            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            Fix Version/s 10.5.0 [ 23709 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]

            An upgrade from MariaDB 10.2.2 or later will only be possible after using the default value innodb_log_checksums=ON. If the non-default value innodb_log_checksums=OFF was in effect when the server was shut down, a log block checksum mismatch will be reported and the upgraded server will fail to start up.

            marko Marko Mäkelä added a comment - An upgrade from MariaDB 10.2.2 or later will only be possible after using the default value innodb_log_checksums=ON . If the non-default value innodb_log_checksums=OFF was in effect when the server was shut down, a log block checksum mismatch will be reported and the upgraded server will fail to start up.
            marko Marko Mäkelä made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 96865 ] MariaDB v4 [ 133963 ]

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.