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

Make innodb_checksum_algorithm=full_crc32 by default, and remove innodb_checksums

    XMLWordPrintable

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

            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.