MySQL5.6 partition replacement experience _ MySQL

Experience bitsCN.com in MySQL5.6 partition replacement

MySQL 5.6 swap partition experience

MySQL 5.6.10 official version has been released for many days.
MySQL 5.6 adds the partition replacement function. Today, let's try out the partition replacement function.

Two example tables: t1 is a partitioned table and t2 is a normal INNODB table.

T1 table structure:

T2 table structure:

Data creation script:

Partition replacement demo:

Demonstration of restoring original partitions:

BitsCN.com