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

Deprecate innodb_defragment and related parameters

    XMLWordPrintable

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

            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.