Guest User

Untitled

a guest
Oct 19th, 2016
298
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.75 KB | None | 0 0
  1.  
  2. drop table if exists t;
  3. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1;
  4. alter table t engine=innodb;
  5.  
  6. drop table if exists t;
  7. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 2;
  8. alter table t engine=innodb;
  9.  
  10. drop table if exists t;
  11. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 4;
  12. alter table t engine=innodb;
  13.  
  14. drop table if exists t;
  15. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 8;
  16. alter table t engine=innodb;
  17.  
  18. drop table if exists t;
  19. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 16;
  20. alter table t engine=innodb;
  21.  
  22. drop table if exists t;
  23. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 32;
  24. alter table t engine=innodb;
  25.  
  26. drop table if exists t;
  27. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 64;
  28. alter table t engine=innodb;
  29.  
  30. drop table if exists t;
  31. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 128;
  32. alter table t engine=innodb;
  33.  
  34. drop table if exists t;
  35. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 256;
  36. alter table t engine=innodb;
  37.  
  38. drop table if exists t;
  39. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 512;
  40. alter table t engine=innodb;
  41.  
  42. drop table if exists t;
  43. create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1024;
  44. alter table t engine=innodb;
  45.  
  46. drop table if exists t;
  47.  
  48.  
  49. RESULTS
  50. -----------------
  51.  
  52. mysql> select version();
  53. +-----------+
  54. | version() |
  55. +-----------+
  56. | 5.7.16 |
  57. +-----------+
  58. 1 row in set (0.00 sec)
  59.  
  60. mysql>
  61. mysql> drop table if exists t;
  62. Query OK, 0 rows affected, 1 warning (0.00 sec)
  63.  
  64. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1;
  65. Query OK, 0 rows affected (0.01 sec)
  66.  
  67. mysql> alter table t engine=innodb;
  68. Query OK, 0 rows affected (0.02 sec)
  69. Records: 0 Duplicates: 0 Warnings: 0
  70.  
  71. mysql>
  72. mysql> drop table if exists t;
  73. Query OK, 0 rows affected (0.00 sec)
  74.  
  75. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 2;
  76. Query OK, 0 rows affected (0.00 sec)
  77.  
  78. mysql> alter table t engine=innodb;
  79. Query OK, 0 rows affected (0.02 sec)
  80. Records: 0 Duplicates: 0 Warnings: 0
  81.  
  82. mysql>
  83. mysql> drop table if exists t;
  84. Query OK, 0 rows affected (0.00 sec)
  85.  
  86. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 4;
  87. Query OK, 0 rows affected (0.01 sec)
  88.  
  89. mysql> alter table t engine=innodb;
  90. Query OK, 0 rows affected (0.07 sec)
  91. Records: 0 Duplicates: 0 Warnings: 0
  92.  
  93. mysql>
  94. mysql> drop table if exists t;
  95. Query OK, 0 rows affected (0.01 sec)
  96.  
  97. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 8;
  98. Query OK, 0 rows affected (0.01 sec)
  99.  
  100. mysql> alter table t engine=innodb;
  101. Query OK, 0 rows affected (0.06 sec)
  102. Records: 0 Duplicates: 0 Warnings: 0
  103.  
  104. mysql>
  105. mysql> drop table if exists t;
  106. Query OK, 0 rows affected (0.01 sec)
  107.  
  108. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 16;
  109. Query OK, 0 rows affected (0.01 sec)
  110.  
  111. mysql> alter table t engine=innodb;
  112. Query OK, 0 rows affected (0.10 sec)
  113. Records: 0 Duplicates: 0 Warnings: 0
  114.  
  115. mysql>
  116. mysql> drop table if exists t;
  117. Query OK, 0 rows affected (0.02 sec)
  118.  
  119. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 32;
  120. Query OK, 0 rows affected (0.02 sec)
  121.  
  122. mysql> alter table t engine=innodb;
  123. Query OK, 0 rows affected (0.56 sec)
  124. Records: 0 Duplicates: 0 Warnings: 0
  125.  
  126. mysql>
  127. mysql> drop table if exists t;
  128. Query OK, 0 rows affected (0.04 sec)
  129.  
  130. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 64;
  131. Query OK, 0 rows affected (0.02 sec)
  132.  
  133. mysql> alter table t engine=innodb;
  134. Query OK, 0 rows affected (1.66 sec)
  135. Records: 0 Duplicates: 0 Warnings: 0
  136.  
  137. mysql>
  138. mysql> drop table if exists t;
  139. Query OK, 0 rows affected (0.07 sec)
  140.  
  141. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 128;
  142. Query OK, 0 rows affected (0.05 sec)
  143.  
  144. mysql> alter table t engine=innodb;
  145. Query OK, 0 rows affected (4.07 sec)
  146. Records: 0 Duplicates: 0 Warnings: 0
  147.  
  148. mysql>
  149. mysql> drop table if exists t;
  150. Query OK, 0 rows affected (0.17 sec)
  151.  
  152. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 256;
  153. Query OK, 0 rows affected (0.10 sec)
  154.  
  155. mysql> alter table t engine=innodb;
  156. Query OK, 0 rows affected (13.08 sec)
  157. Records: 0 Duplicates: 0 Warnings: 0
  158.  
  159. mysql>
  160. mysql> drop table if exists t;
  161. Query OK, 0 rows affected (0.41 sec)
  162.  
  163. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 512;
  164. Query OK, 0 rows affected (0.19 sec)
  165.  
  166. mysql> alter table t engine=innodb;
  167. Query OK, 0 rows affected (23.09 sec)
  168. Records: 0 Duplicates: 0 Warnings: 0
  169.  
  170. mysql>
  171. mysql> drop table if exists t;
  172. Query OK, 0 rows affected (0.63 sec)
  173.  
  174. mysql> create table t(c1 int,c2 char,unique key(c1)) engine=myisam partition by linear key(c1) partitions 1024;
  175. Query OK, 0 rows affected (0.34 sec)
  176.  
  177. mysql> alter table t engine=innodb;
  178. Query OK, 0 rows affected (35.44 sec)
  179. Records: 0 Duplicates: 0 Warnings: 0
  180.  
  181. mysql>
  182. mysql> drop table if exists t;
  183. Query OK, 0 rows affected (1.23 sec)
  184.  
  185. mysql>
Advertisement
Add Comment
Please, Sign In to add comment