[MDEV-25495] Auto-drop old history partition for system-versioned tables that use auto-creation Created: 2021-04-23  Updated: 2023-11-30

Status: In Review
Project: MariaDB Server
Component/s: Partitioning, Versioned Tables
Fix Version/s: 11.5

Type: New Feature Priority: Critical
Reporter: Aleksey Midenkov Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 3
Labels: None

Issue Links:
Blocks
is blocked by MDEV-17554 Auto-create history partitions for sy... Closed
Relates
relates to MDEV-31212 Range partition: allow ADD PARTITION ... Open
relates to MDEV-31213 CONVERT TABLE TO PARTITION: allow cop... Open

 Description   

Enable history partitions rotation with AUTO argument to specify maximum number of partitions kept in the table:

create table t1 (x int) with system versioning
 
partition by system_time interval 1 hour auto 25;
 
 
 
create table t1 (x int) with system versioning
 
partition by system_time interval 1 month auto 13;

Or with explicit partitions:

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



 Comments   
Comment by Aleksey Midenkov [ 2023-05-23 ]

Please reveiw bb-11.2-midenok-MDEV-25495

Generated at Thu Feb 08 09:38:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.