API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 10th, 2017
474
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 45.74 KB | None | 0 0
raw download clone embed print report
  1. =====================================
  2. 2017-08-10 04:09:34 0x7f39702c2700 INNODB MONITOR OUTPUT
  3. =====================================
  4. Per second averages calculated from the last 5 seconds
  5. -----------------
  6. BACKGROUND THREAD
  7. -----------------
  8. srv_master_thread loops: 6457 srv_active, 0 srv_shutdown, 26356 srv_idle
  9. srv_master_thread log flush and writes: 32810
  10. ----------
  11. SEMAPHORES
  12. ----------
  13. OS WAIT ARRAY INFO: reservation count 12027
  14. OS WAIT ARRAY INFO: signal count 22900
  15. RW-shared spins 0, rounds 20298, OS waits 7670
  16. RW-excl spins 0, rounds 144824, OS waits 1682
  17. RW-sx spins 2561, rounds 57257, OS waits 946
  18. Spin rounds per wait: 20298.00 RW-shared, 144824.00 RW-excl, 22.36 RW-sx
  19. ------------------------
  20. LATEST DETECTED DEADLOCK
  21. ------------------------
  22. 2017-08-10 03:56:00 0x7f397033c700
  23. *** (1) TRANSACTION:
  24. TRANSACTION 2210333, ACTIVE 1 sec starting index read
  25. mysql tables in use 17, locked 17
  26. LOCK WAIT 44 lock struct(s), heap size 8400, 309 row lock(s)
  27. MySQL thread id 122010, OS thread handle 0x7f3969e13700, query id 2708471 localhost site1 updating
  28. update `users` set `duplicate_browser_id` = 1, `updated_at` = '2017-08-10 07:56:00' where `id` in (2, 5, 13, 19, 31, 48, 49, 53, 54, 57, 61, 63, 64, 65, 72, 89, 94, 106, 107, 113, 115, 116, 127, 158, 163, 166, 173, 174, 175, 176, 177, 180, 185, 200, 202, 212, 213, 219, 251, 260, 262, 275, 292, 294, 296, 300, 310, 322, 327, 328, 344, 346, 348, 353, 355, 368, 374, 381, 385, 393, 395, 397, 402, 409, 431, 432, 437, 439, 441, 450, 453, 464, 470, 471, 474, 483, 491, 494, 501, 503, 508, 509, 512, 513, 514, 515, 520, 530, 535, 536, 549, 551, 563, 565, 568, 584, 587, 594, 600, 608, 614, 617, 620, 622, 628, 639, 640, 649, 658, 662, 665, 667, 676, 678, 687, 689, 702, 709, 712, 716, 731, 738, 739, 742, 744, 746, 748, 749, 750, 752, 760, 762, 765, 766, 768, 771, 774, 777, 779, 780, 781, 782, 783, 797, 800, 829, 831, 835, 838, 842, 847, 862, 872, 889, 897, 898, 899, 901, 905, 906, 912, 925, 927, 929, 933, 937, 944, 945, 952,
  29. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  30. RECORD LOCKS space id 393 page no 137 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210333 lock_mode X locks rec but not gap waiting
  31. Record lock, heap no 16 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  32. 0: len 4; hex 000006a8; asc ;;
  33. 1: len 6; hex 000000210f2a; asc ! *;;
  34. 2: len 7; hex 74000003b3010d; asc t ;;
  35. 3: len 8; hex 686f6164616f3031; asc hoadao01;;
  36. 4: len 22; hex 68616e6f696269636864616f40676d61696c2e636f6d; asc hanoibichdao@gmail.com;;
  37. 5: len 30; hex 24327924313024746632474f797879446a615477447753546b504a326550; asc $2y$10$tf2GOyxyDjaTwDwSTkPJ2eP; (total 60 bytes);
  38. 6: len 30; hex 383866316262396135383032386464356163356432346636326561343631; asc 88f1bb9a58028dd5ac5d24f62ea461; (total 64 bytes);
  39. 7: len 2; hex 7669; asc vi;;
  40. 8: len 7; hex 566965746e616d; asc Vietnam;;
  41. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  42. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  43. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  44. 12: len 4; hex 00000001; asc ;;
  45. 13: len 4; hex 36363639; asc 6669;;
  46. 14: len 4; hex 626c7565; asc blue;;
  47. 15: SQL NULL;
  48. 16: SQL NULL;
  49. 17: len 4; hex 7fff88f5; asc ;;
  50. 18: len 1; hex 80; asc ;;
  51. 19: len 1; hex 80; asc ;;
  52. 20: SQL NULL;
  53. 21: len 1; hex 80; asc ;;
  54. 22: SQL NULL;
  55. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  56. 24: len 1; hex 80; asc ;;
  57. 25: SQL NULL;
  58. 26: SQL NULL;
  59. 27: len 1; hex 81; asc ;;
  60. 28: len 1; hex 80; asc ;;
  61. 29: len 1; hex 81; asc ;;
  62. 30: len 4; hex 75736572; asc user;;
  63. 31: len 4; hex 00000005; asc ;;
  64. 32: len 4; hex 000006a4; asc ;;
  65. 33: len 4; hex 00000001; asc ;;
  66. 34: len 4; hex 596a336f; asc Yj3o;;
  67. 35: len 4; hex 598b3191; asc Y 1 ;;
  68.  
  69. *** (2) TRANSACTION:
  70. TRANSACTION 2210332, ACTIVE 0 sec starting index read, thread declared inside InnoDB 5000
  71. mysql tables in use 17, locked 17
  72. 4 lock struct(s), heap size 1136, 4 row lock(s)
  73. MySQL thread id 122011, OS thread handle 0x7f397033c700, query id 2708477 localhost site1 updating
  74. update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 07:56:00' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700, 1704, 1708, 1739, 1779, 1786, 1833, 1856, 1867, 1873, 1895, 1910, 1915, 1945, 1962, 1967, 1995, 1996, 2039, 2050, 2081, 2097, 2105, 2125, 2131, 2133, 2137, 2159, 2169, 2172, 2173, 2177, 2187, 2194, 2198, 2199, 2203, 2204, 2205, 2218, 2225, 2226, 2228, 2232, 2234, 2235, 2254, 2257, 2262, 2263, 2268, 2284, 2285, 2305, 2352,
  75. *** (2) HOLDS THE LOCK(S):
  76. RECORD LOCKS space id 393 page no 137 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210332 lock_mode X locks rec but not gap
  77. Record lock, heap no 16 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  78. 0: len 4; hex 000006a8; asc ;;
  79. 1: len 6; hex 000000210f2a; asc ! *;;
  80. 2: len 7; hex 74000003b3010d; asc t ;;
  81. 3: len 8; hex 686f6164616f3031; asc hoadao01;;
  82. 4: len 22; hex 68616e6f696269636864616f40676d61696c2e636f6d; asc hanoibichdao@gmail.com;;
  83. 5: len 30; hex 24327924313024746632474f797879446a615477447753546b504a326550; asc $2y$10$tf2GOyxyDjaTwDwSTkPJ2eP; (total 60 bytes);
  84. 6: len 30; hex 383866316262396135383032386464356163356432346636326561343631; asc 88f1bb9a58028dd5ac5d24f62ea461; (total 64 bytes);
  85. 7: len 2; hex 7669; asc vi;;
  86. 8: len 7; hex 566965746e616d; asc Vietnam;;
  87. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  88. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  89. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  90. 12: len 4; hex 00000001; asc ;;
  91. 13: len 4; hex 36363639; asc 6669;;
  92. 14: len 4; hex 626c7565; asc blue;;
  93. 15: SQL NULL;
  94. 16: SQL NULL;
  95. 17: len 4; hex 7fff88f5; asc ;;
  96. 18: len 1; hex 80; asc ;;
  97. 19: len 1; hex 80; asc ;;
  98. 20: SQL NULL;
  99. 21: len 1; hex 80; asc ;;
  100. 22: SQL NULL;
  101. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  102. 24: len 1; hex 80; asc ;;
  103. 25: SQL NULL;
  104. 26: SQL NULL;
  105. 27: len 1; hex 81; asc ;;
  106. 28: len 1; hex 80; asc ;;
  107. 29: len 1; hex 81; asc ;;
  108. 30: len 4; hex 75736572; asc user;;
  109. 31: len 4; hex 00000005; asc ;;
  110. 32: len 4; hex 000006a4; asc ;;
  111. 33: len 4; hex 00000001; asc ;;
  112. 34: len 4; hex 596a336f; asc Yj3o;;
  113. 35: len 4; hex 598b3191; asc Y 1 ;;
  114.  
  115. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  116. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210332 lock_mode X locks rec but not gap waiting
  117. Record lock, heap no 44 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  118. 0: len 4; hex 0000001f; asc ;;
  119. 1: len 6; hex 000000210f2a; asc ! *;;
  120. 2: len 7; hex 74000003b2234f; asc t #O;;
  121. 3: len 7; hex 6d6e6f626c6f67; asc mnoblog;;
  122. 4: len 19; hex 616272616d736f6e7040676d61696c2e636f6d; asc abramsonp@gmail.com;;
  123. 5: len 30; hex 243279243130246a3661764831554e645072327a68344974673131622e64; asc $2y$10$j6avH1UNdPr2zh4Itg11b.d; (total 60 bytes);
  124. 6: len 30; hex 653833383735663266366233386132643938363466666166333431666537; asc e83875f2f6b38a2d9864ffaf341fe7; (total 64 bytes);
  125. 7: len 2; hex 656e; asc en;;
  126. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  127. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  128. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  129. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  130. 12: len 4; hex 00000002; asc ;;
  131. 13: len 4; hex 33303031; asc 3001;;
  132. 14: len 5; hex 677265656e; asc green;;
  133. 15: SQL NULL;
  134. 16: SQL NULL;
  135. 17: len 4; hex 8007b03c; asc <;;
  136. 18: len 1; hex 80; asc ;;
  137. 19: len 1; hex 80; asc ;;
  138. 20: SQL NULL;
  139. 21: len 1; hex 80; asc ;;
  140. 22: SQL NULL;
  141. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  142. 24: len 1; hex 80; asc ;;
  143. 25: SQL NULL;
  144. 26: SQL NULL;
  145. 27: len 1; hex 81; asc ;;
  146. 28: len 1; hex 80; asc ;;
  147. 29: len 1; hex 80; asc ;;
  148. 30: len 4; hex 75736572; asc user;;
  149. 31: len 4; hex 00000005; asc ;;
  150. 32: len 4; hex 0000000f; asc ;;
  151. 33: len 4; hex 00000001; asc ;;
  152. 34: len 4; hex 5957b1c3; asc YW ;;
  153. 35: len 4; hex 598b3191; asc Y 1 ;;
  154.  
  155. *** WE ROLL BACK TRANSACTION (2)
  156. ------------
  157. TRANSACTIONS
  158. ------------
  159. Trx id counter 2210774
  160. Purge done for trx's n:o < 2210625 undo n:o < 0 state: running
  161. History list length 16
  162. LIST OF TRANSACTIONS FOR EACH SESSION:
  163. ---TRANSACTION 421395664371992, not started
  164. 0 lock struct(s), heap size 1136, 0 row lock(s)
  165. ---TRANSACTION 421395664367512, not started
  166. 0 lock struct(s), heap size 1136, 0 row lock(s)
  167. ---TRANSACTION 421395664365720, not started
  168. 0 lock struct(s), heap size 1136, 0 row lock(s)
  169. ---TRANSACTION 421395664361240, not started
  170. 0 lock struct(s), heap size 1136, 0 row lock(s)
  171. ---TRANSACTION 2210769, ACTIVE 19 sec starting index read
  172. mysql tables in use 17, locked 17
  173. LOCK WAIT 3 lock struct(s), heap size 1136, 5 row lock(s)
  174. MySQL thread id 124785, OS thread handle 0x7f3970379700, query id 2776706 localhost site1 updating
  175. update `users` set `duplicate_browser_id` = 1, `updated_at` = '2017-08-10 08:09:16' where `id` in (2, 5, 13, 19, 31, 48, 49, 53, 54, 57, 61, 63, 64, 65, 72, 89, 94, 106, 107, 113, 115, 116, 127, 158, 163, 166, 173, 174, 175, 176, 177, 180, 185, 200, 202, 212, 213, 219, 251, 260, 262, 275, 292, 294, 296, 300, 310, 322, 327, 328, 344, 346, 348, 353, 355, 368, 374, 381, 385, 393, 395, 397, 402, 409, 431, 432, 437, 439, 441, 450, 453, 464, 470, 471, 474, 483, 491, 494, 501, 503, 508, 509, 512, 513, 514, 515, 520, 530, 535, 536, 549, 551, 563, 565, 568, 584, 587, 594, 600, 608, 614, 617, 620, 622,
  176. Trx read view will not see trx with id >= 2210769, sees < 2210600
  177. ------- TRX HAS BEEN WAITING 18 SEC FOR THIS LOCK TO BE GRANTED:
  178. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210769 lock_mode X locks rec but not gap waiting
  179. Record lock, heap no 44 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  180. 0: len 4; hex 0000001f; asc ;;
  181. 1: len 6; hex 000000210f2a; asc ! *;;
  182. 2: len 7; hex 74000003b2234f; asc t #O;;
  183. 3: len 7; hex 6d6e6f626c6f67; asc mnoblog;;
  184. 4: len 19; hex 616272616d736f6e7040676d61696c2e636f6d; asc abramsonp@gmail.com;;
  185. 5: len 30; hex 243279243130246a3661764831554e645072327a68344974673131622e64; asc $2y$10$j6avH1UNdPr2zh4Itg11b.d; (total 60 bytes);
  186. 6: len 30; hex 653833383735663266366233386132643938363466666166333431666537; asc e83875f2f6b38a2d9864ffaf341fe7; (total 64 bytes);
  187. 7: len 2; hex 656e; asc en;;
  188. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  189. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  190. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  191. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  192. 12: len 4; hex 00000002; asc ;;
  193. 13: len 4; hex 33303031; asc 3001;;
  194. 14: len 5; hex 677265656e; asc green;;
  195. 15: SQL NULL;
  196. 16: SQL NULL;
  197. 17: len 4; hex 8007b03c; asc <;;
  198. 18: len 1; hex 80; asc ;;
  199. 19: len 1; hex 80; asc ;;
  200. 20: SQL NULL;
  201. 21: len 1; hex 80; asc ;;
  202. 22: SQL NULL;
  203. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  204. 24: len 1; hex 80; asc ;;
  205. 25: SQL NULL;
  206. 26: SQL NULL;
  207. 27: len 1; hex 81; asc ;;
  208. 28: len 1; hex 80; asc ;;
  209. 29: len 1; hex 80; asc ;;
  210. 30: len 4; hex 75736572; asc user;;
  211. 31: len 4; hex 00000005; asc ;;
  212. 32: len 4; hex 0000000f; asc ;;
  213. 33: len 4; hex 00000001; asc ;;
  214. 34: len 4; hex 5957b1c3; asc YW ;;
  215. 35: len 4; hex 598b3191; asc Y 1 ;;
  216.  
  217. ------------------
  218. ---TRANSACTION 2210764, ACTIVE 23 sec starting index read
  219. mysql tables in use 17, locked 17
  220. LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
  221. MySQL thread id 124777, OS thread handle 0x7f397033c700, query id 2776525 localhost site1 updating
  222. update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 08:09:12' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700,
  223. Trx read view will not see trx with id >= 2210764, sees < 2210600
  224. ------- TRX HAS BEEN WAITING 22 SEC FOR THIS LOCK TO BE GRANTED:
  225. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210764 lock_mode X locks rec but not gap waiting
  226. Record lock, heap no 44 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  227. 0: len 4; hex 0000001f; asc ;;
  228. 1: len 6; hex 000000210f2a; asc ! *;;
  229. 2: len 7; hex 74000003b2234f; asc t #O;;
  230. 3: len 7; hex 6d6e6f626c6f67; asc mnoblog;;
  231. 4: len 19; hex 616272616d736f6e7040676d61696c2e636f6d; asc abramsonp@gmail.com;;
  232. 5: len 30; hex 243279243130246a3661764831554e645072327a68344974673131622e64; asc $2y$10$j6avH1UNdPr2zh4Itg11b.d; (total 60 bytes);
  233. 6: len 30; hex 653833383735663266366233386132643938363466666166333431666537; asc e83875f2f6b38a2d9864ffaf341fe7; (total 64 bytes);
  234. 7: len 2; hex 656e; asc en;;
  235. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  236. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  237. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  238. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  239. 12: len 4; hex 00000002; asc ;;
  240. 13: len 4; hex 33303031; asc 3001;;
  241. 14: len 5; hex 677265656e; asc green;;
  242. 15: SQL NULL;
  243. 16: SQL NULL;
  244. 17: len 4; hex 8007b03c; asc <;;
  245. 18: len 1; hex 80; asc ;;
  246. 19: len 1; hex 80; asc ;;
  247. 20: SQL NULL;
  248. 21: len 1; hex 80; asc ;;
  249. 22: SQL NULL;
  250. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  251. 24: len 1; hex 80; asc ;;
  252. 25: SQL NULL;
  253. 26: SQL NULL;
  254. 27: len 1; hex 81; asc ;;
  255. 28: len 1; hex 80; asc ;;
  256. 29: len 1; hex 80; asc ;;
  257. 30: len 4; hex 75736572; asc user;;
  258. 31: len 4; hex 00000005; asc ;;
  259. 32: len 4; hex 0000000f; asc ;;
  260. 33: len 4; hex 00000001; asc ;;
  261. 34: len 4; hex 5957b1c3; asc YW ;;
  262. 35: len 4; hex 598b3191; asc Y 1 ;;
  263.  
  264. ------------------
  265. ---TRANSACTION 2210757, ACTIVE 24 sec starting index read
  266. mysql tables in use 17, locked 17
  267. LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
  268. MySQL thread id 124771, OS thread handle 0x7f39703b6700, query id 2776335 localhost site1 updating
  269. update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 08:09:10' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700,
  270. Trx read view will not see trx with id >= 2210757, sees < 2210600
  271. ------- TRX HAS BEEN WAITING 24 SEC FOR THIS LOCK TO BE GRANTED:
  272. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210757 lock_mode X locks rec but not gap waiting
  273. Record lock, heap no 44 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  274. 0: len 4; hex 0000001f; asc ;;
  275. 1: len 6; hex 000000210f2a; asc ! *;;
  276. 2: len 7; hex 74000003b2234f; asc t #O;;
  277. 3: len 7; hex 6d6e6f626c6f67; asc mnoblog;;
  278. 4: len 19; hex 616272616d736f6e7040676d61696c2e636f6d; asc abramsonp@gmail.com;;
  279. 5: len 30; hex 243279243130246a3661764831554e645072327a68344974673131622e64; asc $2y$10$j6avH1UNdPr2zh4Itg11b.d; (total 60 bytes);
  280. 6: len 30; hex 653833383735663266366233386132643938363466666166333431666537; asc e83875f2f6b38a2d9864ffaf341fe7; (total 64 bytes);
  281. 7: len 2; hex 656e; asc en;;
  282. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  283. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  284. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  285. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  286. 12: len 4; hex 00000002; asc ;;
  287. 13: len 4; hex 33303031; asc 3001;;
  288. 14: len 5; hex 677265656e; asc green;;
  289. 15: SQL NULL;
  290. 16: SQL NULL;
  291. 17: len 4; hex 8007b03c; asc <;;
  292. 18: len 1; hex 80; asc ;;
  293. 19: len 1; hex 80; asc ;;
  294. 20: SQL NULL;
  295. 21: len 1; hex 80; asc ;;
  296. 22: SQL NULL;
  297. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  298. 24: len 1; hex 80; asc ;;
  299. 25: SQL NULL;
  300. 26: SQL NULL;
  301. 27: len 1; hex 81; asc ;;
  302. 28: len 1; hex 80; asc ;;
  303. 29: len 1; hex 80; asc ;;
  304. 30: len 4; hex 75736572; asc user;;
  305. 31: len 4; hex 00000005; asc ;;
  306. 32: len 4; hex 0000000f; asc ;;
  307. 33: len 4; hex 00000001; asc ;;
  308. 34: len 4; hex 5957b1c3; asc YW ;;
  309. 35: len 4; hex 598b3191; asc Y 1 ;;
  310.  
  311. ------------------
  312. ---TRANSACTION 2210750, ACTIVE 33 sec fetching rows
  313. mysql tables in use 6, locked 6
  314. LOCK WAIT 717 lock struct(s), heap size 90320, 89094 row lock(s)
  315. MySQL thread id 124759, OS thread handle 0x7f3970524700, query id 2776009 localhost site1 updating
  316. update `payments` set `deleted_at` = '2017-08-10 08:09:01', `updated_at` = '2017-08-10 08:09:01' where `type` = 'deposit' and `status` = 'pending' and `is_fake` = 0 and `batch_num` is null and `updated_at` <= '2017-08-09 08:09:01' and `payments`.`deleted_at` is null
  317. ------- TRX HAS BEEN WAITING 33 SEC FOR THIS LOCK TO BE GRANTED:
  318. RECORD LOCKS space id 383 page no 824 n bits 920 index payments_status_index of table `site1`.`payments` trx id 2210750 lock_mode X waiting
  319. Record lock, heap no 801 PHYSICAL RECORD: n_fields 2; compact format; info bits 32
  320. 0: len 7; hex 70656e64696e67; asc pending;;
  321. 1: len 4; hex 00008f8d; asc ;;
  322.  
  323. ------------------
  324. ---TRANSACTION 2210739, ACTIVE 43 sec starting index read
  325. mysql tables in use 17, locked 17
  326. LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
  327. MySQL thread id 124739, OS thread handle 0x7f39702ff700, query id 2775405 localhost site1 updating
  328. update `users` set `duplicate_browser_id` = 2, `updated_at` = '2017-08-10 08:08:51' where `id` in (52, 89, 138, 167, 284, 390, 426, 558, 561, 612, 665, 749, 818, 918, 1164, 1326, 1433, 1476, 1596, 1665, 1778, 1895, 2013, 2035, 2045, 2073, 2442, 2501, 2564, 2657, 2701, 2754, 2916, 3076, 3482, 3585, 3587, 3725, 3750, 3918, 4045, 4455) and `duplicate_browser_id` is null
  329. Trx read view will not see trx with id >= 2210739, sees < 2210600
  330. ------- TRX HAS BEEN WAITING 43 SEC FOR THIS LOCK TO BE GRANTED:
  331. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210739 lock_mode X locks rec but not gap waiting
  332. Record lock, heap no 29 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  333. 0: len 4; hex 00000034; asc 4;;
  334. 1: len 6; hex 000000210f2a; asc ! *;;
  335. 2: len 7; hex 74000003af0116; asc t ;;
  336. 3: len 8; hex 67756c697665724f; asc guliverO;;
  337. 4: len 25; hex 6a757374776f726b31374070726f746f6e6d61696c2e636f6d; asc justwork17@protonmail.com;;
  338. 5: len 30; hex 243279243130246d735346746947694d4c6f7a527141783930312e672e67; asc $2y$10$msSFtiGiMLozRqAx901.g.g; (total 60 bytes);
  339. 6: len 30; hex 626633636266353861643037326537386230653839356239376466646165; asc bf3cbf58ad072e78b0e895b97dfdae; (total 64 bytes);
  340. 7: len 2; hex 656e; asc en;;
  341. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  342. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  343. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  344. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  345. 12: len 4; hex 00000001; asc ;;
  346. 13: len 4; hex 34323334; asc 4234;;
  347. 14: len 6; hex 79656c6c6f77; asc yellow;;
  348. 15: SQL NULL;
  349. 16: SQL NULL;
  350. 17: len 4; hex 80000b0a; asc ;;
  351. 18: len 1; hex 80; asc ;;
  352. 19: len 1; hex 80; asc ;;
  353. 20: SQL NULL;
  354. 21: len 1; hex 80; asc ;;
  355. 22: SQL NULL;
  356. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  357. 24: len 1; hex 81; asc ;;
  358. 25: len 5; hex 999d54e014; asc T ;;
  359. 26: len 30; hex 7b2264617973223a5b2234225d2c2274696d6573223a5b2231333a303022; asc {"days":["4"],"times":["13:00"; (total 159 bytes);
  360. 27: len 1; hex 80; asc ;;
  361. 28: len 1; hex 80; asc ;;
  362. 29: len 1; hex 81; asc ;;
  363. 30: len 4; hex 75736572; asc user;;
  364. 31: len 4; hex 00000005; asc ;;
  365. 32: len 4; hex 00000002; asc ;;
  366. 33: len 4; hex 00000002; asc ;;
  367. 34: len 4; hex 59582d2b; asc YX-+;;
  368. 35: len 4; hex 598b3191; asc Y 1 ;;
  369.  
  370. ------------------
  371. ---TRANSACTION 2210734, ACTIVE 50 sec starting index read
  372. mysql tables in use 17, locked 17
  373. LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
  374. MySQL thread id 124735, OS thread handle 0x7f3970117700, query id 2775316 localhost site1 updating
  375. update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 08:08:44' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700,
  376. Trx read view will not see trx with id >= 2210734, sees < 2210600
  377. ------- TRX HAS BEEN WAITING 50 SEC FOR THIS LOCK TO BE GRANTED:
  378. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210734 lock_mode X locks rec but not gap waiting
  379. Record lock, heap no 44 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  380. 0: len 4; hex 0000001f; asc ;;
  381. 1: len 6; hex 000000210f2a; asc ! *;;
  382. 2: len 7; hex 74000003b2234f; asc t #O;;
  383. 3: len 7; hex 6d6e6f626c6f67; asc mnoblog;;
  384. 4: len 19; hex 616272616d736f6e7040676d61696c2e636f6d; asc abramsonp@gmail.com;;
  385. 5: len 30; hex 243279243130246a3661764831554e645072327a68344974673131622e64; asc $2y$10$j6avH1UNdPr2zh4Itg11b.d; (total 60 bytes);
  386. 6: len 30; hex 653833383735663266366233386132643938363466666166333431666537; asc e83875f2f6b38a2d9864ffaf341fe7; (total 64 bytes);
  387. 7: len 2; hex 656e; asc en;;
  388. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  389. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  390. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  391. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  392. 12: len 4; hex 00000002; asc ;;
  393. 13: len 4; hex 33303031; asc 3001;;
  394. 14: len 5; hex 677265656e; asc green;;
  395. 15: SQL NULL;
  396. 16: SQL NULL;
  397. 17: len 4; hex 8007b03c; asc <;;
  398. 18: len 1; hex 80; asc ;;
  399. 19: len 1; hex 80; asc ;;
  400. 20: SQL NULL;
  401. 21: len 1; hex 80; asc ;;
  402. 22: SQL NULL;
  403. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  404. 24: len 1; hex 80; asc ;;
  405. 25: SQL NULL;
  406. 26: SQL NULL;
  407. 27: len 1; hex 81; asc ;;
  408. 28: len 1; hex 80; asc ;;
  409. 29: len 1; hex 80; asc ;;
  410. 30: len 4; hex 75736572; asc user;;
  411. 31: len 4; hex 00000005; asc ;;
  412. 32: len 4; hex 0000000f; asc ;;
  413. 33: len 4; hex 00000001; asc ;;
  414. 34: len 4; hex 5957b1c3; asc YW ;;
  415. 35: len 4; hex 598b3191; asc Y 1 ;;
  416.  
  417. ------------------
  418. ---TRANSACTION 2210729, ACTIVE 65 sec starting index read
  419. mysql tables in use 1, locked 1
  420. LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
  421. MySQL thread id 124715, OS thread handle 0x7f3969eca700, query id 2774638 localhost site1 statistics
  422. select * from `payments` where `order_id` = 'ORDER_aOkf1QOZ712b' and `status` = 'pending' and `payments`.`deleted_at` is null limit 1 for update
  423. ------- TRX HAS BEEN WAITING 65 SEC FOR THIS LOCK TO BE GRANTED:
  424. RECORD LOCKS space id 383 page no 596 n bits 552 index payments_order_id_unique of table `site1`.`payments` trx id 2210729 lock_mode X locks rec but not gap waiting
  425. Record lock, heap no 484 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  426. 0: len 18; hex 4f524445525f614f6b6631514f5a37313262; asc ORDER_aOkf1QOZ712b;;
  427. 1: len 4; hex 00008f8d; asc ;;
  428.  
  429. ------------------
  430. ---TRANSACTION 2210702, ACTIVE 101 sec starting index read
  431. mysql tables in use 17, locked 17
  432. LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
  433. MySQL thread id 124668, OS thread handle 0x7f3969f07700, query id 2772862 localhost site1 updating
  434. update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 08:07:53' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700,
  435. Trx read view will not see trx with id >= 2210702, sees < 2210600
  436. ------- TRX HAS BEEN WAITING 101 SEC FOR THIS LOCK TO BE GRANTED:
  437. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210702 lock_mode X locks rec but not gap waiting
  438. Record lock, heap no 44 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  439. 0: len 4; hex 0000001f; asc ;;
  440. 1: len 6; hex 000000210f2a; asc ! *;;
  441. 2: len 7; hex 74000003b2234f; asc t #O;;
  442. 3: len 7; hex 6d6e6f626c6f67; asc mnoblog;;
  443. 4: len 19; hex 616272616d736f6e7040676d61696c2e636f6d; asc abramsonp@gmail.com;;
  444. 5: len 30; hex 243279243130246a3661764831554e645072327a68344974673131622e64; asc $2y$10$j6avH1UNdPr2zh4Itg11b.d; (total 60 bytes);
  445. 6: len 30; hex 653833383735663266366233386132643938363466666166333431666537; asc e83875f2f6b38a2d9864ffaf341fe7; (total 64 bytes);
  446. 7: len 2; hex 656e; asc en;;
  447. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  448. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  449. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  450. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  451. 12: len 4; hex 00000002; asc ;;
  452. 13: len 4; hex 33303031; asc 3001;;
  453. 14: len 5; hex 677265656e; asc green;;
  454. 15: SQL NULL;
  455. 16: SQL NULL;
  456. 17: len 4; hex 8007b03c; asc <;;
  457. 18: len 1; hex 80; asc ;;
  458. 19: len 1; hex 80; asc ;;
  459. 20: SQL NULL;
  460. 21: len 1; hex 80; asc ;;
  461. 22: SQL NULL;
  462. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  463. 24: len 1; hex 80; asc ;;
  464. 25: SQL NULL;
  465. 26: SQL NULL;
  466. 27: len 1; hex 81; asc ;;
  467. 28: len 1; hex 80; asc ;;
  468. 29: len 1; hex 80; asc ;;
  469. 30: len 4; hex 75736572; asc user;;
  470. 31: len 4; hex 00000005; asc ;;
  471. 32: len 4; hex 0000000f; asc ;;
  472. 33: len 4; hex 00000001; asc ;;
  473. 34: len 4; hex 5957b1c3; asc YW ;;
  474. 35: len 4; hex 598b3191; asc Y 1 ;;
  475.  
  476. ------------------
  477. ---TRANSACTION 2210697, ACTIVE 101 sec starting index read
  478. mysql tables in use 17, locked 17
  479. LOCK WAIT 2 lock struct(s), heap size 1136, 1 row lock(s)
  480. MySQL thread id 124666, OS thread handle 0x7f41e006d700, query id 2772798 localhost site1 updating
  481. update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 08:07:53' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700,
  482. Trx read view will not see trx with id >= 2210697, sees < 2210600
  483. ------- TRX HAS BEEN WAITING 101 SEC FOR THIS LOCK TO BE GRANTED:
  484. RECORD LOCKS space id 393 page no 22 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210697 lock_mode X locks rec but not gap waiting
  485. Record lock, heap no 44 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  486. 0: len 4; hex 0000001f; asc ;;
  487. 1: len 6; hex 000000210f2a; asc ! *;;
  488. 2: len 7; hex 74000003b2234f; asc t #O;;
  489. 3: len 7; hex 6d6e6f626c6f67; asc mnoblog;;
  490. 4: len 19; hex 616272616d736f6e7040676d61696c2e636f6d; asc abramsonp@gmail.com;;
  491. 5: len 30; hex 243279243130246a3661764831554e645072327a68344974673131622e64; asc $2y$10$j6avH1UNdPr2zh4Itg11b.d; (total 60 bytes);
  492. 6: len 30; hex 653833383735663266366233386132643938363466666166333431666537; asc e83875f2f6b38a2d9864ffaf341fe7; (total 64 bytes);
  493. 7: len 2; hex 656e; asc en;;
  494. 8: len 14; hex 556e69746564204b696e67646f6d; asc United Kingdom;;
  495. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  496. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  497. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  498. 12: len 4; hex 00000002; asc ;;
  499. 13: len 4; hex 33303031; asc 3001;;
  500. 14: len 5; hex 677265656e; asc green;;
  501. 15: SQL NULL;
  502. 16: SQL NULL;
  503. 17: len 4; hex 8007b03c; asc <;;
  504. 18: len 1; hex 80; asc ;;
  505. 19: len 1; hex 80; asc ;;
  506. 20: SQL NULL;
  507. 21: len 1; hex 80; asc ;;
  508. 22: SQL NULL;
  509. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  510. 24: len 1; hex 80; asc ;;
  511. 25: SQL NULL;
  512. 26: SQL NULL;
  513. 27: len 1; hex 81; asc ;;
  514. 28: len 1; hex 80; asc ;;
  515. 29: len 1; hex 80; asc ;;
  516. 30: len 4; hex 75736572; asc user;;
  517. 31: len 4; hex 00000005; asc ;;
  518. 32: len 4; hex 0000000f; asc ;;
  519. 33: len 4; hex 00000001; asc ;;
  520. 34: len 4; hex 5957b1c3; asc YW ;;
  521. 35: len 4; hex 598b3191; asc Y 1 ;;
  522.  
  523. ------------------
  524. ---TRANSACTION 2210675, ACTIVE 148 sec starting index read
  525. mysql tables in use 1, locked 1
  526. LOCK WAIT 3 lock struct(s), heap size 1136, 2 row lock(s)
  527. MySQL thread id 124511, OS thread handle 0x7f3969e8d700, query id 2768054 localhost site1 statistics
  528. select * from `payments` where `order_id` = 'ORDER_aOkf1QOZ712b' and `status` = 'pending' and `payments`.`deleted_at` is null limit 1 for update
  529. ------- TRX HAS BEEN WAITING 93 SEC FOR THIS LOCK TO BE GRANTED:
  530. RECORD LOCKS space id 383 page no 1253 n bits 104 index PRIMARY of table `site1`.`payments` trx id 2210675 lock_mode X locks rec but not gap waiting
  531. Record lock, heap no 34 PHYSICAL RECORD: n_fields 22; compact format; info bits 0
  532. 0: len 4; hex 00008f8d; asc ;;
  533. 1: len 6; hex 00000021bb28; asc ! (;;
  534. 2: len 7; hex 6f0000020c2d92; asc o - ;;
  535. 3: len 4; hex 00001041; asc A;;
  536. 4: len 18; hex 4f524445525f614f6b6631514f5a37313262; asc ORDER_aOkf1QOZ712b;;
  537. 5: len 4; hex 00000005; asc ;;
  538. 6: len 30; hex 32653866356163342d393661352d346265612d626333312d383664326139; asc 2e8f5ac4-96a5-4bea-bc31-86d2a9; (total 36 bytes);
  539. 7: len 13; hex 616476616e6365645f63617368; asc advanced_cash;;
  540. 8: len 29; hex 8000000000000000000000000000000000000000000000000a00000000; asc ;;
  541. 9: len 29; hex 8000000000000000000000000000000000000000000000000000047e40; asc ~@;;
  542. 10: len 13; hex 55313037353037383835383038; asc U107507885808;;
  543. 11: SQL NULL;
  544. 12: SQL NULL;
  545. 13: len 1; hex 01; asc ;;
  546. 14: SQL NULL;
  547. 15: len 6; hex 616374697665; asc active;;
  548. 16: len 1; hex 80; asc ;;
  549. 17: SQL NULL;
  550. 18: SQL NULL;
  551. 19: len 4; hex 598c4bc0; asc Y K ;;
  552. 20: len 4; hex 598c4c02; asc Y L ;;
  553. 21: SQL NULL;
  554.  
  555. ------------------
  556. ---TRANSACTION 2210649, ACTIVE 177 sec starting index read
  557. mysql tables in use 17, locked 17
  558. LOCK WAIT 39 lock struct(s), heap size 3520, 92 row lock(s)
  559. MySQL thread id 124395, OS thread handle 0x7f3969fbe700, query id 2764380 localhost site1 updating
  560. update `users` set `duplicate_browser_id` = 13, `updated_at` = '2017-08-10 08:06:37' where `id` in (31, 52, 63, 64, 94, 113, 115, 116, 174, 180, 213, 219, 260, 262, 275, 294, 300, 327, 328, 353, 381, 393, 395, 464, 470, 474, 513, 514, 549, 584, 587, 594, 614, 617, 639, 658, 667, 709, 712, 739, 748, 750, 760, 766, 797, 873, 889, 898, 912, 927, 954, 998, 1021, 1038, 1043, 1060, 1067, 1096, 1108, 1109, 1131, 1135, 1150, 1164, 1172, 1181, 1207, 1213, 1254, 1287, 1320, 1326, 1343, 1351, 1378, 1391, 1394, 1446, 1483, 1494, 1519, 1544, 1551, 1553, 1554, 1578, 1594, 1609, 1624, 1647, 1653, 1656, 1700,
  561. Trx read view will not see trx with id >= 2210649, sees < 2210583
  562. ------- TRX HAS BEEN WAITING 69 SEC FOR THIS LOCK TO BE GRANTED:
  563. RECORD LOCKS space id 393 page no 136 n bits 112 index PRIMARY of table `site1`.`users` trx id 2210649 lock_mode X locks rec but not gap waiting
  564. Record lock, heap no 9 PHYSICAL RECORD: n_fields 36; compact format; info bits 0
  565. 0: len 4; hex 00000678; asc x;;
  566. 1: len 6; hex 000000210f2a; asc ! *;;
  567. 2: len 7; hex 74000003a30957; asc t W;;
  568. 3: len 8; hex 696e666f73697465; asc infosite;;
  569. 4: len 22; hex 696e666f736974653230313640676d61696c2e636f6d; asc infosite2016@gmail.com;;
  570. 5: len 30; hex 2432792431302444364f45526358366d554662594871627754316b497556; asc $2y$10$D6OERcX6mUFbYHqbwT1kIuV; (total 60 bytes);
  571. 6: len 30; hex 396630373563333531326238343462613066393935313066666230616630; asc 9f075c3512b844ba0f99510ffb0af0; (total 64 bytes);
  572. 7: len 2; hex 7275; asc ru;;
  573. 8: len 6; hex 527573736961; asc Russia;;
  574. 9: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  575. 10: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  576. 11: len 29; hex 8000000000000000000000000000000000000000000000000000000000; asc ;;
  577. 12: len 4; hex 00000001; asc ;;
  578. 13: len 4; hex 31393839; asc 1989;;
  579. 14: len 5; hex 626c61636b; asc black;;
  580. 15: SQL NULL;
  581. 16: SQL NULL;
  582. 17: len 4; hex 80008a00; asc ;;
  583. 18: len 1; hex 80; asc ;;
  584. 19: len 1; hex 80; asc ;;
  585. 20: SQL NULL;
  586. 21: len 1; hex 80; asc ;;
  587. 22: SQL NULL;
  588. 23: len 30; hex 7b2230223a2231343430222c22313535223a2232313630222c2231353539; asc {"0":"1440","155":"2160","1559; (total 39 bytes);
  589. 24: len 1; hex 80; asc ;;
  590. 25: SQL NULL;
  591. 26: SQL NULL;
  592. 27: len 1; hex 81; asc ;;
  593. 28: len 1; hex 80; asc ;;
  594. 29: len 1; hex 80; asc ;;
  595. 30: len 4; hex 75736572; asc user;;
  596. 31: SQL NULL;
  597. 32: SQL NULL;
  598. 33: len 4; hex 00000001; asc ;;
  599. 34: len 4; hex 59694f2d; asc YiO-;;
  600. 35: len 4; hex 598b3190; asc Y 1 ;;
  601.  
  602. ------------------
  603. ---TRANSACTION 2210600, ACTIVE 252 sec
  604. 27 lock struct(s), heap size 3520, 22 row lock(s), undo log entries 13
  605. MySQL thread id 124191, OS thread handle 0x7f41d00f1700, query id 2771589 localhost site1 cleaning up
  606. Trx read view will not see trx with id >= 2210601, sees < 2210583
  607. --------
  608. FILE I/O
  609. --------
  610. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  611. I/O thread 1 state: waiting for completed aio requests (log thread)
  612. I/O thread 2 state: waiting for completed aio requests (read thread)
  613. I/O thread 3 state: waiting for completed aio requests (read thread)
  614. I/O thread 4 state: waiting for completed aio requests (read thread)
  615. I/O thread 5 state: waiting for completed aio requests (read thread)
  616. I/O thread 6 state: waiting for completed aio requests (read thread)
  617. I/O thread 7 state: waiting for completed aio requests (read thread)
  618. I/O thread 8 state: waiting for completed aio requests (read thread)
  619. I/O thread 9 state: waiting for completed aio requests (read thread)
  620. I/O thread 10 state: waiting for completed aio requests (write thread)
  621. I/O thread 11 state: waiting for completed aio requests (write thread)
  622. I/O thread 12 state: waiting for completed aio requests (write thread)
  623. I/O thread 13 state: waiting for completed aio requests (write thread)
  624. I/O thread 14 state: waiting for completed aio requests (write thread)
  625. I/O thread 15 state: waiting for completed aio requests (write thread)
  626. I/O thread 16 state: waiting for completed aio requests (write thread)
  627. I/O thread 17 state: waiting for completed aio requests (write thread)
  628. Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] ,
  629. ibuf aio reads:, log i/o's:, sync i/o's:
  630. Pending flushes (fsync) log: 0; buffer pool: 0
  631. 12554 OS file reads, 134353 OS file writes, 100203 OS fsyncs
  632. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  633. -------------------------------------
  634. INSERT BUFFER AND ADAPTIVE HASH INDEX
  635. -------------------------------------
  636. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  637. merged operations:
  638. insert 0, delete mark 0, delete 0
  639. discarded operations:
  640. insert 0, delete mark 0, delete 0
  641. Hash table size 9461581, node heap has 1 buffer(s)
  642. Hash table size 9461581, node heap has 8 buffer(s)
  643. Hash table size 9461581, node heap has 117 buffer(s)
  644. Hash table size 9461581, node heap has 105 buffer(s)
  645. Hash table size 9461581, node heap has 49 buffer(s)
  646. Hash table size 9461581, node heap has 9 buffer(s)
  647. Hash table size 9461581, node heap has 18 buffer(s)
  648. Hash table size 9461581, node heap has 23 buffer(s)
  649. 31.39 hash searches/s, 38.99 non-hash searches/s
  650. ---
  651. LOG
  652. ---
  653. Log sequence number 890064175
  654. Log flushed up to 890064175
  655. Pages flushed up to 890064175
  656. Last checkpoint at 890064166
  657. 0 pending log flushes, 0 pending chkp writes
  658. 30320 log i/o's done, 0.00 log i/o's/second
  659. ----------------------
  660. BUFFER POOL AND MEMORY
  661. ----------------------
  662. Total large memory allocated 35215376384
  663. Dictionary memory allocated 368530
  664. Buffer pool size 2097120
  665. Free buffers 2084002
  666. Database pages 12783
  667. Old database pages 4782
  668. Modified db pages 0
  669. Percent of dirty pages(LRU & free pages): 0.000
  670. Max dirty pages percent: 90.000
  671. Pending reads 0
  672. Pending writes: LRU 0, flush list 0, single page 0
  673. Pages made young 33, not young 0
  674. 0.00 youngs/s, 0.00 non-youngs/s
  675. Pages read 12489, created 294, written 74875
  676. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  677. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  678. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  679. LRU len: 12783, unzip_LRU len: 0
  680. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  681. ----------------------
  682. INDIVIDUAL BUFFER POOL INFO
  683. ----------------------
  684. ---BUFFER POOL 0
  685. Buffer pool size 262144
  686. Free buffers 260438
  687. Database pages 1658
  688. Old database pages 599
  689. Modified db pages 0
  690. Percent of dirty pages(LRU & free pages): 0.000
  691. Max dirty pages percent: 90.000
  692. Pending reads 0
  693. Pending writes: LRU 0, flush list 0, single page 0
  694. Pages made young 13, not young 0
  695. 0.00 youngs/s, 0.00 non-youngs/s
  696. Pages read 1601, created 57, written 12445
  697. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  698. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  699. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  700. LRU len: 1658, unzip_LRU len: 0
  701. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  702. ---BUFFER POOL 1
  703. Buffer pool size 262144
  704. Free buffers 260519
  705. Database pages 1581
  706. Old database pages 594
  707. Modified db pages 0
  708. Percent of dirty pages(LRU & free pages): 0.000
  709. Max dirty pages percent: 90.000
  710. Pending reads 0
  711. Pending writes: LRU 0, flush list 0, single page 0
  712. Pages made young 4, not young 0
  713. 0.00 youngs/s, 0.00 non-youngs/s
  714. Pages read 1567, created 14, written 7697
  715. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  716. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  717. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  718. LRU len: 1581, unzip_LRU len: 0
  719. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  720. ---BUFFER POOL 2
  721. Buffer pool size 262144
  722. Free buffers 260549
  723. Database pages 1552
  724. Old database pages 570
  725. Modified db pages 0
  726. Percent of dirty pages(LRU & free pages): 0.000
  727. Max dirty pages percent: 90.000
  728. Pending reads 0
  729. Pending writes: LRU 0, flush list 0, single page 0
  730. Pages made young 3, not young 0
  731. 0.00 youngs/s, 0.00 non-youngs/s
  732. Pages read 1500, created 52, written 9906
  733. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  734. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  735. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  736. LRU len: 1552, unzip_LRU len: 0
  737. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  738. ---BUFFER POOL 3
  739. Buffer pool size 262144
  740. Free buffers 260572
  741. Database pages 1529
  742. Old database pages 569
  743. Modified db pages 0
  744. Percent of dirty pages(LRU & free pages): 0.000
  745. Max dirty pages percent: 90.000
  746. Pending reads 0
  747. Pending writes: LRU 0, flush list 0, single page 0
  748. Pages made young 5, not young 0
  749. 0.00 youngs/s, 0.00 non-youngs/s
  750. Pages read 1501, created 28, written 13958
  751. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  752. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  753. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  754. LRU len: 1529, unzip_LRU len: 0
  755. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  756. ---BUFFER POOL 4
  757. Buffer pool size 262144
  758. Free buffers 260594
  759. Database pages 1508
  760. Old database pages 572
  761. Modified db pages 0
  762. Percent of dirty pages(LRU & free pages): 0.000
  763. Max dirty pages percent: 90.000
  764. Pending reads 0
  765. Pending writes: LRU 0, flush list 0, single page 0
  766. Pages made young 2, not young 0
  767. 0.00 youngs/s, 0.00 non-youngs/s
  768. Pages read 1503, created 5, written 6286
  769. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  770. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  771. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  772. LRU len: 1508, unzip_LRU len: 0
  773. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  774. ---BUFFER POOL 5
  775. Buffer pool size 262144
  776. Free buffers 260693
  777. Database pages 1412
  778. Old database pages 536
  779. Modified db pages 0
  780. Percent of dirty pages(LRU & free pages): 0.000
  781. Max dirty pages percent: 90.000
  782. Pending reads 0
  783. Pending writes: LRU 0, flush list 0, single page 0
  784. Pages made young 3, not young 0
  785. 0.00 youngs/s, 0.00 non-youngs/s
  786. Pages read 1407, created 5, written 7796
  787. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  788. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  789. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  790. LRU len: 1412, unzip_LRU len: 0
  791. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  792. ---BUFFER POOL 6
  793. Buffer pool size 262112
  794. Free buffers 260358
  795. Database pages 1717
  796. Old database pages 649
  797. Modified db pages 0
  798. Percent of dirty pages(LRU & free pages): 0.000
  799. Max dirty pages percent: 90.000
  800. Pending reads 0
  801. Pending writes: LRU 0, flush list 0, single page 0
  802. Pages made young 3, not young 0
  803. 0.00 youngs/s, 0.00 non-youngs/s
  804. Pages read 1650, created 67, written 8865
  805. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  806. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  807. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  808. LRU len: 1717, unzip_LRU len: 0
  809. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  810. ---BUFFER POOL 7
  811. Buffer pool size 262144
  812. Free buffers 260279
  813. Database pages 1826
  814. Old database pages 693
  815. Modified db pages 0
  816. Percent of dirty pages(LRU & free pages): 0.000
  817. Max dirty pages percent: 90.000
  818. Pending reads 0
  819. Pending writes: LRU 0, flush list 0, single page 0
  820. Pages made young 0, not young 0
  821. 0.00 youngs/s, 0.00 non-youngs/s
  822. Pages read 1760, created 66, written 7922
  823. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  824. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  825. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  826. LRU len: 1826, unzip_LRU len: 0
  827. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  828. --------------
  829. ROW OPERATIONS
  830. --------------
  831. 0 queries inside InnoDB, 0 queries in queue
  832. 9 read views open inside InnoDB
  833. Process ID=23168, Main thread ID=139884707874560, state: sleeping
  834. Number of rows inserted 9885, updated 14096, deleted 1, read 347516359
  835. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 28.79 reads/s
  836. Number of system rows inserted 0, updated 0, deleted 0, read 0
  837. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  838. ----------------------------
  839. END OF INNODB MONITOR OUTPUT
  840. ============================
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!