Skip to main content

查看Mysql数据库表的分区情况

select TABLE_SCHEMA,TABLE_NAME,PARTITION_NAME,TABLE_ROWS from information_schema.partitions where table_schema = 'shunsync'  and table_name='sl_history_data';

image.png