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

Per-partition INTERVAL for history partitions

    XMLWordPrintable

Details

    Description

      As per this comment of MDEV-17553 allow multiple intervals on per-partition basis.

      Allow ALTER command to set new rotation INTERVAL while keeping old partitions intact. This involves storing of start timestamp and interval for each partition for pruning to work correctly. The new INTERVAL should be applied to unused partitions as well as to auto-created ones.

      When partitions listed explicitly in CREATE TABLE, allow explicit setting of STARTS and INTERVAL per each partition. This information must be reflected in SHOW CREATE (and after ALTER changing the INTERVAL). INFORMATION_SCHEMA should display effective INTERVAL and STARTS per each partition.

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              midenok Aleksey Midenkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.