mysql分区管理
查看表分区:
SELECT
PARTITION_NAME,
TABLE_ROWS,
PARTITION_EXPRESSION,
PARTITION_DESCRIPTION
FROM
INFORMATION_SCHEMA.PARTITIONS
WHERE
TABLE_SCHEMA = 'schema_name'
AND TABLE_NAME = 'table_name';
删除分区:
alter table edgink_db.edgink_tag_storage drop partition parxxx;