10.优化

禁用索引：alter table t1 DISABLE KEYS;
禁用唯一性检查：set unique_checks=0;
禁用外键检查：set foreign_key_checks=0;
set autocommit=0;

create table tb_member( id bigint primary key, name varchar(20), sex tinyint not null default ‘0’ ) engine=merge union=(tb_member1,tb_member2) insert_method=last charset=utf8;

create table user( id int not null auto_increment primary key, name varchar(30) not null default ‘’, sex int(1) not null default ‘0’)default charset=utf8 auto_increment=1
-> partition by range(id)(
-> partition p0 values less than (3),
-> partition p1 values less than (6),
-> partition p2 values less than (9),
-> partition p3 values less than (12),
-> partition p4 values less than maxvalue);

select * from information_schema.partitions where table_schema=‘test2’ and table_name=‘user’\G

select * from test2.user partition(p0);
添加分区：alter table test2.user add partition(partition partitionname values less than(15));

删除分区： alter table test2.user drop partition p3;
合并分区：alter table test2.user reorganize partition p1,p2 into (partition p1 values less than (8), partition p2 values less than (12));