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 | A | A | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 0 | 2024-05-18 15:02:44 | 2024-05-18 15:04:38 | NULL | NULL | NULL | |||
def | A | AB | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 32768 | 0 | 2024-05-18 15:04:06 | 2024-05-18 15:05:04 | NULL | NULL | NULL | |||
def | A | B | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:02 | 2024-05-18 15:03:44 | NULL | NULL | NULL | |||
def | CA 01 | employees | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | 2024-05-18 15:07:14 | 2024-05-18 15:07:14 | NULL | NULL | NULL | |||
def | Students | Ученики | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-05-18 15:08:51 | NULL | NULL | NULL | NULL | |||
def | exceptional | admin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 8 | 2048 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:08 | NULL | NULL | NULL | NULL | |||
def | exceptional | blog | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:08 | NULL | NULL | NULL | NULL | |||
def | exceptional | categories | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:08 | NULL | NULL | NULL | NULL | |||
def | exceptional | content | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:09 | NULL | NULL | NULL | NULL | |||
def | exceptional | course | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:09 | NULL | NULL | NULL | NULL | |||
def | exceptional | library | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:10 | NULL | NULL | NULL | NULL | |||
def | exceptional | quiz | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 4 | 4096 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:10 | NULL | NULL | NULL | NULL | |||
def | exceptional | teacher | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 5461 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:11 | NULL | NULL | NULL | NULL | |||
def | exceptional | team | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 8192 | 16384 | 0 | 0 | 0 | 2024-05-18 15:03:11 | NULL | 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_PRIVILEGES | 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 | ENGINES | 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_BUFFER_PAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL |
|