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

page_compressed compressed page partially during import tablespace

Details

    • 10.3.6-1

    Description

      The CREATE TABLE attribute page_compressed that was introduced in MariaDB 10.1.3 has no effect when innodb_doublewrite=0. This is because the actual compression only takes place within the doublewrite buffer code path.

      The purpose of the doublewrite buffer is to guarantee crash-safety in the event that InnoDB is killed in the middle of a page write. Because it could become a performance bottleneck for write-heavy workloads, some users may choose to set innodb_doublewrite=0 and take the risk that crash recovery may fail. (The page should be referred to by the redo log, and a log checkpoint should not be made while a page write is still in progress, so the page corruption should be detected at InnoDB startup.)

      Attachments

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open Confirmed
            1h 49m 1
            Thirunarayanan Balathandayuthapani made transition -
            Confirmed In Progress
            941d 20h 18m 1
            Thirunarayanan Balathandayuthapani made transition -
            In Progress Stalled
            146d 3h 39m 1
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            3d 18h 15m 1
            Marko Mäkelä made transition -
            In Review Stalled
            3h 54m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Progress
            23d 17h 32m 2
            Thirunarayanan Balathandayuthapani made transition -
            In Progress Closed
            1d 6h 39m 1

            People

              thiru Thirunarayanan Balathandayuthapani
              marko Marko Mäkelä
              Votes:
              2 Vote for this issue
              Watchers:
              6 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.