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

Deprecate innodb_defragment and related parameters

Details

    Description

      There is a little used option innodb_defragment that would make OPTIMIZE TABLE not rebuild the table as usual for InnoDB, but instead cause the index B-trees to be optimized in place.

      This option uses excessive locking (exclusively locking index trees). It never covered SPATIAL INDEX or FULLTEXT INDEX. Storage space was never reclaimed.

      Because this option is not particularly useful and causes a maintenance burden (last, in MDEV-30400 when the B-tree cursors were refactored), I think that it is best to deprecate it, to give advance notice of its future removal.

      The following parameters will be deprecated:

      • innodb_defragment
      • innodb_defragment_n_pages
      • innodb_defragment_stats_accuracy
      • innodb_defragment_fill_factor_n_recs
      • innodb_defragment_fill_factor
      • innodb_defragment_frequency

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-30545 Remove innodb_defragment and related parameters

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

          Task - A task that needs to be done. MDEV-5834 Merge Kakao Defragmentation implementation to MariaDB 10.1

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-18385 Document use cases and locking behavior for OPTIMIZE TABLE with innodb_defragment=1

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28558 The MTR based test innodb_defrag_concurrent is not repeatable.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • 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ä made changes -
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2023-02-02 05:57:15.0 2023-02-02 05:57:15.403
            marko Marko Mäkelä made changes -
            Fix Version/s 11.0.1 [ 28548 ]
            Fix Version/s 11.0 [ 28320 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            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.