content_image/840652.jpg
The following table shows the online status for each ALTER TABLE  partitioning statement. Regardless of the online DDL API that is used, MySQL attempts to minimize data copying and locking where possible. 

ALTER TABLE  partitioning options that use ALGORITHM=COPY  or that only permit “ ALGORITHM=DEFAULT, LOCK=DEFAULT ” , repartition the table using the COPY  algorithm. In other words, a new partitioned table is created with the new partitioning scheme. The newly created table includes any changes applied by the ALTER TABLE  statement, and table data is copied into the new table structure. 

<img src='content_image/840652.jpg'>

