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