©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
SYSTEM_TIME partitioning for MariaDB tables

SYSTEM_TIME partitioning for system-versioned MariaDB tables

MariaDB - SYSTEM_TIME partitioning SYSTEM_TIME partitioning is part of editing system-versioned tables (only MariaDB)
MariaDB - Creating SYSTEM_TIME partitions
Creating a SYSTEM_TIME partition of MariaDB tables:

SYSTEM_TIME partitioning is only available for system-versioned tables from MariaDB version 10.3 onwards.

Partitioning by: Choice of partitioning method.
Limit: Specifies how many rows of data should be stored in a History partition before switching partitions.
Omit order 0 = No limit.
Number of partitions: Specifies how many partitions should be created. This will create only one partition for the current data.
Start: Start the partition editor with the set parameters.

Subpartitions can be created:

Subpartitions by: Select partitioning method (HASH, LINEAR HASH, KEY, LINEAR KEY).
Expression: Expression or table column by which to partition.
You can select functions (dropdown on the left only HASH, LINEAR HASH)
and table columns (dropdown on the right).
Depending on the selected function, suitable table columns are made available.

If a HASH partitioning is to be partitioned according to a TIMESTAMP column, the UNIX_TIMESTAMP( column ) function must be used.
Number of subpartitions: Specification of how many sub-partitions should be created.


All table columns used for partitioning must be present in all UNIQUE indexes.
The program does this automatically and adds the columns to the indexes when partitioning.
In the table column selection, columns that already exist in all UNIQUE indices are displayed in blue color.
Partition editor:
MariaDB - Creating SYSTEM_TIME partitions
Name: Name of the partition.
Description: Type of data stored in partition HISTORY or CURRENT.
Only one CURRENT partition is created at a time.
Subpartition: Name of the sub-partition.
Data Directory: Number of data rows in partition.
Minimum number of rows: MySQL partition management benchmark that specifies the minimum number of data rows in the partition.
Maximum number of rows: MySQL partition management benchmark that specifies the maximum number of data rows in the partition.
TABLESPACE: Selection of a defined TABLESPACE entry that contains information about the storage space of tables.
Comment: Comment on the partition.

For data directory, minimum number of rows, maximum number of rows and TABLESPACE, the value contained can be copied to all other partitions by double-clicking on the input field.

Save changes Create partitions.
Show SQL statement Show the SQL statement to create the partitions.
More information about creating SYSTEM_TIME partitions in MariaDB tables: mariadb.com
Updated: 2023-09-15ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2023 Heino Cunze-Fischer