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
statement are only allowed in conjunction with
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
ADD PARTITION and
PARTITION for tables partitioned by
LIST do not
copy any existing data.
TRUNCATE PARTITION does not copy any
existing data, for all types of partitioned tables.
Concurrent queries are allowed during
for tables partitioned by
LIST. MySQL copies the data while holding a
ADD PARTITION or
COALESCE PARTITION for a table partitioned
LINEAR HASH or
concurrent queries are allowed. Data from the affected
partitions is copied while holding a shared lock.