SELECT * FROM `PARTITIONS`
ORDER BY `PARTITIONS`.`DATA_LENGTH` 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 | AVG_ROW_LENGTH | DATA_LENGTH 1 | 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 | 109876 | 109 | 12075008 | NULL | 2637824 | 0 | 2020-11-20 09:48:15 | NULL | NULL | NULL | NULL | |||
def | gym | gym_course_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 503 | 3159 | 1589248 | NULL | 0 | 0 | 2024-02-23 23:09:02 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_fans_authcode | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1828 | 161 | 294912 | NULL | 0 | 0 | 2021-10-24 22:36:53 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_user_city_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2547 | 109 | 278528 | NULL | 0 | 0 | 2020-01-16 23:14:00 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_city_code_json_data | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 262144 | 262144 | NULL | 0 | 0 | 2023-08-03 14:00:54 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_xiaoqu_unlock_phone | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1258 | 169 | 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 | 1128 | 174 | 196608 | NULL | 0 | 0 | 2024-02-24 07:05:31 | NULL | NULL | NULL | NULL | |||
def | gym | gym_mbw_my_address | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3468 | 51 | 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 | 3312 | 54 | 180224 | NULL | 0 | 0 | 2023-08-03 14:08:05 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_user_event | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 397 | 371 | 147456 | NULL | 0 | 0 | 2019-04-25 12:19:09 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_store_canyin_order | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 69 | 1899 | 131072 | NULL | 0 | 0 | 2020-11-17 13:49:36 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_store_jianlou_quan | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 241 | 475 | 114688 | NULL | 0 | 0 | 2020-07-15 15:14:36 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_store_sales_sum_record | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 220 | 521 | 114688 | NULL | 0 | 0 | 2020-07-15 20:30:20 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_platform_trade_bill | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 198 | 496 | 98304 | NULL | 0 | 0 | 2022-12-19 20:57:20 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_3rd_xuni_goods_lib | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 793 | 103 | 81920 | NULL | 0 | 0 | 2022-02-20 16:29:49 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_sms_sent_history | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 170 | 481 | 81920 | NULL | 0 | 0 | 2019-07-01 13:08:51 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_xiaoqu | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 217 | 377 | 81920 | NULL | 16384 | 0 | 2024-02-03 13:10:27 | NULL | NULL | NULL | NULL | |||
def | gym | gym_points_log | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 235 | 278 | 65536 | NULL | 0 | 0 | 2018-03-26 10:44:27 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_auth_code | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 165 | 397 | 65536 | NULL | 0 | 0 | 2023-04-26 15:02:38 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_bianmin_poi | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 52 | 1260 | 65536 | NULL | 16384 | 0 | 2024-01-27 08:15:36 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_chatroom_topic | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 20 | 3276 | 65536 | NULL | 0 | 0 | 2021-10-14 22:05:10 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_chatroom_topic_message | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 40 | 1638 | 65536 | NULL | 0 | 0 | 2021-10-14 12:28:32 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_store_goods | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 18 | 3640 | 65536 | NULL | 49152 | 0 | 2024-01-24 05:04:09 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_wechat_circle | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 58 | 1129 | 65536 | NULL | 0 | 0 | 2019-06-01 12:33:06 | NULL | NULL | NULL | NULL | |||
def | gym | mbw_store_choujiang | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 11 | 4468 | 49152 | NULL | 0 | 0 | 2020-01-17 16:35:25 | NULL | NULL | NULL | NULL |
过滤行: |