[Original] 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:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/23113WF6-0.png "border =" 0 "alt =" "/>

T2 table structure:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/23113S3N-1.png "border =" 0 "alt =" "/>

Data creation script:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/23113R139-2.png "border =" 0 "alt =" "/>

Partition replacement Demo:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/23113S3E-3.png "border =" 0 "alt =" "/>

Demonstration of Restoring original partitions:

650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/23113Q2W-4.png "border =" 0 "alt =" "/>

This article is from "god, let's see it !" Blog, please be sure to keep this source http://yueliangdao0608.blog.51cto.com/397025/1149057