partitions

Overview

Show the Partition status of all tables in the database. Before 2.1.7(inclusive), the tables were always empty.

Database

information_schema

Table Information

Column Name	Type	Description
TABLE_CATALOG	varchar(64)	Catalog name
TABLE_SCHEMA	varchar(64)	Database name
TABLE_NAME	varchar(64)	Table name
PARTITION_NAME	varchar(64)	Partition name
SUBPARTITION_NAME	varchar(64)	Always empty
PARTITION_ORDINAL_POSITION	int	Ordinal position of the partition
SUBPARTITION_ORDINAL_POSITION	int	Always empty
PARTITION_METHOD	varchar(13)	Partition method
SUBPARTITION_METHOD	varchar(13)	Always empty
PARTITION_EXPRESSION	varchar(2048)	Partition expression
SUBPARTITION_EXPRESSION	varchar(2048)	Always empty
PARTITION_DESCRIPTION	text	Partition description
TABLE_ROWS	bigint
AVG_ROW_LENGTH	bigint
DATA_LENGTH	bigint
MAX_DATA_LENGTH	bigint
INDEX_LENGTH	bigint
DATA_FREE	bigint
CREATE_TIME	bigint
UPDATE_TIME	datetime
CHECK_TIME	datetime
CHECKSUM	bigint
PARTITION_COMMENT	text
NODEGROUP	varchar(256)
TABLESPACE_NAME	varchar(268)