Home > Database > Mysql Tutorial > MySQL 5.6置换分区体验_MySQL

MySQL 5.6置换分区体验_MySQL

WBOY
Release: 2016-06-01 13:35:46
Original
997 people have browsed it

bitsCN.com

MySQL 5.6置换分区体验

MySQL 5.6.10 正式版发布好多天了, 经常使用分区的朋友有福了。
MySQL 5.6 增加了对分区的置换功能。今天我们来体验下关于置换分区的功能。 

两张示例表,t1为分区表,t2为普通的INNODB表。

t1 表结构:

MySQL 5.6置换分区体验_MySQL
 

t2 表结构:

 

MySQL 5.6置换分区体验_MySQL

造数据脚本:

 

MySQL 5.6置换分区体验_MySQL


置换分区演示:

 

MySQL 5.6置换分区体验_MySQL


恢复原始分区演示:

 

MySQL 5.6置换分区体验_MySQL

bitsCN.com
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template