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

Auto-drop old history partition for system-versioned tables that use auto-creation

    XMLWordPrintable

    Details

      Description

      Enable history rotation with MAX keyword:

      create table t1 (x int) with system versioning
      partition by system_time interval 1 hour auto max 24;
       
      create table t1 (x int) with system versioning
      partition by system_time interval 1 month auto max 12;
      

      Or with explicit partitions:

      create table t1 (x int) with system versioning
      partition by system_time interval 1 hour auto max 24
      (partition p0 history, partition pn current);
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              midenok Aleksey Midenkov
              Reporter:
              midenok Aleksey Midenkov
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration