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

make ROW_FORMAT=COMPRESSED read-only by default

Details

    Description

      introduce a new innodb command line option that will make compressed tables writable. by default they should be read-only. if the write support is enabled, it should print a warning on startup.

      This will allow users to prepare for MDEV-22367

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24503 Assertion `m_prebuilt->trx == thd_to_trx(m_user_thd)' failed in ha_innobase::is_read_only

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25100 Read-only table with ROW_FORMAT=COMPRESSED is still updateable through foreign key cascade

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27736 Allow seamless upgrade despite ROW_FORMAT=COMPRESSED

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25099 Inconsistent error upon updating read-only table with ROW_FORMAT=COMPRESSED

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12152 KEY_BLOCK_SIZE strangeness in ALTER TABLE

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-22367 Remove write support for ROW_FORMAT=COMPRESSED

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26400 ALTER TABLE does not remove KEY_BLOCK_SIZE for non-Compressed InnoDB tables

          • Major - Major loss of function.
          • Stalled
          links to

          Web Link MariaDB 10.6: InnoDB refuses to write tables with ROW_FORMAT=COMPRESSED

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.6.0 [ 24431 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 112484 ] MariaDB v4 [ 134322 ]
            marko Marko Mäkelä made changes -

            People

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