mysql-hash分区管理维护

1.添加删除新的分区

alter table map_device_packages add partition partitions 10;   ---10为要增加的分区个数 

ALTER TABLE map_device_packages COALESCE PARTITION 6;  ---减少分区的个数

2.重建分区

ALTER TABLE table_name REBUILD PARTITION (p0, p1);

3.优化分区

ALTER TABLE table_name OPTIMIZE PARTITION (p0, p1);

4.分析分区

ALTER TABLE table_name ANALYZE PARTITION (p0, p1);

5.检查分区

ALTER TABLE table_name CHECK PARTITION (p0, p1);