API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 23rd, 2012
692
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 66.21 KB | None | 0 0
raw download clone embed print report
  1. mysql> select version();
  2. +-------------------------+
  3. | version() |
  4. +-------------------------+
  5. | 5.5.28-0ubuntu0.12.04.3 |
  6. +-------------------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> show processlist;
  10. +----+------+---------------------+--------+---------+------+-------+------------------+
  11. | Id | User | Host | db | Command | Time | State | Info |
  12. +----+------+---------------------+--------+---------+------+-------+------------------+
  13. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 6 | | NULL |
  14. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 126 | | NULL |
  15. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  16. +----+------+---------------------+--------+---------+------+-------+------------------+
  17. 3 rows in set (0.00 sec)
  18.  
  19. mysql> show processlist;
  20. +----+------+---------------------+--------+---------+------+-------+------------------+
  21. | Id | User | Host | db | Command | Time | State | Info |
  22. +----+------+---------------------+--------+---------+------+-------+------------------+
  23. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 106 | | NULL |
  24. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 226 | | NULL |
  25. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  26. +----+------+---------------------+--------+---------+------+-------+------------------+
  27. 3 rows in set (0.00 sec)
  28.  
  29. mysql> show processlist;
  30. +----+------+---------------------+--------+---------+------+-------+------------------+
  31. | Id | User | Host | db | Command | Time | State | Info |
  32. +----+------+---------------------+--------+---------+------+-------+------------------+
  33. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 107 | | NULL |
  34. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 227 | | NULL |
  35. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  36. +----+------+---------------------+--------+---------+------+-------+------------------+
  37. 3 rows in set (0.00 sec)
  38.  
  39. mysql> show processlist;
  40. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  41. | Id | User | Host | db | Command | Time | State | Info |
  42. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  43. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 224 | | NULL |
  44. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 11 | | NULL |
  45. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  46. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 29 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  47. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 14 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  48. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  49. 5 rows in set (0.00 sec)
  50.  
  51. mysql> show processlist;
  52. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  53. | Id | User | Host | db | Command | Time | State | Info |
  54. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  55. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 228 | | NULL |
  56. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 15 | | NULL |
  57. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  58. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 33 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  59. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 18 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  60. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 3 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  61. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  62. 6 rows in set (0.00 sec)
  63.  
  64. mysql> show processlist;
  65. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  66. | Id | User | Host | db | Command | Time | State | Info |
  67. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  68. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 229 | | NULL |
  69. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 16 | | NULL |
  70. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  71. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 34 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  72. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 19 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  73. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 4 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  74. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  75. 6 rows in set (0.00 sec)
  76.  
  77. mysql> show processlist;
  78. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  79. | Id | User | Host | db | Command | Time | State | Info |
  80. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  81. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 230 | | NULL |
  82. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 17 | | NULL |
  83. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  84. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 35 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  85. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 20 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  86. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 5 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  87. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  88. 6 rows in set (0.00 sec)
  89.  
  90. mysql> show processlist;
  91. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  92. | Id | User | Host | db | Command | Time | State | Info |
  93. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  94. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 231 | | NULL |
  95. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 18 | | NULL |
  96. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  97. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 36 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  98. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 21 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  99. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 6 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  100. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  101. 6 rows in set (0.00 sec)
  102.  
  103. mysql> show processlist;
  104. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  105. | Id | User | Host | db | Command | Time | State | Info |
  106. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  107. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 231 | | NULL |
  108. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 18 | | NULL |
  109. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  110. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 36 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  111. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 21 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  112. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 6 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  113. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  114. 6 rows in set (0.00 sec)
  115.  
  116. mysql> show processlist;
  117. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  118. | Id | User | Host | db | Command | Time | State | Info |
  119. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  120. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 232 | | NULL |
  121. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 19 | | NULL |
  122. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  123. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 37 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  124. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 22 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  125. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 7 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  126. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  127. 6 rows in set (0.00 sec)
  128.  
  129. mysql> show processlist;
  130. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  131. | Id | User | Host | db | Command | Time | State | Info |
  132. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  133. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 232 | | NULL |
  134. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 19 | | NULL |
  135. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  136. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 37 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  137. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 22 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  138. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 7 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  139. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  140. 6 rows in set (0.00 sec)
  141.  
  142. mysql> show processlist;
  143. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  144. | Id | User | Host | db | Command | Time | State | Info |
  145. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  146. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 233 | | NULL |
  147. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 20 | | NULL |
  148. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  149. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 38 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  150. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 23 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  151. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 8 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  152. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  153. 6 rows in set (0.00 sec)
  154.  
  155. mysql> show processlist;
  156. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  157. | Id | User | Host | db | Command | Time | State | Info |
  158. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  159. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 234 | | NULL |
  160. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 21 | | NULL |
  161. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  162. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 39 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  163. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 24 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  164. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 9 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  165. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  166. 6 rows in set (0.00 sec)
  167.  
  168. mysql> show processlist;
  169. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  170. | Id | User | Host | db | Command | Time | State | Info |
  171. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  172. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 234 | | NULL |
  173. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 21 | | NULL |
  174. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  175. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 39 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  176. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 24 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  177. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 9 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  178. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  179. 6 rows in set (0.00 sec)
  180.  
  181. mysql> show processlist;
  182. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  183. | Id | User | Host | db | Command | Time | State | Info |
  184. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  185. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 386 | | NULL |
  186. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 17 | | NULL |
  187. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  188. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 191 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  189. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 176 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  190. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 161 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  191. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 146 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  192. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 131 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  193. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 116 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  194. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 101 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  195. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 86 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  196. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 71 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  197. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 56 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  198. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 41 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  199. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 26 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  200. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 11 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  201. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  202. 16 rows in set (0.00 sec)
  203.  
  204. mysql> show processlist;
  205. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  206. | Id | User | Host | db | Command | Time | State | Info |
  207. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  208. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 387 | | NULL |
  209. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 18 | | NULL |
  210. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  211. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 192 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  212. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 177 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  213. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 162 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  214. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 147 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  215. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 132 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  216. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 117 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  217. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 102 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  218. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 87 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  219. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 72 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  220. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 57 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  221. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 42 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  222. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 27 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  223. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 12 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  224. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  225. 16 rows in set (0.00 sec)
  226.  
  227. mysql> show processlist;
  228. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  229. | Id | User | Host | db | Command | Time | State | Info |
  230. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  231. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 422 | | NULL |
  232. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 53 | | NULL |
  233. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  234. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 227 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  235. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 212 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  236. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 197 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  237. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 182 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  238. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 167 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  239. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 152 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  240. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 137 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  241. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 122 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  242. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 107 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  243. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 92 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  244. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 77 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  245. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 62 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  246. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 47 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  247. | 91 | root | 192.168.0.171:41156 | pooldb | Query | 32 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  248. | 92 | root | 192.168.0.171:41157 | pooldb | Query | 17 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  249. | 93 | root | 192.168.0.171:41158 | pooldb | Query | 2 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  250. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  251. 19 rows in set (0.00 sec)
  252.  
  253. mysql> show processlist;
  254. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  255. | Id | User | Host | db | Command | Time | State | Info |
  256. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  257. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 423 | | NULL |
  258. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 54 | | NULL |
  259. | 38 | root | localhost | NULL | Query | 0 | NULL | show processlist |
  260. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 228 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  261. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 213 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  262. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 198 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  263. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 183 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  264. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 168 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  265. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 153 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  266. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 138 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  267. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 123 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  268. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 108 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  269. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 93 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  270. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 78 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  271. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 63 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  272. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 48 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  273. | 91 | root | 192.168.0.171:41156 | pooldb | Query | 33 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  274. | 92 | root | 192.168.0.171:41157 | pooldb | Query | 18 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  275. | 93 | root | 192.168.0.171:41158 | pooldb | Query | 3 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INT |
  276. +----+------+---------------------+--------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+
  277. 19 rows in set (0.00 sec)
  278.  
  279. mysql> show full processlist;
  280. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  281. | Id | User | Host | db | Command | Time | State | Info |
  282. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  283. | 36 | root | 192.168.0.171:41106 | pooldb | Sleep | 445 | | NULL |
  284. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 15 | | NULL |
  285. | 38 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
  286. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 250 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  287. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 235 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  288. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 220 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  289. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 205 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  290. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 190 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  291. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 175 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  292. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 160 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  293. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 145 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  294. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 130 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  295. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 115 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  296. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 100 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  297. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 85 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  298. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 70 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  299. | 91 | root | 192.168.0.171:41156 | pooldb | Query | 55 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  300. | 92 | root | 192.168.0.171:41157 | pooldb | Query | 40 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  301. | 93 | root | 192.168.0.171:41158 | pooldb | Query | 25 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  302. | 94 | root | 192.168.0.171:41161 | pooldb | Query | 10 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  303. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  304. 20 rows in set (0.00 sec)
  305.  
  306. mysql> show full processlist;
  307. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  308. | Id | User | Host | db | Command | Time | State | Info |
  309. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  310. | 36 | root | 192.168.0.171:41106 | pooldb | Query | 192 | Waiting for table metadata lock | select COUNT(*) from pool_worker where username = 'alexhk_1' and password = 'test' |
  311. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 196 | | NULL |
  312. | 38 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
  313. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 472 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  314. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 457 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  315. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 442 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  316. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 427 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  317. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 412 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  318. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 397 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  319. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 382 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  320. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 367 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  321. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 352 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  322. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 337 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  323. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 322 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  324. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 307 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  325. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 292 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  326. | 91 | root | 192.168.0.171:41156 | pooldb | Query | 277 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  327. | 92 | root | 192.168.0.171:41157 | pooldb | Query | 262 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  328. | 93 | root | 192.168.0.171:41158 | pooldb | Query | 247 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  329. | 94 | root | 192.168.0.171:41161 | pooldb | Query | 232 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  330. | 95 | root | 192.168.0.171:41162 | pooldb | Query | 217 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  331. | 96 | root | 192.168.0.171:41163 | pooldb | Query | 202 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  332. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  333. 22 rows in set (0.00 sec)
  334.  
  335. mysql> show full processlist;
  336. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  337. | Id | User | Host | db | Command | Time | State | Info |
  338. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  339. | 36 | root | 192.168.0.171:41106 | pooldb | Query | 217 | Waiting for table metadata lock | select COUNT(*) from pool_worker where username = 'alexhk_1' and password = 'test' |
  340. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 14 | | NULL |
  341. | 38 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
  342. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 497 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  343. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 482 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  344. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 467 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  345. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 452 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  346. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 437 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  347. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 422 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  348. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 407 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  349. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 392 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  350. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 377 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  351. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 362 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  352. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 347 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  353. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 332 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  354. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 317 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  355. | 91 | root | 192.168.0.171:41156 | pooldb | Query | 302 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  356. | 92 | root | 192.168.0.171:41157 | pooldb | Query | 287 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  357. | 93 | root | 192.168.0.171:41158 | pooldb | Query | 272 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  358. | 94 | root | 192.168.0.171:41161 | pooldb | Query | 257 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  359. | 95 | root | 192.168.0.171:41162 | pooldb | Query | 242 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  360. | 96 | root | 192.168.0.171:41163 | pooldb | Query | 227 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  361. | 97 | root | 192.168.0.171:41169 | pooldb | Query | 15 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  362. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  363. 23 rows in set (0.01 sec)
  364.  
  365. mysql> show full processlist;
  366. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  367. | Id | User | Host | db | Command | Time | State | Info |
  368. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  369. | 36 | root | 192.168.0.171:41106 | pooldb | Query | 218 | Waiting for table metadata lock | select COUNT(*) from pool_worker where username = 'alexhk_1' and password = 'test' |
  370. | 37 | root | 192.168.0.171:41107 | pooldb | Sleep | 15 | | NULL |
  371. | 38 | root | localhost | NULL | Query | 0 | NULL | show full processlist |
  372. | 70 | root | 192.168.0.171:41137 | pooldb | Query | 498 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  373. | 71 | root | 192.168.0.171:41138 | pooldb | Query | 483 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  374. | 72 | root | 192.168.0.171:41139 | pooldb | Query | 468 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  375. | 73 | root | 192.168.0.171:41140 | pooldb | Query | 453 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  376. | 74 | root | 192.168.0.171:41143 | pooldb | Query | 438 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  377. | 75 | root | 192.168.0.171:41144 | pooldb | Query | 423 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  378. | 76 | root | 192.168.0.171:41145 | pooldb | Query | 408 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  379. | 79 | root | 192.168.0.171:41146 | pooldb | Query | 393 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  380. | 86 | root | 192.168.0.171:41149 | pooldb | Query | 378 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  381. | 87 | root | 192.168.0.171:41150 | pooldb | Query | 363 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  382. | 88 | root | 192.168.0.171:41151 | pooldb | Query | 348 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  383. | 89 | root | 192.168.0.171:41152 | pooldb | Query | 333 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  384. | 90 | root | 192.168.0.171:41155 | pooldb | Query | 318 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  385. | 91 | root | 192.168.0.171:41156 | pooldb | Query | 303 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  386. | 92 | root | 192.168.0.171:41157 | pooldb | Query | 288 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  387. | 93 | root | 192.168.0.171:41158 | pooldb | Query | 273 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  388. | 94 | root | 192.168.0.171:41161 | pooldb | Query | 258 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  389. | 95 | root | 192.168.0.171:41162 | pooldb | Query | 243 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  390. | 96 | root | 192.168.0.171:41163 | pooldb | Query | 228 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  391. | 97 | root | 192.168.0.171:41169 | pooldb | Query | 16 | Waiting for table metadata lock | create table if not exists pool_worker(id serial primary key,username TEXT, password TEXT, speed INTEGER, last_checkin timestamp) ENGINE = MYISAM |
  392. +----+------+---------------------+--------+---------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+
  393. 23 rows in set (0.00 sec)
  394.  
  395. mysql> exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!