SELECT * FROM `PARTITIONS`
ORDER BY `PARTITIONS`.`TABLE_ROWS` DESC
过滤行: |
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 1 | 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 | gym | gym_mbw_my_unionpay | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 109792 | 109 | 12075008 | NULL | 2637824 | 0 | 2020-11-20 09:48:15 | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_statements_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_waits_history_long | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | gym | gym_mbw_my_address | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3832 | 47 | 180224 | NULL | 0 | 0 | 2020-11-20 09:47:16 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_city_code | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3204 | 56 | 180224 | NULL | 0 | 0 | 2023-08-03 14:08:05 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_user_city_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2413 | 115 | 278528 | NULL | 0 | 0 | 2020-01-16 23:14:00 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_fans_authcode | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2160 | 136 | 294912 | NULL | 0 | 0 | 2021-10-24 22:36:53 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_xiaoqu_unlock_phone | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1385 | 153 | 212992 | NULL | 0 | 0 | 2021-09-28 15:29:38 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_store_jifen | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1069 | 183 | 196608 | NULL | 0 | 0 | 2024-02-24 07:05:31 | NULL | NULL | NULL | NULL | |||
def | performance_schema | accounts | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | cond_instances | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_summary_by_account_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_summary_by_host_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_summary_by_user_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_stages_summary_global_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_statements_current | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_statements_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_statements_summary_by_account_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_statements_summary_by_digest | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_statements_summary_by_host_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | |||
def | performance_schema | events_statements_summary_by_thread_by_event_name | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | 0 | 0 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL |
过滤行: |