SELECT * FROM `PARTITIONS`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | mysql | innodb_table_stats | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 60 | 273 | 16384 | 0 | 0 | 4194304 | 2019-10-30 14:09:22 | 2024-08-24 05:23:00 | NULL | NULL | NULL | |||
def | mysql | innodb_index_stats | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 304 | 215 | 65536 | 0 | 0 | 4194304 | 2019-10-30 14:09:22 | 2024-08-24 05:23:00 | NULL | NULL | NULL | |||
def | information_schema | CHARACTER_SETS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | CHECK_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMN_STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | FILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_DATAFILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_FOREIGN | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_FOREIGN_COLS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_FIELDS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_TABLESPACES_BRIEF | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | KEY_COLUMN_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | KEYWORDS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | PARAMETERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | PARTITIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | REFERENTIAL_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | RESOURCE_GROUPS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | ROUTINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | SCHEMATA | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | ST_SPATIAL_REFERENCE_SYSTEMS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | ST_UNITS_OF_MEASURE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL |
|