MariaDB [db1]> create or replace table t1 (a int) with system versioning partition by system_time limit 100 (partition p0 history, partition pc current);
|
Query OK, 0 rows affected (0.41 sec)
|
|
MariaDB [db1]> select * from information_schema.partitions where table_schema = 'db1' and table_name = 't1' \G
|
*************************** 1. row ***************************
|
TABLE_CATALOG: def
|
TABLE_SCHEMA: db1
|
TABLE_NAME: t1
|
PARTITION_NAME: p0
|
SUBPARTITION_NAME: NULL
|
PARTITION_ORDINAL_POSITION: 1
|
SUBPARTITION_ORDINAL_POSITION: NULL
|
PARTITION_METHOD: SYSTEM_TIME
|
SUBPARTITION_METHOD: NULL
|
PARTITION_EXPRESSION: `row_end`
|
SUBPARTITION_EXPRESSION: NULL
|
PARTITION_DESCRIPTION: NULL
|
TABLE_ROWS: 0
|
AVG_ROW_LENGTH: 0
|
DATA_LENGTH: 16384
|
MAX_DATA_LENGTH: NULL
|
INDEX_LENGTH: 0
|
DATA_FREE: 0
|
CREATE_TIME: 2018-04-23 23:15:26
|
UPDATE_TIME: NULL
|
CHECK_TIME: NULL
|
CHECKSUM: NULL
|
PARTITION_COMMENT:
|
NODEGROUP: default
|
TABLESPACE_NAME: NULL
|
*************************** 2. row ***************************
|
TABLE_CATALOG: def
|
TABLE_SCHEMA: db1
|
TABLE_NAME: t1
|
PARTITION_NAME: pc
|
SUBPARTITION_NAME: NULL
|
PARTITION_ORDINAL_POSITION: 2
|
SUBPARTITION_ORDINAL_POSITION: NULL
|
PARTITION_METHOD: SYSTEM_TIME
|
SUBPARTITION_METHOD: NULL
|
PARTITION_EXPRESSION: `row_end`
|
SUBPARTITION_EXPRESSION: NULL
|
PARTITION_DESCRIPTION: CURRENT
|
TABLE_ROWS: 0
|
AVG_ROW_LENGTH: 0
|
DATA_LENGTH: 16384
|
MAX_DATA_LENGTH: NULL
|
INDEX_LENGTH: 0
|
DATA_FREE: 0
|
CREATE_TIME: 2018-04-23 23:15:26
|
UPDATE_TIME: NULL
|
CHECK_TIME: NULL
|
CHECKSUM: NULL
|
PARTITION_COMMENT:
|
NODEGROUP: default
|
TABLESPACE_NAME: NULL
|
2 rows in set (0.02 sec)
|