Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 2;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 4;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 8;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 16;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 32;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 64;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 128;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 256;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 512;
- alter table t engine=innodb;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1024;
- alter table t engine=innodb;
- drop table if exists t;
- RESULTS
- -----------------
- mysql> select version();
- +-----------+
- | version() |
- +-----------+
- | 5.7.16 |
- +-----------+
- 1 row in set (0.00 sec)
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected, 1 warning (0.00 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1;
- Query OK, 0 rows affected (0.01 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (0.02 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.00 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 2;
- Query OK, 0 rows affected (0.00 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (0.02 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.00 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 4;
- Query OK, 0 rows affected (0.01 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (0.07 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.01 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 8;
- Query OK, 0 rows affected (0.01 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (0.06 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.01 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 16;
- Query OK, 0 rows affected (0.01 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (0.10 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.02 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 32;
- Query OK, 0 rows affected (0.02 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (0.56 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.04 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 64;
- Query OK, 0 rows affected (0.02 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (1.66 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.07 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 128;
- Query OK, 0 rows affected (0.05 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (4.07 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.17 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 256;
- Query OK, 0 rows affected (0.10 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (13.08 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.41 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 512;
- Query OK, 0 rows affected (0.19 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (23.09 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.63 sec)
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1024;
- Query OK, 0 rows affected (0.34 sec)
- mysql> alter table t engine=innodb;
- Query OK, 0 rows affected (35.44 sec)
- Records: 0 Duplicates: 0 Warnings: 0
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (1.23 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment