API tools faq
paste
Advertisement
matrox445

show_engine_innodb_status

matrox445
Mar 2nd, 2022 (edited)
121
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 44.53 KB | None | 0 0
raw download clone embed print report
  1. -------------------------------------------------------------------------
  2. SHOW ENGINE INNODB STATUS
  3. *************************** 1. row ***************************
  4. Type: InnoDB
  5. Name:
  6. Status:
  7. =====================================
  8. 2022-03-03 14:05:56 0x7f96fccbf700 INNODB MONITOR OUTPUT
  9. =====================================
  10. Per second averages calculated from the last 31 seconds
  11. -----------------
  12. BACKGROUND THREAD
  13. -----------------
  14. srv_master_thread loops: 2841299 srv_active, 0 srv_shutdown, 246591 srv_idle
  15. srv_master_thread log flush and writes: 3087728
  16. ----------
  17. SEMAPHORES
  18. ----------
  19. OS WAIT ARRAY INFO: reservation count 2176994
  20. OS WAIT ARRAY INFO: signal count 3864691
  21. RW-shared spins 3256100, rounds 18652613, OS waits 484721
  22. RW-excl spins 1794719, rounds 16531089, OS waits 76759
  23. RW-sx spins 296540, rounds 5522577, OS waits 38928
  24. Spin rounds per wait: 5.73 RW-shared, 9.21 RW-excl, 18.62 RW-sx
  25. ------------------------
  26. LATEST DETECTED DEADLOCK
  27. ------------------------
  28. 2022-03-03 11:16:16 0x7f96fc779700
  29. *** (1) TRANSACTION:
  30. TRANSACTION 3724863655, ACTIVE 0 sec starting index read
  31. mysql tables in use 3, locked 3
  32. LOCK WAIT 4 lock struct(s), heap size 1128, 3 row lock(s)
  33. MySQL thread id 34374517, OS thread handle 140278055986944, query id 268617622 localhost ******* Updating
  34. UPDATE `*******`.`eleves_tchat` SET `lu` = 'true'
  35. WHERE `id_etablissement` = '266'
  36. AND `id_eleve` = '512377'
  37. AND `auteur` = 'enseignant'
  38. AND `lu` = 'false'
  39. *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
  40. RECORD LOCKS space id 1714 page no 278 n bits 944 index fk_te_eleves_tchat_id_etablissement of table `*******`.`eleves_tchat` trx id 3724863655 lock_mode X waiting
  41. Record lock, heap no 684 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  42. 0: len 4; hex 8000010a; asc ;;
  43. 1: len 4; hex 800946e2; asc F ;;
  44.  
  45. *** (2) TRANSACTION:
  46. TRANSACTION 3724863652, ACTIVE 0 sec fetching rows
  47. mysql tables in use 3, locked 3
  48. 7 lock struct(s), heap size 1128, 176 row lock(s)
  49. MySQL thread id 34374515, OS thread handle 140286457517824, query id 268617618 localhost ******* Updating
  50. UPDATE `*******`.`eleves_tchat` SET `lu` = 'true'
  51. WHERE `id_etablissement` = '266'
  52. AND `id_eleve` = '512385'
  53. AND `auteur` = 'enseignant'
  54. AND `lu` = 'false'
  55. *** (2) HOLDS THE LOCK(S):
  56. RECORD LOCKS space id 1714 page no 278 n bits 944 index fk_te_eleves_tchat_id_etablissement of table `*******`.`eleves_tchat` trx id 3724863652 lock_mode X
  57. Record lock, heap no 684 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  58. 0: len 4; hex 8000010a; asc ;;
  59. 1: len 4; hex 800946e2; asc F ;;
  60.  
  61. Record lock, heap no 689 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  62. 0: len 4; hex 8000010a; asc ;;
  63. 1: len 4; hex 800946e3; asc F ;;
  64.  
  65. Record lock, heap no 740 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  66. 0: len 4; hex 8000010a; asc ;;
  67. 1: len 4; hex 800946e4; asc F ;;
  68.  
  69. Record lock, heap no 741 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  70. 0: len 4; hex 8000010a; asc ;;
  71. 1: len 4; hex 800946e5; asc F ;;
  72.  
  73. Record lock, heap no 742 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  74. 0: len 4; hex 8000010a; asc ;;
  75. 1: len 4; hex 800946e6; asc F ;;
  76.  
  77. Record lock, heap no 743 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  78. 0: len 4; hex 8000010a; asc ;;
  79. 1: len 4; hex 800946e7; asc F ;;
  80.  
  81. Record lock, heap no 744 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  82. 0: len 4; hex 8000010a; asc ;;
  83. 1: len 4; hex 800946e8; asc F ;;
  84.  
  85. Record lock, heap no 745 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  86. 0: len 4; hex 8000010a; asc ;;
  87. 1: len 4; hex 800946ea; asc F ;;
  88.  
  89. Record lock, heap no 746 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  90. 0: len 4; hex 8000010a; asc ;;
  91. 1: len 4; hex 800946eb; asc F ;;
  92.  
  93. Record lock, heap no 747 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  94. 0: len 4; hex 8000010a; asc ;;
  95. 1: len 4; hex 800946ec; asc F ;;
  96.  
  97. Record lock, heap no 748 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  98. 0: len 4; hex 8000010a; asc ;;
  99. 1: len 4; hex 800946ef; asc F ;;
  100.  
  101. Record lock, heap no 749 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  102. 0: len 4; hex 8000010a; asc ;;
  103. 1: len 4; hex 800946f0; asc F ;;
  104.  
  105. Record lock, heap no 750 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  106. 0: len 4; hex 8000010a; asc ;;
  107. 1: len 4; hex 800946f1; asc F ;;
  108.  
  109. Record lock, heap no 751 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  110. 0: len 4; hex 8000010a; asc ;;
  111. 1: len 4; hex 800946f2; asc F ;;
  112.  
  113. Record lock, heap no 752 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  114. 0: len 4; hex 8000010a; asc ;;
  115. 1: len 4; hex 800946f3; asc F ;;
  116.  
  117. Record lock, heap no 753 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  118. 0: len 4; hex 8000010a; asc ;;
  119. 1: len 4; hex 800946f4; asc F ;;
  120.  
  121. Record lock, heap no 754 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  122. 0: len 4; hex 8000010a; asc ;;
  123. 1: len 4; hex 800946f5; asc F ;;
  124.  
  125. Record lock, heap no 755 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  126. 0: len 4; hex 8000010a; asc ;;
  127. 1: len 4; hex 800946f6; asc F ;;
  128.  
  129. Record lock, heap no 756 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  130. 0: len 4; hex 8000010a; asc ;;
  131. 1: len 4; hex 800946f7; asc F ;;
  132.  
  133. Record lock, heap no 757 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  134. 0: len 4; hex 8000010a; asc ;;
  135. 1: len 4; hex 800946f8; asc F ;;
  136.  
  137. Record lock, heap no 758 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  138. 0: len 4; hex 8000010a; asc ;;
  139. 1: len 4; hex 800946f9; asc F ;;
  140.  
  141. Record lock, heap no 759 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  142. 0: len 4; hex 8000010a; asc ;;
  143. 1: len 4; hex 800946fa; asc F ;;
  144.  
  145. Record lock, heap no 760 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  146. 0: len 4; hex 8000010a; asc ;;
  147. 1: len 4; hex 800946fb; asc F ;;
  148.  
  149. Record lock, heap no 761 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  150. 0: len 4; hex 8000010a; asc ;;
  151. 1: len 4; hex 800946fc; asc F ;;
  152.  
  153. Record lock, heap no 762 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  154. 0: len 4; hex 8000010a; asc ;;
  155. 1: len 4; hex 80094703; asc G ;;
  156.  
  157. Record lock, heap no 763 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  158. 0: len 4; hex 8000010a; asc ;;
  159. 1: len 4; hex 800946fe; asc F ;;
  160.  
  161. Record lock, heap no 764 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  162. 0: len 4; hex 8000010a; asc ;;
  163. 1: len 4; hex 800946ff; asc F ;;
  164.  
  165. Record lock, heap no 765 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  166. 0: len 4; hex 8000010a; asc ;;
  167. 1: len 4; hex 80094700; asc G ;;
  168.  
  169. Record lock, heap no 766 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  170. 0: len 4; hex 8000010a; asc ;;
  171. 1: len 4; hex 80094701; asc G ;;
  172.  
  173. Record lock, heap no 767 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  174. 0: len 4; hex 8000010a; asc ;;
  175. 1: len 4; hex 80094702; asc G ;;
  176.  
  177. Record lock, heap no 768 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  178. 0: len 4; hex 8000010a; asc ;;
  179. 1: len 4; hex 80094705; asc G ;;
  180.  
  181. Record lock, heap no 769 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  182. 0: len 4; hex 8000010a; asc ;;
  183. 1: len 4; hex 80094707; asc G ;;
  184.  
  185. Record lock, heap no 770 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  186. 0: len 4; hex 8000010a; asc ;;
  187. 1: len 4; hex 80094708; asc G ;;
  188.  
  189. Record lock, heap no 771 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  190. 0: len 4; hex 8000010a; asc ;;
  191. 1: len 4; hex 80094709; asc G ;;
  192.  
  193. Record lock, heap no 772 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  194. 0: len 4; hex 8000010a; asc ;;
  195. 1: len 4; hex 8009470a; asc G ;;
  196.  
  197. Record lock, heap no 773 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  198. 0: len 4; hex 8000010a; asc ;;
  199. 1: len 4; hex 8009470b; asc G ;;
  200.  
  201. Record lock, heap no 774 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  202. 0: len 4; hex 8000010a; asc ;;
  203. 1: len 4; hex 8009470c; asc G ;;
  204.  
  205. Record lock, heap no 775 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  206. 0: len 4; hex 8000010a; asc ;;
  207. 1: len 4; hex 8009470d; asc G ;;
  208.  
  209. Record lock, heap no 776 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  210. 0: len 4; hex 8000010a; asc ;;
  211. 1: len 4; hex 8009470e; asc G ;;
  212.  
  213. Record lock, heap no 777 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  214. 0: len 4; hex 8000010a; asc ;;
  215. 1: len 4; hex 8009470f; asc G ;;
  216.  
  217. Record lock, heap no 778 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  218. 0: len 4; hex 8000010a; asc ;;
  219. 1: len 4; hex 80094712; asc G ;;
  220.  
  221. Record lock, heap no 779 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  222. 0: len 4; hex 8000010a; asc ;;
  223. 1: len 4; hex 80094713; asc G ;;
  224.  
  225. Record lock, heap no 780 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  226. 0: len 4; hex 8000010a; asc ;;
  227. 1: len 4; hex 80094714; asc G ;;
  228.  
  229. Record lock, heap no 781 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  230. 0: len 4; hex 8000010a; asc ;;
  231. 1: len 4; hex 80094715; asc G ;;
  232.  
  233. Record lock, heap no 782 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  234. 0: len 4; hex 8000010a; asc ;;
  235. 1: len 4; hex 80094716; asc G ;;
  236.  
  237. Record lock, heap no 783 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  238. 0: len 4; hex 8000010a; asc ;;
  239. 1: len 4; hex 80094717; asc G ;;
  240.  
  241. Record lock, heap no 784 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  242. 0: len 4; hex 8000010a; asc ;;
  243. 1: len 4; hex 80094718; asc G ;;
  244.  
  245. Record lock, heap no 785 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  246. 0: len 4; hex 8000010a; asc ;;
  247. 1: len 4; hex 80094719; asc G ;;
  248.  
  249. Record lock, heap no 786 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  250. 0: len 4; hex 8000010a; asc ;;
  251. 1: len 4; hex 8009471a; asc G ;;
  252.  
  253. Record lock, heap no 787 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  254. 0: len 4; hex 8000010a; asc ;;
  255. 1: len 4; hex 8009471b; asc G ;;
  256.  
  257. Record lock, heap no 788 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  258. 0: len 4; hex 8000010a; asc ;;
  259. 1: len 4; hex 8009471c; asc G ;;
  260.  
  261. Record lock, heap no 789 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  262. 0: len 4; hex 8000010a; asc ;;
  263. 1: len 4; hex 8009471d; asc G ;;
  264.  
  265. Record lock, heap no 790 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  266. 0: len 4; hex 8000010a; asc ;;
  267. 1: len 4; hex 8009471e; asc G ;;
  268.  
  269. Record lock, heap no 791 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  270. 0: len 4; hex 8000010a; asc ;;
  271. 1: len 4; hex 8009471f; asc G ;;
  272.  
  273. Record lock, heap no 792 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  274. 0: len 4; hex 8000010a; asc ;;
  275. 1: len 4; hex 80094720; asc G ;;
  276.  
  277. Record lock, heap no 793 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  278. 0: len 4; hex 8000010a; asc ;;
  279. 1: len 4; hex 80094721; asc G!;;
  280.  
  281. Record lock, heap no 794 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  282. 0: len 4; hex 8000010a; asc ;;
  283. 1: len 4; hex 80094722; asc G";;
  284.  
  285. Record lock, heap no 795 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  286. 0: len 4; hex 8000010a; asc ;;
  287. 1: len 4; hex 8009472a; asc G*;;
  288.  
  289. Record lock, heap no 796 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  290. 0: len 4; hex 8000010a; asc ;;
  291. 1: len 4; hex 80094724; asc G$;;
  292.  
  293. Record lock, heap no 797 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  294. 0: len 4; hex 8000010a; asc ;;
  295. 1: len 4; hex 80094725; asc G%;;
  296.  
  297. Record lock, heap no 798 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  298. 0: len 4; hex 8000010a; asc ;;
  299. 1: len 4; hex 8009472b; asc G+;;
  300.  
  301. Record lock, heap no 799 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  302. 0: len 4; hex 8000010a; asc ;;
  303. 1: len 4; hex 80094727; asc G';;
  304.  
  305. Record lock, heap no 800 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  306. 0: len 4; hex 8000010a; asc ;;
  307. 1: len 4; hex 80094728; asc G(;;
  308.  
  309. Record lock, heap no 801 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  310. 0: len 4; hex 8000010a; asc ;;
  311. 1: len 4; hex 8009472c; asc G,;;
  312.  
  313. Record lock, heap no 802 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  314. 0: len 4; hex 8000010a; asc ;;
  315. 1: len 4; hex 8009472d; asc G-;;
  316.  
  317. Record lock, heap no 803 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  318. 0: len 4; hex 8000010a; asc ;;
  319. 1: len 4; hex 8009472e; asc G.;;
  320.  
  321. Record lock, heap no 804 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  322. 0: len 4; hex 8000010a; asc ;;
  323. 1: len 4; hex 80094732; asc G2;;
  324.  
  325. Record lock, heap no 805 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  326. 0: len 4; hex 8000010a; asc ;;
  327. 1: len 4; hex 800949e6; asc I ;;
  328.  
  329. Record lock, heap no 806 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  330. 0: len 4; hex 8000010a; asc ;;
  331. 1: len 4; hex 800949e5; asc I ;;
  332.  
  333. Record lock, heap no 807 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  334. 0: len 4; hex 8000010a; asc ;;
  335. 1: len 4; hex 800949e4; asc I ;;
  336.  
  337. Record lock, heap no 808 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  338. 0: len 4; hex 8000010a; asc ;;
  339. 1: len 4; hex 800949e7; asc I ;;
  340.  
  341. Record lock, heap no 809 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  342. 0: len 4; hex 8000010a; asc ;;
  343. 1: len 4; hex 800949e8; asc I ;;
  344.  
  345. Record lock, heap no 810 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  346. 0: len 4; hex 8000010a; asc ;;
  347. 1: len 4; hex 800949e9; asc I ;;
  348.  
  349. Record lock, heap no 811 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  350. 0: len 4; hex 8000010a; asc ;;
  351. 1: len 4; hex 800949ea; asc I ;;
  352.  
  353. Record lock, heap no 812 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  354. 0: len 4; hex 8000010a; asc ;;
  355. 1: len 4; hex 800949eb; asc I ;;
  356.  
  357. Record lock, heap no 814 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  358. 0: len 4; hex 8000010a; asc ;;
  359. 1: len 4; hex 800949ed; asc I ;;
  360.  
  361. Record lock, heap no 815 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  362. 0: len 4; hex 8000010a; asc ;;
  363. 1: len 4; hex 800949ee; asc I ;;
  364.  
  365. Record lock, heap no 816 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  366. 0: len 4; hex 8000010a; asc ;;
  367. 1: len 4; hex 800949ef; asc I ;;
  368.  
  369. Record lock, heap no 817 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  370. 0: len 4; hex 8000010a; asc ;;
  371. 1: len 4; hex 800949f1; asc I ;;
  372.  
  373. Record lock, heap no 818 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  374. 0: len 4; hex 8000010a; asc ;;
  375. 1: len 4; hex 800949f2; asc I ;;
  376.  
  377. Record lock, heap no 819 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  378. 0: len 4; hex 8000010a; asc ;;
  379. 1: len 4; hex 800949f3; asc I ;;
  380.  
  381. Record lock, heap no 820 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  382. 0: len 4; hex 8000010a; asc ;;
  383. 1: len 4; hex 800949f4; asc I ;;
  384.  
  385. Record lock, heap no 821 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  386. 0: len 4; hex 8000010a; asc ;;
  387. 1: len 4; hex 800949f5; asc I ;;
  388.  
  389. Record lock, heap no 822 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  390. 0: len 4; hex 8000010a; asc ;;
  391. 1: len 4; hex 800949f6; asc I ;;
  392.  
  393. Record lock, heap no 823 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  394. 0: len 4; hex 8000010a; asc ;;
  395. 1: len 4; hex 800949f7; asc I ;;
  396.  
  397. Record lock, heap no 824 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
  398. 0: len 4; hex 8000010a; asc ;;
  399. 1: len 4; hex 800949f8; asc I ;;
  400.  
  401. *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
  402. RECORD LOCKS space id 1714 page no 249 n bits 264 index PRIMARY of table `*******`.`eleves_tchat` trx id 3724863652 lock_mode X locks rec but not gap waiting
  403. Record lock, heap no 187 PHYSICAL RECORD: n_fields 9; compact format; info bits 0
  404. 0: len 4; hex 800949f8; asc I ;;
  405. 1: len 6; hex 000000000000; asc ;;
  406. 2: len 7; hex 80000000000000; asc ;;
  407. 3: len 5; hex 99ac46aa2e; asc F .;;
  408. 4: len 4; hex 8000010a; asc ;;
  409. 5: len 4; hex 8007d179; asc y;;
  410. 6: len 1; hex 02; asc ;;
  411. 7: len 30; hex 426f6e6a6f75722c20736920766f7573206176657a206465732071756573; asc Bonjour, si vous avez des ques; (total 77 bytes);
  412. 8: len 1; hex 02; asc ;;
  413.  
  414. *** WE ROLL BACK TRANSACTION (1)
  415. ------------
  416. TRANSACTIONS
  417. ------------
  418. Trx id counter 3725342195
  419. Purge done for trx's n:o < 3725342194 undo n:o < 0 state: running
  420. History list length 2
  421. LIST OF TRANSACTIONS FOR EACH SESSION:
  422.  
  423. 0 lock struct(s), heap size 1128, 0 row lock(s)
  424. ---TRANSACTION 421768647694312, not started
  425. 0 lock struct(s), heap size 1128, 0 row lock(s)
  426. ---TRANSACTION 421768647685960, not started
  427. 0 lock struct(s), heap size 1128, 0 row lock(s)
  428. ---TRANSACTION 421768646913400, not started
  429. 0 lock struct(s), heap size 1128, 0 row lock(s)
  430. ---TRANSACTION 421768646896696, not started
  431. 0 lock struct(s), heap size 1128, 0 row lock(s)
  432. ---TRANSACTION 421768647673432, not started
  433. 0 lock struct(s), heap size 1128, 0 row lock(s)
  434. ---TRANSACTION 421768647385288, not started
  435. 0 lock struct(s), heap size 1128, 0 row lock(s)
  436. ---TRANSACTION 421768647042856, not started
  437. 0 lock struct(s), heap size 1128, 0 row lock(s)
  438. ---TRANSACTION 421768646316232, not started
  439. 0 lock struct(s), heap size 1128, 0 row lock(s)
  440. ---TRANSACTION 421768646562616, not started
  441. 0 lock struct(s), heap size 1128, 0 row lock(s)
  442. ---TRANSACTION 421768646550088, not started
  443. 0 lock struct(s), heap size 1128, 0 row lock(s)
  444. ---TRANSACTION 421768646516680, not started
  445. 0 lock struct(s), heap size 1128, 0 row lock(s)
  446. ---TRANSACTION 421768646299528, not started
  447. 0 lock struct(s), heap size 1128, 0 row lock(s)
  448. ---TRANSACTION 421768646278648, not started
  449. 0 lock struct(s), heap size 1128, 0 row lock(s)
  450. ---TRANSACTION 421768645986328, not started
  451. 0 lock struct(s), heap size 1128, 0 row lock(s)
  452. ---TRANSACTION 421768645977976, not started
  453. 0 lock struct(s), heap size 1128, 0 row lock(s)
  454. ---TRANSACTION 421768645902808, not started
  455. 0 lock struct(s), heap size 1128, 0 row lock(s)
  456. ---TRANSACTION 421768645819288, not started
  457. 0 lock struct(s), heap size 1128, 0 row lock(s)
  458. ---TRANSACTION 421768645710712, not started
  459. 0 lock struct(s), heap size 1128, 0 row lock(s)
  460. ---TRANSACTION 421768645501912, not started
  461. 0 lock struct(s), heap size 1128, 0 row lock(s)
  462. ---TRANSACTION 421768645689832, not started
  463. 0 lock struct(s), heap size 1128, 0 row lock(s)
  464. ---TRANSACTION 421768645535320, not started
  465. 0 lock struct(s), heap size 1128, 0 row lock(s)
  466. ---TRANSACTION 421768647665080, not started
  467. 0 lock struct(s), heap size 1128, 0 row lock(s)
  468. ---TRANSACTION 421768647660904, not started
  469. 0 lock struct(s), heap size 1128, 0 row lock(s)
  470. ---TRANSACTION 421768647656728, not started
  471. 0 lock struct(s), heap size 1128, 0 row lock(s)
  472. ---TRANSACTION 421768645564552, not started
  473. 0 lock struct(s), heap size 1128, 0 row lock(s)
  474. ---TRANSACTION 421768647652552, not started
  475. 0 lock struct(s), heap size 1128, 0 row lock(s)
  476. ---TRANSACTION 421768646838232, not started
  477. 0 lock struct(s), heap size 1128, 0 row lock(s)
  478. ---TRANSACTION 421768647648376, not started
  479. 0 lock struct(s), heap size 1128, 0 row lock(s)
  480. ---TRANSACTION 421768647218248, not started
  481. 0 lock struct(s), heap size 1128, 0 row lock(s)
  482. ---TRANSACTION 421768647356056, not started
  483. 0 lock struct(s), heap size 1128, 0 row lock(s)
  484. ---TRANSACTION 421768646495800, not started
  485. 0 lock struct(s), heap size 1128, 0 row lock(s)
  486. ---TRANSACTION 421768645865224, not started
  487. 0 lock struct(s), heap size 1128, 0 row lock(s)
  488. ---TRANSACTION 421768647072088, not started
  489. 0 lock struct(s), heap size 1128, 0 row lock(s)
  490. ---TRANSACTION 421768646445688, not started
  491. 0 lock struct(s), heap size 1128, 0 row lock(s)
  492. ---TRANSACTION 421768646466568, not started
  493. 0 lock struct(s), heap size 1128, 0 row lock(s)
  494. ---TRANSACTION 421768646408104, not started
  495. 0 lock struct(s), heap size 1128, 0 row lock(s)
  496. ---TRANSACTION 421768645886104, not started
  497. 0 lock struct(s), heap size 1128, 0 row lock(s)
  498. ---TRANSACTION 421768647631672, not started
  499. 0 lock struct(s), heap size 1128, 0 row lock(s)
  500. ---TRANSACTION 421768647627496, not started
  501. 0 lock struct(s), heap size 1128, 0 row lock(s)
  502. ---TRANSACTION 421768647623320, not started
  503. 0 lock struct(s), heap size 1128, 0 row lock(s)
  504. ---TRANSACTION 421768647619144, not started
  505. 0 lock struct(s), heap size 1128, 0 row lock(s)
  506. ---TRANSACTION 421768647372760, not started
  507. 0 lock struct(s), heap size 1128, 0 row lock(s)
  508. ---TRANSACTION 421768646424808, not started
  509. 0 lock struct(s), heap size 1128, 0 row lock(s)
  510. ---TRANSACTION 421768647614968, not started
  511. 0 lock struct(s), heap size 1128, 0 row lock(s)
  512. ---TRANSACTION 421768647368584, not started
  513. 0 lock struct(s), heap size 1128, 0 row lock(s)
  514. ---TRANSACTION 421768647376936, not started
  515. 0 lock struct(s), heap size 1128, 0 row lock(s)
  516. ---TRANSACTION 421768647364408, not started
  517. 0 lock struct(s), heap size 1128, 0 row lock(s)
  518. ---TRANSACTION 421768646900872, not started
  519. 0 lock struct(s), heap size 1128, 0 row lock(s)
  520. ---TRANSACTION 421768647360232, not started
  521. 0 lock struct(s), heap size 1128, 0 row lock(s)
  522. ---TRANSACTION 421768647343528, not started
  523. 0 lock struct(s), heap size 1128, 0 row lock(s)
  524. ---TRANSACTION 421768646637784, not started
  525. 0 lock struct(s), heap size 1128, 0 row lock(s)
  526. ---TRANSACTION 421768646119960, not started
  527. 0 lock struct(s), heap size 1128, 0 row lock(s)
  528. ---TRANSACTION 421768647310120, not started
  529. 0 lock struct(s), heap size 1128, 0 row lock(s)
  530. ---TRANSACTION 421768646082376, not started
  531. 0 lock struct(s), heap size 1128, 0 row lock(s)
  532. ---TRANSACTION 421768647331000, not started
  533. 0 lock struct(s), heap size 1128, 0 row lock(s)
  534. ---TRANSACTION 421768646274472, not started
  535. 0 lock struct(s), heap size 1128, 0 row lock(s)
  536. ---TRANSACTION 421768646813176, not started
  537. 0 lock struct(s), heap size 1128, 0 row lock(s)
  538. ---TRANSACTION 421768647326824, not started
  539. 0 lock struct(s), heap size 1128, 0 row lock(s)
  540. ---TRANSACTION 421768646955160, not started
  541. 0 lock struct(s), heap size 1128, 0 row lock(s)
  542. ---TRANSACTION 421768645877752, not started
  543. 0 lock struct(s), heap size 1128, 0 row lock(s)
  544. ---TRANSACTION 421768647268360, not started
  545. 0 lock struct(s), heap size 1128, 0 row lock(s)
  546. ---TRANSACTION 421768647101320, not started
  547. 0 lock struct(s), heap size 1128, 0 row lock(s)
  548. ---TRANSACTION 421768645648072, not started
  549. 0 lock struct(s), heap size 1128, 0 row lock(s)
  550. ---TRANSACTION 421768645748296, not started
  551. 0 lock struct(s), heap size 1128, 0 row lock(s)
  552. ---TRANSACTION 421768647063736, not started
  553. 0 lock struct(s), heap size 1128, 0 row lock(s)
  554. ---TRANSACTION 421768645677304, not started
  555. 0 lock struct(s), heap size 1128, 0 row lock(s)
  556. ---TRANSACTION 421768645547848, not started
  557. 0 lock struct(s), heap size 1128, 0 row lock(s)
  558. ---TRANSACTION 421768646888344, not started
  559. 0 lock struct(s), heap size 1128, 0 row lock(s)
  560. ---TRANSACTION 421768646804824, not started
  561. 0 lock struct(s), heap size 1128, 0 row lock(s)
  562. ---TRANSACTION 421768646779768, not started
  563. 0 lock struct(s), heap size 1128, 0 row lock(s)
  564. ---TRANSACTION 421768646679544, not started
  565. 0 lock struct(s), heap size 1128, 0 row lock(s)
  566. ---TRANSACTION 421768646332936, not started
  567. 0 lock struct(s), heap size 1128, 0 row lock(s)
  568. ---TRANSACTION 421768646174248, not started
  569. 0 lock struct(s), heap size 1128, 0 row lock(s)
  570. ---TRANSACTION 421768646541736, not started
  571. 0 lock struct(s), heap size 1128, 0 row lock(s)
  572. ---TRANSACTION 421768646416456, not started
  573. 0 lock struct(s), heap size 1128, 0 row lock(s)
  574. ---TRANSACTION 421768647953224, not started
  575. 0 lock struct(s), heap size 1128, 0 row lock(s)
  576. ---TRANSACTION 421768647949048, not started
  577. 0 lock struct(s), heap size 1128, 0 row lock(s)
  578. ---TRANSACTION 421768645526968, not started
  579. 0 lock struct(s), heap size 1128, 0 row lock(s)
  580. ---TRANSACTION 421768646399752, not started
  581. 0 lock struct(s), heap size 1128, 0 row lock(s)
  582. ---TRANSACTION 421768646220184, not started
  583. 0 lock struct(s), heap size 1128, 0 row lock(s)
  584. ---TRANSACTION 421768645806760, not started
  585. 0 lock struct(s), heap size 1128, 0 row lock(s)
  586. ---TRANSACTION 421768645560376, not started
  587. 0 lock struct(s), heap size 1128, 0 row lock(s)
  588. ---TRANSACTION 421768645539496, not started
  589. 0 lock struct(s), heap size 1128, 0 row lock(s)
  590. ---TRANSACTION 421768647944872, not started
  591. 0 lock struct(s), heap size 1128, 0 row lock(s)
  592. ---TRANSACTION 421768647381112, not started
  593. 0 lock struct(s), heap size 1128, 0 row lock(s)
  594. ---TRANSACTION 421768645965448, not started
  595. 0 lock struct(s), heap size 1128, 0 row lock(s)
  596. ---TRANSACTION 421768645856872, not started
  597. 0 lock struct(s), heap size 1128, 0 row lock(s)
  598. ---TRANSACTION 421768647264184, not started
  599. 0 lock struct(s), heap size 1128, 0 row lock(s)
  600. ---TRANSACTION 421768647940696, not started
  601. 0 lock struct(s), heap size 1128, 0 row lock(s)
  602. ---TRANSACTION 421768647936520, not started
  603. 0 lock struct(s), heap size 1128, 0 row lock(s)
  604. ---TRANSACTION 421768647932344, not started
  605. 0 lock struct(s), heap size 1128, 0 row lock(s)
  606. ---TRANSACTION 421768646287000, not started
  607. 0 lock struct(s), heap size 1128, 0 row lock(s)
  608. ---TRANSACTION 421768645911160, not started
  609. 0 lock struct(s), heap size 1128, 0 row lock(s)
  610. ---TRANSACTION 421768647610792, not started
  611. 0 lock struct(s), heap size 1128, 0 row lock(s)
  612. ---TRANSACTION 421768647606616, not started
  613. 0 lock struct(s), heap size 1128, 0 row lock(s)
  614. ---TRANSACTION 421768647322648, not started
  615. 0 lock struct(s), heap size 1128, 0 row lock(s)
  616. ---TRANSACTION 421768647314296, not started
  617. 0 lock struct(s), heap size 1128, 0 row lock(s)
  618. ---TRANSACTION 421768646846584, not started
  619. 0 lock struct(s), heap size 1128, 0 row lock(s)
  620. ---TRANSACTION 421768647209896, not started
  621. 0 lock struct(s), heap size 1128, 0 row lock(s)
  622. ---TRANSACTION 421768646291176, not started
  623. 0 lock struct(s), heap size 1128, 0 row lock(s)
  624. ---TRANSACTION 421768645785880, not started
  625. 0 lock struct(s), heap size 1128, 0 row lock(s)
  626. ---TRANSACTION 421768647418696, not started
  627. 0 lock struct(s), heap size 1128, 0 row lock(s)
  628. ---TRANSACTION 421768647928168, not started
  629. 0 lock struct(s), heap size 1128, 0 row lock(s)
  630. ---TRANSACTION 421768647923992, not started
  631. 0 lock struct(s), heap size 1128, 0 row lock(s)
  632. ---TRANSACTION 421768646224360, not started
  633. 0 lock struct(s), heap size 1128, 0 row lock(s)
  634. ---TRANSACTION 421768645765000, not started
  635. 0 lock struct(s), heap size 1128, 0 row lock(s)
  636. ---TRANSACTION 421768647598264, not started
  637. 0 lock struct(s), heap size 1128, 0 row lock(s)
  638. ---TRANSACTION 421768647594088, not started
  639. 0 lock struct(s), heap size 1128, 0 row lock(s)
  640. ---TRANSACTION 421768647589912, not started
  641. 0 lock struct(s), heap size 1128, 0 row lock(s)
  642. ---TRANSACTION 421768646378872, not started
  643. 0 lock struct(s), heap size 1128, 0 row lock(s)
  644. ---TRANSACTION 421768646353816, not started
  645. 0 lock struct(s), heap size 1128, 0 row lock(s)
  646. ---TRANSACTION 421768647585736, not started
  647. 0 lock struct(s), heap size 1128, 0 row lock(s)
  648. ---TRANSACTION 421768646307880, not started
  649. 0 lock struct(s), heap size 1128, 0 row lock(s)
  650. ---TRANSACTION 421768647581560, not started
  651. 0 lock struct(s), heap size 1128, 0 row lock(s)
  652. ---TRANSACTION 421768646245240, not started
  653. 0 lock struct(s), heap size 1128, 0 row lock(s)
  654. ---TRANSACTION 421768647569032, not started
  655. 0 lock struct(s), heap size 1128, 0 row lock(s)
  656. ---TRANSACTION 421768646236888, not started
  657. 0 lock struct(s), heap size 1128, 0 row lock(s)
  658. ---TRANSACTION 421768646216008, not started
  659. 0 lock struct(s), heap size 1128, 0 row lock(s)
  660. ---TRANSACTION 421768647919816, not started
  661. 0 lock struct(s), heap size 1128, 0 row lock(s)
  662. ---TRANSACTION 421768646153368, not started
  663. 0 lock struct(s), heap size 1128, 0 row lock(s)
  664. ---TRANSACTION 421768647573208, not started
  665. 0 lock struct(s), heap size 1128, 0 row lock(s)
  666. ---TRANSACTION 421768647564856, not started
  667. 0 lock struct(s), heap size 1128, 0 row lock(s)
  668. ---TRANSACTION 421768647556504, not started
  669. 0 lock struct(s), heap size 1128, 0 row lock(s)
  670. ---TRANSACTION 421768647560680, not started
  671. 0 lock struct(s), heap size 1128, 0 row lock(s)
  672. ---TRANSACTION 421768647552328, not started
  673. 0 lock struct(s), heap size 1128, 0 row lock(s)
  674. ---TRANSACTION 421768647406168, not started
  675. 0 lock struct(s), heap size 1128, 0 row lock(s)
  676. ---TRANSACTION 421768646136664, not started
  677. 0 lock struct(s), heap size 1128, 0 row lock(s)
  678. ---TRANSACTION 421768646721304, not started
  679. 0 lock struct(s), heap size 1128, 0 row lock(s)
  680. ---TRANSACTION 421768646178424, not started
  681. 0 lock struct(s), heap size 1128, 0 row lock(s)
  682. ---TRANSACTION 421768646165896, not started
  683. 0 lock struct(s), heap size 1128, 0 row lock(s)
  684. ---TRANSACTION 421768647548152, not started
  685. 0 lock struct(s), heap size 1128, 0 row lock(s)
  686. ---TRANSACTION 421768647297592, not started
  687. 0 lock struct(s), heap size 1128, 0 row lock(s)
  688. ---TRANSACTION 421768646984392, not started
  689. 0 lock struct(s), heap size 1128, 0 row lock(s)
  690. ---TRANSACTION 421768646094904, not started
  691. 0 lock struct(s), heap size 1128, 0 row lock(s)
  692. ---TRANSACTION 421768646692072, not started
  693. 0 lock struct(s), heap size 1128, 0 row lock(s)
  694. ---TRANSACTION 421768646161720, not started
  695. 0 lock struct(s), heap size 1128, 0 row lock(s)
  696. ---TRANSACTION 421768645735768, not started
  697. 0 lock struct(s), heap size 1128, 0 row lock(s)
  698. ---TRANSACTION 421768646036440, not started
  699. 0 lock struct(s), heap size 1128, 0 row lock(s)
  700. ---TRANSACTION 421768647894760, not started
  701. 0 lock struct(s), heap size 1128, 0 row lock(s)
  702. ---TRANSACTION 421768647848824, not started
  703. 0 lock struct(s), heap size 1128, 0 row lock(s)
  704. ---TRANSACTION 421768645890280, not started
  705. 0 lock struct(s), heap size 1128, 0 row lock(s)
  706. ---TRANSACTION 421768647844648, not started
  707. 0 lock struct(s), heap size 1128, 0 row lock(s)
  708. ---TRANSACTION 421768645752472, not started
  709. 0 lock struct(s), heap size 1128, 0 row lock(s)
  710. ---TRANSACTION 421768647543976, not started
  711. 0 lock struct(s), heap size 1128, 0 row lock(s)
  712. ---TRANSACTION 421768647535624, not started
  713. 0 lock struct(s), heap size 1128, 0 row lock(s)
  714. ---TRANSACTION 421768647539800, not started
  715. 0 lock struct(s), heap size 1128, 0 row lock(s)
  716. ---TRANSACTION 421768647523096, not started
  717. 0 lock struct(s), heap size 1128, 0 row lock(s)
  718. ---TRANSACTION 421768647531448, not started
  719. 0 lock struct(s), heap size 1128, 0 row lock(s)
  720. ---TRANSACTION 421768647518920, not started
  721. 0 lock struct(s), heap size 1128, 0 row lock(s)
  722. ---TRANSACTION 421768647456280, not started
  723. 0 lock struct(s), heap size 1128, 0 row lock(s)
  724. ---TRANSACTION 421768646462392, not started
  725. 0 lock struct(s), heap size 1128, 0 row lock(s)
  726. ---TRANSACTION 421768647180664, not started
  727. 0 lock struct(s), heap size 1128, 0 row lock(s)
  728. ---TRANSACTION 421768647176488, not started
  729. 0 lock struct(s), heap size 1128, 0 row lock(s)
  730. ---TRANSACTION 421768647172312, not started
  731. 0 lock struct(s), heap size 1128, 0 row lock(s)
  732. ---TRANSACTION 421768647088792, not started
  733. 0 lock struct(s), heap size 1128, 0 row lock(s)
  734. ---TRANSACTION 421768647030328, not started
  735. 0 lock struct(s), heap size 1128, 0 row lock(s)
  736. ---TRANSACTION 421768647009448, not started
  737. 0 lock struct(s), heap size 1128, 0 row lock(s)
  738. ---TRANSACTION 421768647163960, not started
  739. 0 lock struct(s), heap size 1128, 0 row lock(s)
  740. ---TRANSACTION 421768647168136, not started
  741. 0 lock struct(s), heap size 1128, 0 row lock(s)
  742. ---TRANSACTION 421768647159784, not started
  743. 0 lock struct(s), heap size 1128, 0 row lock(s)
  744. ---TRANSACTION 421768645585432, not started
  745. 0 lock struct(s), heap size 1128, 0 row lock(s)
  746. ---TRANSACTION 421768647155608, not started
  747. 0 lock struct(s), heap size 1128, 0 row lock(s)
  748. ---TRANSACTION 421768647151432, not started
  749. 0 lock struct(s), heap size 1128, 0 row lock(s)
  750. ---TRANSACTION 421768647147256, not started
  751. 0 lock struct(s), heap size 1128, 0 row lock(s)
  752. ---TRANSACTION 421768647143080, not started
  753. 0 lock struct(s), heap size 1128, 0 row lock(s)
  754. ---TRANSACTION 421768647138904, not started
  755. 0 lock struct(s), heap size 1128, 0 row lock(s)
  756. ---TRANSACTION 421768647130552, not started
  757. 0 lock struct(s), heap size 1128, 0 row lock(s)
  758. ---TRANSACTION 421768645719064, not started
  759. 0 lock struct(s), heap size 1128, 0 row lock(s)
  760. ---TRANSACTION 421768645694008, not started
  761. 0 lock struct(s), heap size 1128, 0 row lock(s)
  762. ---TRANSACTION 421768646483272, not started
  763. 0 lock struct(s), heap size 1128, 0 row lock(s)
  764. ---TRANSACTION 421768645556200, not started
  765. 0 lock struct(s), heap size 1128, 0 row lock(s)
  766. ---TRANSACTION 421768646980216, not started
  767. 0 lock struct(s), heap size 1128, 0 row lock(s)
  768. ---TRANSACTION 421768647126376, not started
  769. 0 lock struct(s), heap size 1128, 0 row lock(s)
  770. ---TRANSACTION 421768646261944, not started
  771. 0 lock struct(s), heap size 1128, 0 row lock(s)
  772. ---TRANSACTION 421768646228536, not started
  773. 0 lock struct(s), heap size 1128, 0 row lock(s)
  774. ---TRANSACTION 421768647122200, not started
  775. 0 lock struct(s), heap size 1128, 0 row lock(s)
  776. ---TRANSACTION 421768647118024, not started
  777. 0 lock struct(s), heap size 1128, 0 row lock(s)
  778. ---TRANSACTION 421768647051208, not started
  779. 0 lock struct(s), heap size 1128, 0 row lock(s)
  780. ---TRANSACTION 421768646362168, not started
  781. 0 lock struct(s), heap size 1128, 0 row lock(s)
  782. ---TRANSACTION 421768646950984, not started
  783. 0 lock struct(s), heap size 1128, 0 row lock(s)
  784. ---TRANSACTION 421768646520856, not started
  785. 0 lock struct(s), heap size 1128, 0 row lock(s)
  786. ---TRANSACTION 421768646232712, not started
  787. 0 lock struct(s), heap size 1128, 0 row lock(s)
  788. ---TRANSACTION 421768646157544, not started
  789. 0 lock struct(s), heap size 1128, 0 row lock(s)
  790. ---TRANSACTION 421768646115784, not started
  791. 0 lock struct(s), heap size 1128, 0 row lock(s)
  792. ---TRANSACTION 421768646879992, not started
  793. 0 lock struct(s), heap size 1128, 0 row lock(s)
  794. ---TRANSACTION 421768647109672, not started
  795. 0 lock struct(s), heap size 1128, 0 row lock(s)
  796. ---TRANSACTION 421768646132488, not started
  797. 0 lock struct(s), heap size 1128, 0 row lock(s)
  798. ---TRANSACTION 421768646124136, not started
  799. 0 lock struct(s), heap size 1128, 0 row lock(s)
  800. ---TRANSACTION 421768645660600, not started
  801. 0 lock struct(s), heap size 1128, 0 row lock(s)
  802. ---TRANSACTION 421768646946808, not started
  803. 0 lock struct(s), heap size 1128, 0 row lock(s)
  804. ---TRANSACTION 421768646942632, not started
  805. 0 lock struct(s), heap size 1128, 0 row lock(s)
  806. ---TRANSACTION 421768645593784, not started
  807. 0 lock struct(s), heap size 1128, 0 row lock(s)
  808. ---TRANSACTION 421768645531144, not started
  809. 0 lock struct(s), heap size 1128, 0 row lock(s)
  810. ---TRANSACTION 421768646976040, not started
  811. 0 lock struct(s), heap size 1128, 0 row lock(s)
  812. ---TRANSACTION 421768646738008, not started
  813. 0 lock struct(s), heap size 1128, 0 row lock(s)
  814. ---TRANSACTION 421768646963512, not started
  815. 0 lock struct(s), heap size 1128, 0 row lock(s)
  816. ---TRANSACTION 421768646800648, not started
  817. 0 lock struct(s), heap size 1128, 0 row lock(s)
  818. ---TRANSACTION 421768646742184, not started
  819. 0 lock struct(s), heap size 1128, 0 row lock(s)
  820. ---TRANSACTION 421768646596024, not started
  821. 0 lock struct(s), heap size 1128, 0 row lock(s)
  822. ---TRANSACTION 421768645472680, not started
  823. 0 lock struct(s), heap size 1128, 0 row lock(s)
  824. ---TRANSACTION 421768645493560, not started
  825. 0 lock struct(s), heap size 1128, 0 row lock(s)
  826. ---TRANSACTION 421768645464328, not started
  827. 0 lock struct(s), heap size 1128, 0 row lock(s)
  828. ---TRANSACTION 421768646545912, not started
  829. 0 lock struct(s), heap size 1128, 0 row lock(s)
  830. ---TRANSACTION 421768646420632, not started
  831. 0 lock struct(s), heap size 1128, 0 row lock(s)
  832. ---TRANSACTION 421768646349640, not started
  833. 0 lock struct(s), heap size 1128, 0 row lock(s)
  834. ---TRANSACTION 421768647105496, not started
  835. 0 lock struct(s), heap size 1128, 0 row lock(s)
  836. ---TRANSACTION 421768647084616, not started
  837. 0 lock struct(s), heap size 1128, 0 row lock(s)
  838. ---TRANSACTION 421768647076264, not started
  839. 0 lock struct(s), heap size 1128, 0 row lock(s)
  840. ---TRANSACTION 421768647067912, not started
  841. 0 lock struct(s), heap size 1128, 0 row lock(s)
  842. ---TRANSACTION 421768647059560, not started
  843. 0 lock struct(s), heap size 1128, 0 row lock(s)
  844. ---TRANSACTION 421768646069848, not started
  845. 0 lock struct(s), heap size 1128, 0 row lock(s)
  846. ---TRANSACTION 421768646667016, not started
  847. 0 lock struct(s), heap size 1128, 0 row lock(s)
  848. ---TRANSACTION 421768647055384, not started
  849. 0 lock struct(s), heap size 1128, 0 row lock(s)
  850. ---TRANSACTION 421768646487448, not started
  851. 0 lock struct(s), heap size 1128, 0 row lock(s)
  852. ---TRANSACTION 421768646875816, not started
  853. 0 lock struct(s), heap size 1128, 0 row lock(s)
  854. ---TRANSACTION 421768646725480, not started
  855. 0 lock struct(s), heap size 1128, 0 row lock(s)
  856. ---TRANSACTION 421768647047032, not started
  857. 0 lock struct(s), heap size 1128, 0 row lock(s)
  858. ---TRANSACTION 421768645898632, not started
  859. 0 lock struct(s), heap size 1128, 0 row lock(s)
  860. ---TRANSACTION 421768646040616, not started
  861. 0 lock struct(s), heap size 1128, 0 row lock(s)
  862. ---TRANSACTION 421768646687896, not started
  863. 0 lock struct(s), heap size 1128, 0 row lock(s)
  864. ---TRANSACTION 421768645460152, not started
  865. 0 lock struct(s), heap size 1128, 0 row lock(s)
  866. --------
  867. FILE I/O
  868. --------
  869. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  870. I/O thread 1 state: waiting for completed aio requests (log thread)
  871. I/O thread 2 state: waiting for completed aio requests (read thread)
  872. I/O thread 3 state: waiting for completed aio requests (read thread)
  873. I/O thread 4 state: waiting for completed aio requests (read thread)
  874. I/O thread 5 state: waiting for completed aio requests (read thread)
  875. I/O thread 6 state: waiting for completed aio requests (write thread)
  876. I/O thread 7 state: waiting for completed aio requests (write thread)
  877. I/O thread 8 state: waiting for completed aio requests (write thread)
  878. I/O thread 9 state: waiting for completed aio requests (write thread)
  879. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  880. ibuf aio reads:, log i/o's:, sync i/o's:
  881. Pending flushes (fsync) log: 0; buffer pool: 0
  882. 146302 OS file reads, 59906376 OS file writes, 11971511 OS fsyncs
  883. 0.00 reads/s, 0 avg bytes/read, 44.16 writes/s, 0.97 fsyncs/s
  884. -------------------------------------
  885. INSERT BUFFER AND ADAPTIVE HASH INDEX
  886. -------------------------------------
  887. Ibuf: size 1, free list len 7564, seg size 7566, 4595 merges
  888. merged operations:
  889. insert 4586, delete mark 88, delete 53
  890. discarded operations:
  891. insert 0, delete mark 0, delete 0
  892. Hash table size 1593833, node heap has 233 buffer(s)
  893. Hash table size 1593833, node heap has 310 buffer(s)
  894. Hash table size 1593833, node heap has 907 buffer(s)
  895. Hash table size 1593833, node heap has 363 buffer(s)
  896. Hash table size 1593833, node heap has 16157 buffer(s)
  897. Hash table size 1593833, node heap has 367 buffer(s)
  898. Hash table size 1593833, node heap has 492 buffer(s)
  899. Hash table size 1593833, node heap has 763 buffer(s)
  900. 27691.43 hash searches/s, 1943.20 non-hash searches/s
  901. ---
  902. LOG
  903. ---
  904. Log sequence number 471740999855
  905. Log flushed up to 471740986449
  906. Pages flushed up to 471716342331
  907. Last checkpoint at 471716342331
  908. 0 pending log flushes, 0 pending chkp writes
  909. 37597053 log i/o's done, 44.16 log i/o's/second
  910. ----------------------
  911. BUFFER POOL AND MEMORY
  912. ----------------------
  913. Total large memory allocated 6611271680
  914. Dictionary memory allocated 337568
  915. Buffer pool size 393216
  916. Free buffers 193281
  917. Database pages 180343
  918. Old database pages 66449
  919. Modified db pages 3959
  920. Percent of dirty pages(LRU & free pages): 1.060
  921. Max dirty pages percent: 75.000
  922. Pending reads 0
  923. Pending writes: LRU 0, flush list 0, single page 0
  924. Pages made young 4829, not young 0
  925. 0.00 youngs/s, 0.00 non-youngs/s
  926. Pages read 146163, created 34180, written 19066619
  927. 0.00 reads/s, 0.06 creates/s, 0.00 writes/s
  928. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  929. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  930. LRU len: 180343, unzip_LRU len: 0
  931. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  932. ----------------------
  933. INDIVIDUAL BUFFER POOL INFO
  934. ----------------------
  935. ---BUFFER POOL 0
  936. Buffer pool size 65536
  937. Free buffers 31830
  938. Database pages 30420
  939. Old database pages 11209
  940. Modified db pages 519
  941. Percent of dirty pages(LRU & free pages): 0.834
  942. Max dirty pages percent: 75.000
  943. Pending reads 0
  944. Pending writes: LRU 0, flush list 0, single page 0
  945. Pages made young 745, not young 0
  946. 0.00 youngs/s, 0.00 non-youngs/s
  947. Pages read 24865, created 5555, written 2420597
  948. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  949. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  950. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  951. LRU len: 30420, unzip_LRU len: 0
  952. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  953. ---BUFFER POOL 1
  954. Buffer pool size 65536
  955. Free buffers 32599
  956. Database pages 29678
  957. Old database pages 10935
  958. Modified db pages 627
  959. Percent of dirty pages(LRU & free pages): 1.007
  960. Max dirty pages percent: 75.000
  961. Pending reads 0
  962. Pending writes: LRU 0, flush list 0, single page 0
  963. Pages made young 781, not young 0
  964. 0.00 youngs/s, 0.00 non-youngs/s
  965. Pages read 23611, created 6067, written 1022239
  966. 0.00 reads/s, 0.03 creates/s, 0.00 writes/s
  967. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  968. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  969. LRU len: 29678, unzip_LRU len: 0
  970. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  971. ---BUFFER POOL 2
  972. Buffer pool size 65536
  973. Free buffers 32518
  974. Database pages 29682
  975. Old database pages 10936
  976. Modified db pages 739
  977. Percent of dirty pages(LRU & free pages): 1.188
  978. Max dirty pages percent: 75.000
  979. Pending reads 0
  980. Pending writes: LRU 0, flush list 0, single page 0
  981. Pages made young 846, not young 0
  982. 0.00 youngs/s, 0.00 non-youngs/s
  983. Pages read 24146, created 5536, written 2448726
  984. 0.00 reads/s, 0.03 creates/s, 0.00 writes/s
  985. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  986. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  987. LRU len: 29682, unzip_LRU len: 0
  988. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  989. ---BUFFER POOL 3
  990. Buffer pool size 65536
  991. Free buffers 31975
  992. Database pages 30295
  993. Old database pages 11163
  994. Modified db pages 812
  995. Percent of dirty pages(LRU & free pages): 1.304
  996. Max dirty pages percent: 75.000
  997. Pending reads 0
  998. Pending writes: LRU 0, flush list 0, single page 0
  999. Pages made young 732, not young 0
  1000. 0.00 youngs/s, 0.00 non-youngs/s
  1001. Pages read 24659, created 5636, written 6332926
  1002. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1003. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1004. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1005. LRU len: 30295, unzip_LRU len: 0
  1006. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1007. ---BUFFER POOL 4
  1008. Buffer pool size 65536
  1009. Free buffers 31759
  1010. Database pages 30522
  1011. Old database pages 11246
  1012. Modified db pages 599
  1013. Percent of dirty pages(LRU & free pages): 0.962
  1014. Max dirty pages percent: 75.000
  1015. Pending reads 0
  1016. Pending writes: LRU 0, flush list 0, single page 0
  1017. Pages made young 898, not young 0
  1018. 0.00 youngs/s, 0.00 non-youngs/s
  1019. Pages read 25059, created 5463, written 4586167
  1020. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1021. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1022. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1023. LRU len: 30522, unzip_LRU len: 0
  1024. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1025. ---BUFFER POOL 5
  1026. Buffer pool size 65536
  1027. Free buffers 32600
  1028. Database pages 29746
  1029. Old database pages 10960
  1030. Modified db pages 663
  1031. Percent of dirty pages(LRU & free pages): 1.063
  1032. Max dirty pages percent: 75.000
  1033. Pending reads 0
  1034. Pending writes: LRU 0, flush list 0, single page 0
  1035. Pages made young 827, not young 0
  1036. 0.00 youngs/s, 0.00 non-youngs/s
  1037. Pages read 23823, created 5923, written 2255964
  1038. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1039. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1040. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1041. LRU len: 29746, unzip_LRU len: 0
  1042. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1043. --------------
  1044. ROW OPERATIONS
  1045. --------------
  1046. 0 queries inside InnoDB, 0 queries in queue
  1047. 0 read views open inside InnoDB
  1048. Process ID=105331, Main thread ID=140286846228224, state: sleeping
  1049. Number of rows inserted 2791251, updated 31696878, deleted 22883, read 28039624032
  1050. 5.10 inserts/s, 38.39 updates/s, 0.03 deletes/s, 28084.03 reads/s
  1051. Number of system rows inserted 0, updated 0, deleted 0, read 0
  1052. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  1053. ----------------------------
  1054. END OF INNODB MONITOR OUTPUT
  1055. ============================
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!