5.5.8. DDL for Partitioned Tables

The mechanism used for DDL operations on partitioned tables is somewhat different from the online DDL discussed throughout this section. The partitioning clauses of the ALTER TABLE statement are only allowed in conjunction with ALGORITHM=DEFAULT and LOCK=DEFAULT. Although these operations do not go through the same internal online DDL API as for non-partitioned tables, MySQL still attempts to minimize data copying and locking where possible:

Spec-Zone.ru - all specs in one place