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

Make innodb_checksum_algorithm=full_crc32 by default, and remove innodb_checksums

Details

    Description

      In MDEV-12026 and MDEV-18644, MariaDB 10.4 introduced support for a new file format innodb_checksum_algorithm=full_crc32. Let us enable it by default in MariaDB 10.5.

      At the same time, let us remove the deprecated parameter innodb_checksums.

      For now, we will not touch the parameter innodb_log_checksums. InnoDB redo logs use CRC-32C checksums by default already since MariaDB Server version 10.2.2.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27931 A page in innodb_checksum_algorithm=innodb is wrongly claimed to be corrupted

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19541 InnoDB crashes when trying to recover a corrupted page

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-25105 Remove innodb_checksum_algorithm values none, innodb, strict_none, strict_innodb

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32230 ROW_FORMAT column in I_S.INNODB_SYS_TABLESPACES is NULL for innodb_checksum_algorithm=full_crc32 tablespaces

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33808 InnoDB: Unable to read page [page id: space=0, page number=5] into the buffer pool after 100

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-12026 Support encrypted SPATIAL INDEX

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Task - A task that needs to be done. MDEV-18644 Support FULL_CRC32 for compressed pages.

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-18650 Options deprecated in previous versions

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20320 Tablespace flags mismatch for full_crc32 format

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21568 sys_vars.innodb_checksum_algorithm_basic failed in buildbot with errno: 2000

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä added a comment -

            MDEV-19541 (a crash during the recovery of a corrupted page) was found as part of this effort.

            marko Marko Mäkelä added a comment - MDEV-19541 (a crash during the recovery of a corrupted page) was found as part of this effort.
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Description In MDEV-12026 and MDEV-18644, MariaDB 10.4 introduced support for a new file format {{innodb_checksum_algorithm=full_crc32}}. Let us enable it by default in MariaDB 10.5.

            At the same time, let us remove the deprecated parameter {{innodb_use_checksums}}.

            For now, we will not touch the parameter {{innodb_log_checksums}}. InnoDB redo logs use CRC-32C checksums by default already since MariaDB Server version 10.2.2.             		In MDEV-12026 and MDEV-18644, MariaDB 10.4 introduced support for a new file format {{innodb_checksum_algorithm=full_crc32}}. Let us enable it by default in MariaDB 10.5.

            At the same time, let us remove the deprecated parameter {{innodb_checksums}}.

            For now, we will not touch the parameter {{innodb_log_checksums}}. InnoDB redo logs use CRC-32C checksums by default already since MariaDB Server version 10.2.2.
            Summary Make innodb_checksum_algorithm=full_crc32 by default, and remove innodb_use_checksums Make innodb_checksum_algorithm=full_crc32 by default, and remove innodb_checksums
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5.0 [ 23709 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 96847 ] MariaDB v4 [ 133960 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              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.