Advertisement
Guest User

Untitled

a guest
Oct 19th, 2016
520
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.18 KB | None | 0 0
  1.  
  2. drop table if exists t;
  3. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 1;
  4.  
  5. drop table if exists t;
  6. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 2;
  7.  
  8. drop table if exists t;
  9. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 4;
  10.  
  11. drop table if exists t;
  12.  
  13. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 8;
  14.  
  15. drop table if exists t;
  16.  
  17. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 16;
  18. drop table if exists t;
  19.  
  20. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 32;
  21. drop table if exists t;
  22.  
  23. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 64;
  24. drop table if exists t;
  25.  
  26. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 128;
  27. drop table if exists t;
  28.  
  29. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 256;
  30. drop table if exists t;
  31.  
  32. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 512;
  33. drop table if exists t;
  34.  
  35. create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 1024;
  36. drop table if exists t;
  37.  
  38.  
  39.  
  40. RESULTS:
  41. -------------
  42.  
  43. mysql> select version();
  44. +-----------+
  45. | version() |
  46. +-----------+
  47. | 5.7.16 |
  48. +-----------+
  49. 1 row in set (0.00 sec)
  50.  
  51. mysql>
  52. mysql> drop table if exists t;
  53. Query OK, 0 rows affected, 1 warning (0.00 sec)
  54.  
  55. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 1;
  56. Query OK, 0 rows affected (0.01 sec)
  57.  
  58. mysql>
  59. mysql> drop table if exists t;
  60. Query OK, 0 rows affected (0.01 sec)
  61.  
  62. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 2;
  63. Query OK, 0 rows affected (0.01 sec)
  64.  
  65. mysql>
  66. mysql> drop table if exists t;
  67. Query OK, 0 rows affected (0.01 sec)
  68.  
  69. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 4;
  70. Query OK, 0 rows affected (0.03 sec)
  71.  
  72. mysql>
  73. mysql> drop table if exists t;
  74. Query OK, 0 rows affected (0.01 sec)
  75.  
  76. mysql>
  77. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 8;
  78. Query OK, 0 rows affected (0.04 sec)
  79.  
  80. mysql>
  81. mysql> drop table if exists t;
  82. Query OK, 0 rows affected (0.02 sec)
  83.  
  84. mysql>
  85. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 16;
  86. Query OK, 0 rows affected (0.08 sec)
  87.  
  88. mysql> drop table if exists t;
  89. Query OK, 0 rows affected (0.03 sec)
  90.  
  91. mysql>
  92. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 32;
  93. Query OK, 0 rows affected (0.45 sec)
  94.  
  95. mysql> drop table if exists t;
  96. Query OK, 0 rows affected (0.07 sec)
  97.  
  98. mysql>
  99. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 64;
  100. Query OK, 0 rows affected (1.74 sec)
  101.  
  102. mysql> drop table if exists t;
  103. Query OK, 0 rows affected (0.17 sec)
  104.  
  105. mysql>
  106. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 128;
  107. Query OK, 0 rows affected (5.67 sec)
  108.  
  109. mysql> drop table if exists t;
  110. Query OK, 0 rows affected (1.33 sec)
  111.  
  112. mysql>
  113. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 256;
  114. Query OK, 0 rows affected (12.20 sec)
  115.  
  116. mysql> drop table if exists t;
  117. Query OK, 0 rows affected (0.94 sec)
  118.  
  119. mysql>
  120. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 512;
  121. Query OK, 0 rows affected (30.24 sec)
  122.  
  123. mysql> drop table if exists t;
  124. Query OK, 0 rows affected (1.20 sec)
  125.  
  126. mysql>
  127. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=innodb partition by linear key(c1) partitions 1024;
  128. Query OK, 0 rows affected (57.01 sec)
  129.  
  130. mysql> drop table if exists t;
  131. Query OK, 0 rows affected (2.44 sec)
  132.  
  133. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement