Partitioning The advantage of partitioning is that we can drop /
truncate the partitions which is real quick and done in seconds.
It does lock the table (metadata lock) during this operation but
only for few seconds. That duration depends on the number of
pages in use in the buffer pool. With MySQL 5.6 it is possible to
exchange the partitions , which helps in moving archived data to
another table with similar structure.
Fully Automated archival / purge
Consider a fast growing table which is partitioned to help the queries and help quick archival/purge. The queries if specify the …