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);