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 | information_schema | CHARACTER_SETS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 384 | 0 | 16604160 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 231 | 0 | 16704765 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 195 | 0 | 16691610 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | COLUMN_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2565 | 0 | 16757145 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | ENGINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 490 | 0 | 16709000 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | FILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2659 | 0 | 16770313 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | GLOBAL_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | GLOBAL_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | KEY_COLUMN_USAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4637 | 0 | 16762755 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | OPTIMIZER_TRACE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | PARAMETERS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | PARTITIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | PLUGINS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | PROCESSLIST | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | PROFILING | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 308 | 0 | 16562084 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | REFERENTIAL_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 4814 | 0 | 16767162 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | ROUTINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-10-31 12:45:59 | 2024-10-31 12:45:59 | NULL | NULL | NULL | |||
def | information_schema | SCHEMATA | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3464 | 0 | 16755368 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | SCHEMA_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 2179 | 0 | 16767405 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | SESSION_STATUS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | SESSION_VARIABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 3268 | 0 | 16755036 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 5753 | 0 | 16764242 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL | |||
def | information_schema | TABLES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 9441 | 0 | 16767216 | 0 | 0 | 2024-10-31 12:45:59 | NULL | NULL | NULL | NULL |