Advertisement
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=innodb partition by linear key(c1) partitions 1;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 2;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 4;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 8;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 16;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 32;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 64;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 128;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 256;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 512;
- drop table if exists t;
- create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 1024;
- 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=innodb partition by linear key(c1) partitions 1;
- Query OK, 0 rows affected (0.01 sec)
- 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=innodb partition by linear key(c1) partitions 2;
- Query OK, 0 rows affected (0.01 sec)
- 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=innodb partition by linear key(c1) partitions 4;
- Query OK, 0 rows affected (0.03 sec)
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.01 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 8;
- Query OK, 0 rows affected (0.04 sec)
- mysql>
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.02 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 16;
- Query OK, 0 rows affected (0.08 sec)
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.03 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 32;
- Query OK, 0 rows affected (0.45 sec)
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.07 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 64;
- Query OK, 0 rows affected (1.74 sec)
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.17 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 128;
- Query OK, 0 rows affected (5.67 sec)
- mysql> drop table if exists t;
- Query OK, 0 rows affected (1.33 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 256;
- Query OK, 0 rows affected (12.20 sec)
- mysql> drop table if exists t;
- Query OK, 0 rows affected (0.94 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 512;
- Query OK, 0 rows affected (30.24 sec)
- mysql> drop table if exists t;
- Query OK, 0 rows affected (1.20 sec)
- mysql>
- mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 1024;
- Query OK, 0 rows affected (57.01 sec)
- mysql> drop table if exists t;
- Query OK, 0 rows affected (2.44 sec)
- mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement