MySQL 8 Cookbook

ADD partitions

To add a new partition, execute the ADD PARTITION (<PARTITION DEFINITION>) statement:

mysql> ALTER TABLE event_history ADD PARTITION (PARTITION p20171016 VALUES LESS THAN (736983) ENGINE = InnoDB,PARTITION p20171017 VALUES LESS THAN (736984) ENGINE = InnoDB);

This statement locks the whole table for a very short time.