API tools faq
paste
Advertisement
SebastianBTS

SHOW ENGINE INNODB STATUS; (load)

SebastianBTS
Apr 14th, 2022
77
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 79.55 KB | None | 0 0
raw download clone embed print report
  1. | InnoDB | |
  2. =====================================
  3. 2022-04-14 14:53:57 0x14666b86b700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 39 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 1228821 srv_active, 0 srv_shutdown, 205 srv_idle
  10. srv_master_thread log flush and writes: 1229026
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 1884755
  15. OS WAIT ARRAY INFO: signal count 11171703
  16. RW-shared spins 0, rounds 5184518, OS waits 612256
  17. RW-excl spins 0, rounds 59123170, OS waits 964754
  18. RW-sx spins 45445, rounds 628055, OS waits 14655
  19. Spin rounds per wait: 5184518.00 RW-shared, 59123170.00 RW-excl, 13.82 RW-sx
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 10788796
  24. Purge done for trx's n:o < 10788770 undo n:o < 0 state: running but idle
  25. History list length 0
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 303910384457800, not started
  28. 0 lock struct(s), heap size 1136, 0 row lock(s)
  29. ---TRANSACTION 303910384455040, not started
  30. 0 lock struct(s), heap size 1136, 0 row lock(s)
  31. ---TRANSACTION 303910384333600, not started
  32. 0 lock struct(s), heap size 1136, 0 row lock(s)
  33. ---TRANSACTION 303910384444920, not started
  34. 0 lock struct(s), heap size 1136, 0 row lock(s)
  35. ---TRANSACTION 303910384342800, not started
  36. 0 lock struct(s), heap size 1136, 0 row lock(s)
  37. ---TRANSACTION 303910384678600, not started
  38. 0 lock struct(s), heap size 1136, 0 row lock(s)
  39. ---TRANSACTION 303910384585680, not started
  40. 0 lock struct(s), heap size 1136, 0 row lock(s)
  41. ---TRANSACTION 303910384675840, not started
  42. 0 lock struct(s), heap size 1136, 0 row lock(s)
  43. ---TRANSACTION 303910384674920, not started
  44. 0 lock struct(s), heap size 1136, 0 row lock(s)
  45. ---TRANSACTION 303910384673080, not started
  46. 0 lock struct(s), heap size 1136, 0 row lock(s)
  47. ---TRANSACTION 303910384672160, not started
  48. 0 lock struct(s), heap size 1136, 0 row lock(s)
  49. ---TRANSACTION 303910384671240, not started
  50. 0 lock struct(s), heap size 1136, 0 row lock(s)
  51. ---TRANSACTION 303910384670320, not started
  52. 0 lock struct(s), heap size 1136, 0 row lock(s)
  53. ---TRANSACTION 303910384668480, not started
  54. 0 lock struct(s), heap size 1136, 0 row lock(s)
  55. ---TRANSACTION 303910384666640, not started
  56. 0 lock struct(s), heap size 1136, 0 row lock(s)
  57. ---TRANSACTION 303910384667560, not started
  58. 0 lock struct(s), heap size 1136, 0 row lock(s)
  59. ---TRANSACTION 303910384665720, not started
  60. 0 lock struct(s), heap size 1136, 0 row lock(s)
  61. ---TRANSACTION 303910384664800, not started
  62. 0 lock struct(s), heap size 1136, 0 row lock(s)
  63. ---TRANSACTION 303910384662960, not started
  64. 0 lock struct(s), heap size 1136, 0 row lock(s)
  65. ---TRANSACTION 303910384662040, not started
  66. 0 lock struct(s), heap size 1136, 0 row lock(s)
  67. ---TRANSACTION 303910384661120, not started
  68. 0 lock struct(s), heap size 1136, 0 row lock(s)
  69. ---TRANSACTION 303910384659280, not started
  70. 0 lock struct(s), heap size 1136, 0 row lock(s)
  71. ---TRANSACTION 303910384658360, not started
  72. 0 lock struct(s), heap size 1136, 0 row lock(s)
  73. ---TRANSACTION 303910384657440, not started
  74. 0 lock struct(s), heap size 1136, 0 row lock(s)
  75. ---TRANSACTION 303910384655600, not started
  76. 0 lock struct(s), heap size 1136, 0 row lock(s)
  77. ---TRANSACTION 303910384654680, not started
  78. 0 lock struct(s), heap size 1136, 0 row lock(s)
  79. ---TRANSACTION 303910384653760, not started
  80. 0 lock struct(s), heap size 1136, 0 row lock(s)
  81. ---TRANSACTION 303910384652840, not started
  82. 0 lock struct(s), heap size 1136, 0 row lock(s)
  83. ---TRANSACTION 303910384651920, not started
  84. 0 lock struct(s), heap size 1136, 0 row lock(s)
  85. ---TRANSACTION 303910384651000, not started
  86. 0 lock struct(s), heap size 1136, 0 row lock(s)
  87. ---TRANSACTION 303910384650080, not started
  88. 0 lock struct(s), heap size 1136, 0 row lock(s)
  89. ---TRANSACTION 303910384649160, not started
  90. 0 lock struct(s), heap size 1136, 0 row lock(s)
  91. ---TRANSACTION 303910384648240, not started
  92. 0 lock struct(s), heap size 1136, 0 row lock(s)
  93. ---TRANSACTION 303910384647320, not started
  94. 0 lock struct(s), heap size 1136, 0 row lock(s)
  95. ---TRANSACTION 303910384646400, not started
  96. 0 lock struct(s), heap size 1136, 0 row lock(s)
  97. ---TRANSACTION 303910384644560, not started
  98. 0 lock struct(s), heap size 1136, 0 row lock(s)
  99. ---TRANSACTION 303910384643640, not started
  100. 0 lock struct(s), heap size 1136, 0 row lock(s)
  101. ---TRANSACTION 303910384642720, not started
  102. 0 lock struct(s), heap size 1136, 0 row lock(s)
  103. ---TRANSACTION 303910384641800, not started
  104. 0 lock struct(s), heap size 1136, 0 row lock(s)
  105. ---TRANSACTION 303910384640880, not started
  106. 0 lock struct(s), heap size 1136, 0 row lock(s)
  107. ---TRANSACTION 303910384639040, not started
  108. 0 lock struct(s), heap size 1136, 0 row lock(s)
  109. ---TRANSACTION 303910384639960, not started
  110. 0 lock struct(s), heap size 1136, 0 row lock(s)
  111. ---TRANSACTION 303910384638120, not started
  112. 0 lock struct(s), heap size 1136, 0 row lock(s)
  113. ---TRANSACTION 303910384636280, not started
  114. 0 lock struct(s), heap size 1136, 0 row lock(s)
  115. ---TRANSACTION 303910384635360, not started
  116. 0 lock struct(s), heap size 1136, 0 row lock(s)
  117. ---TRANSACTION 303910384634440, not started
  118. 0 lock struct(s), heap size 1136, 0 row lock(s)
  119. ---TRANSACTION 303910384633520, not started
  120. 0 lock struct(s), heap size 1136, 0 row lock(s)
  121. ---TRANSACTION 303910384632600, not started
  122. 0 lock struct(s), heap size 1136, 0 row lock(s)
  123. ---TRANSACTION 303910384631680, not started
  124. 0 lock struct(s), heap size 1136, 0 row lock(s)
  125. ---TRANSACTION 303910384630760, not started
  126. 0 lock struct(s), heap size 1136, 0 row lock(s)
  127. ---TRANSACTION 303910384628920, not started
  128. 0 lock struct(s), heap size 1136, 0 row lock(s)
  129. ---TRANSACTION 303910384628000, not started
  130. 0 lock struct(s), heap size 1136, 0 row lock(s)
  131. ---TRANSACTION 303910384627080, not started
  132. 0 lock struct(s), heap size 1136, 0 row lock(s)
  133. ---TRANSACTION 303910384624320, not started
  134. 0 lock struct(s), heap size 1136, 0 row lock(s)
  135. ---TRANSACTION 303910384623400, not started
  136. 0 lock struct(s), heap size 1136, 0 row lock(s)
  137. ---TRANSACTION 303910384622480, not started
  138. 0 lock struct(s), heap size 1136, 0 row lock(s)
  139. ---TRANSACTION 303910384621560, not started
  140. 0 lock struct(s), heap size 1136, 0 row lock(s)
  141. ---TRANSACTION 303910384620640, not started
  142. 0 lock struct(s), heap size 1136, 0 row lock(s)
  143. ---TRANSACTION 303910384618800, not started
  144. 0 lock struct(s), heap size 1136, 0 row lock(s)
  145. ---TRANSACTION 303910384616040, not started
  146. 0 lock struct(s), heap size 1136, 0 row lock(s)
  147. ---TRANSACTION 303910384607760, not started
  148. 0 lock struct(s), heap size 1136, 0 row lock(s)
  149. ---TRANSACTION 303910384605000, not started
  150. 0 lock struct(s), heap size 1136, 0 row lock(s)
  151. ---TRANSACTION 303910384601320, not started
  152. 0 lock struct(s), heap size 1136, 0 row lock(s)
  153. ---TRANSACTION 303910384595800, not started
  154. 0 lock struct(s), heap size 1136, 0 row lock(s)
  155. ---TRANSACTION 303910384594880, not started
  156. 0 lock struct(s), heap size 1136, 0 row lock(s)
  157. ---TRANSACTION 303910384593960, not started
  158. 0 lock struct(s), heap size 1136, 0 row lock(s)
  159. ---TRANSACTION 303910384592120, not started
  160. 0 lock struct(s), heap size 1136, 0 row lock(s)
  161. ---TRANSACTION 303910384591200, not started
  162. 0 lock struct(s), heap size 1136, 0 row lock(s)
  163. ---TRANSACTION 303910384586600, not started
  164. 0 lock struct(s), heap size 1136, 0 row lock(s)
  165. ---TRANSACTION 303910384584760, not started
  166. 0 lock struct(s), heap size 1136, 0 row lock(s)
  167. ---TRANSACTION 303910384583840, not started
  168. 0 lock struct(s), heap size 1136, 0 row lock(s)
  169. ---TRANSACTION 303910384582920, not started
  170. 0 lock struct(s), heap size 1136, 0 row lock(s)
  171. ---TRANSACTION 303910384580160, not started
  172. 0 lock struct(s), heap size 1136, 0 row lock(s)
  173. ---TRANSACTION 303910384573720, not started
  174. 0 lock struct(s), heap size 1136, 0 row lock(s)
  175. ---TRANSACTION 303910384570960, not started
  176. 0 lock struct(s), heap size 1136, 0 row lock(s)
  177. ---TRANSACTION 303910384570040, not started
  178. 0 lock struct(s), heap size 1136, 0 row lock(s)
  179. ---TRANSACTION 303910384567280, not started
  180. 0 lock struct(s), heap size 1136, 0 row lock(s)
  181. ---TRANSACTION 303910384566360, not started
  182. 0 lock struct(s), heap size 1136, 0 row lock(s)
  183. ---TRANSACTION 303910384565440, not started
  184. 0 lock struct(s), heap size 1136, 0 row lock(s)
  185. ---TRANSACTION 303910384562680, not started
  186. 0 lock struct(s), heap size 1136, 0 row lock(s)
  187. ---TRANSACTION 303910384561760, not started
  188. 0 lock struct(s), heap size 1136, 0 row lock(s)
  189. ---TRANSACTION 303910384559000, not started
  190. 0 lock struct(s), heap size 1136, 0 row lock(s)
  191. ---TRANSACTION 303910384557160, not started
  192. 0 lock struct(s), heap size 1136, 0 row lock(s)
  193. ---TRANSACTION 303910384556240, not started
  194. 0 lock struct(s), heap size 1136, 0 row lock(s)
  195. ---TRANSACTION 303910384554400, not started
  196. 0 lock struct(s), heap size 1136, 0 row lock(s)
  197. ---TRANSACTION 303910384553480, not started
  198. 0 lock struct(s), heap size 1136, 0 row lock(s)
  199. ---TRANSACTION 303910384552560, not started
  200. 0 lock struct(s), heap size 1136, 0 row lock(s)
  201. ---TRANSACTION 303910384551640, not started
  202. 0 lock struct(s), heap size 1136, 0 row lock(s)
  203. ---TRANSACTION 303910384550720, not started
  204. 0 lock struct(s), heap size 1136, 0 row lock(s)
  205. ---TRANSACTION 303910384489080, not started
  206. 0 lock struct(s), heap size 1136, 0 row lock(s)
  207. ---TRANSACTION 303910384433880, not started
  208. 0 lock struct(s), heap size 1136, 0 row lock(s)
  209. ---TRANSACTION 303910384372240, not started
  210. 0 lock struct(s), heap size 1136, 0 row lock(s)
  211. ---TRANSACTION 303910384327160, not started
  212. 0 lock struct(s), heap size 1136, 0 row lock(s)
  213. ---TRANSACTION 303910384420080, not started
  214. 0 lock struct(s), heap size 1136, 0 row lock(s)
  215. ---TRANSACTION 303910384547040, not started
  216. 0 lock struct(s), heap size 1136, 0 row lock(s)
  217. ---TRANSACTION 303910384535080, not started
  218. 0 lock struct(s), heap size 1136, 0 row lock(s)
  219. ---TRANSACTION 303910384522200, not started
  220. 0 lock struct(s), heap size 1136, 0 row lock(s)
  221. ---TRANSACTION 303910384475280, not started
  222. 0 lock struct(s), heap size 1136, 0 row lock(s)
  223. ---TRANSACTION 303910384446760, not started
  224. 0 lock struct(s), heap size 1136, 0 row lock(s)
  225. ---TRANSACTION 303910384439400, not started
  226. 0 lock struct(s), heap size 1136, 0 row lock(s)
  227. ---TRANSACTION 303910384379600, not started
  228. 0 lock struct(s), heap size 1136, 0 row lock(s)
  229. ---TRANSACTION 303910384365800, not started
  230. 0 lock struct(s), heap size 1136, 0 row lock(s)
  231. ---TRANSACTION 303910384416400, not started
  232. 0 lock struct(s), heap size 1136, 0 row lock(s)
  233. ---TRANSACTION 303910384377760, not started
  234. 0 lock struct(s), heap size 1136, 0 row lock(s)
  235. ---TRANSACTION 303910384549800, not started
  236. 0 lock struct(s), heap size 1136, 0 row lock(s)
  237. ---TRANSACTION 303910384471600, not started
  238. 0 lock struct(s), heap size 1136, 0 row lock(s)
  239. ---TRANSACTION 303910384507480, not started
  240. 0 lock struct(s), heap size 1136, 0 row lock(s)
  241. ---TRANSACTION 303910384376840, not started
  242. 0 lock struct(s), heap size 1136, 0 row lock(s)
  243. ---TRANSACTION 303910384548880, not started
  244. 0 lock struct(s), heap size 1136, 0 row lock(s)
  245. ---TRANSACTION 303910384546120, not started
  246. 0 lock struct(s), heap size 1136, 0 row lock(s)
  247. ---TRANSACTION 303910384351080, not started
  248. 0 lock struct(s), heap size 1136, 0 row lock(s)
  249. ---TRANSACTION 303910384491840, not started
  250. 0 lock struct(s), heap size 1136, 0 row lock(s)
  251. ---TRANSACTION 303910384543360, not started
  252. 0 lock struct(s), heap size 1136, 0 row lock(s)
  253. ---TRANSACTION 303910384542440, not started
  254. 0 lock struct(s), heap size 1136, 0 row lock(s)
  255. ---TRANSACTION 303910384501040, not started
  256. 0 lock struct(s), heap size 1136, 0 row lock(s)
  257. ---TRANSACTION 303910384510240, not started
  258. 0 lock struct(s), heap size 1136, 0 row lock(s)
  259. ---TRANSACTION 303910384504720, not started
  260. 0 lock struct(s), heap size 1136, 0 row lock(s)
  261. ---TRANSACTION 303910384498280, not started
  262. 0 lock struct(s), heap size 1136, 0 row lock(s)
  263. ---TRANSACTION 303910384483560, not started
  264. 0 lock struct(s), heap size 1136, 0 row lock(s)
  265. ---TRANSACTION 303910384465160, not started
  266. 0 lock struct(s), heap size 1136, 0 row lock(s)
  267. ---TRANSACTION 303910384435720, not started
  268. 0 lock struct(s), heap size 1136, 0 row lock(s)
  269. ---TRANSACTION 303910384427440, not started
  270. 0 lock struct(s), heap size 1136, 0 row lock(s)
  271. ---TRANSACTION 303910384407200, not started
  272. 0 lock struct(s), heap size 1136, 0 row lock(s)
  273. ---TRANSACTION 303910384331760, not started
  274. 0 lock struct(s), heap size 1136, 0 row lock(s)
  275. ---TRANSACTION 303910384340040, not started
  276. 0 lock struct(s), heap size 1136, 0 row lock(s)
  277. ---TRANSACTION 303910384356600, not started
  278. 0 lock struct(s), heap size 1136, 0 row lock(s)
  279. ---TRANSACTION 303910384336360, not started
  280. 0 lock struct(s), heap size 1136, 0 row lock(s)
  281. ---TRANSACTION 303910384343720, not started
  282. 0 lock struct(s), heap size 1136, 0 row lock(s)
  283. ---TRANSACTION 303910384326240, not started
  284. 0 lock struct(s), heap size 1136, 0 row lock(s)
  285. ---TRANSACTION 303910384350160, not started
  286. 0 lock struct(s), heap size 1136, 0 row lock(s)
  287. ---TRANSACTION 303910384487240, not started
  288. 0 lock struct(s), heap size 1136, 0 row lock(s)
  289. ---TRANSACTION 303910384438480, not started
  290. 0 lock struct(s), heap size 1136, 0 row lock(s)
  291. ---TRANSACTION 303910384537840, not started
  292. 0 lock struct(s), heap size 1136, 0 row lock(s)
  293. ---TRANSACTION 303910384329920, not started
  294. 0 lock struct(s), heap size 1136, 0 row lock(s)
  295. ---TRANSACTION 303910384495520, not started
  296. 0 lock struct(s), heap size 1136, 0 row lock(s)
  297. ---TRANSACTION 303910384494600, not started
  298. 0 lock struct(s), heap size 1136, 0 row lock(s)
  299. ---TRANSACTION 303910384369480, not started
  300. 0 lock struct(s), heap size 1136, 0 row lock(s)
  301. ---TRANSACTION 303910384534160, not started
  302. 0 lock struct(s), heap size 1136, 0 row lock(s)
  303. ---TRANSACTION 303910384533240, not started
  304. 0 lock struct(s), heap size 1136, 0 row lock(s)
  305. ---TRANSACTION 303910384531400, not started
  306. 0 lock struct(s), heap size 1136, 0 row lock(s)
  307. ---TRANSACTION 303910384529560, not started
  308. 0 lock struct(s), heap size 1136, 0 row lock(s)
  309. ---TRANSACTION 303910384525880, not started
  310. 0 lock struct(s), heap size 1136, 0 row lock(s)
  311. ---TRANSACTION 303910384519440, not started
  312. 0 lock struct(s), heap size 1136, 0 row lock(s)
  313. ---TRANSACTION 303910384518520, not started
  314. 0 lock struct(s), heap size 1136, 0 row lock(s)
  315. ---TRANSACTION 303910384517600, not started
  316. 0 lock struct(s), heap size 1136, 0 row lock(s)
  317. ---TRANSACTION 303910384515760, not started
  318. 0 lock struct(s), heap size 1136, 0 row lock(s)
  319. ---TRANSACTION 303910384514840, not started
  320. 0 lock struct(s), heap size 1136, 0 row lock(s)
  321. ---TRANSACTION 303910384423760, not started
  322. 0 lock struct(s), heap size 1136, 0 row lock(s)
  323. ---TRANSACTION 303910384513000, not started
  324. 0 lock struct(s), heap size 1136, 0 row lock(s)
  325. ---TRANSACTION 303910384478040, not started
  326. 0 lock struct(s), heap size 1136, 0 row lock(s)
  327. ---TRANSACTION 303910384385120, not started
  328. 0 lock struct(s), heap size 1136, 0 row lock(s)
  329. ---TRANSACTION 303910384408120, not started
  330. 0 lock struct(s), heap size 1136, 0 row lock(s)
  331. ---TRANSACTION 303910384352920, not started
  332. 0 lock struct(s), heap size 1136, 0 row lock(s)
  333. ---TRANSACTION 303910384508400, not started
  334. 0 lock struct(s), heap size 1136, 0 row lock(s)
  335. ---TRANSACTION 303910384411800, not started
  336. 0 lock struct(s), heap size 1136, 0 row lock(s)
  337. ---TRANSACTION 303910384506560, not started
  338. 0 lock struct(s), heap size 1136, 0 row lock(s)
  339. ---TRANSACTION 303910384505640, not started
  340. 0 lock struct(s), heap size 1136, 0 row lock(s)
  341. ---TRANSACTION 303910384496440, not started
  342. 0 lock struct(s), heap size 1136, 0 row lock(s)
  343. ---TRANSACTION 303910384358440, not started
  344. 0 lock struct(s), heap size 1136, 0 row lock(s)
  345. ---TRANSACTION 303910384493680, not started
  346. 0 lock struct(s), heap size 1136, 0 row lock(s)
  347. ---TRANSACTION 303910384480800, not started
  348. 0 lock struct(s), heap size 1136, 0 row lock(s)
  349. ---TRANSACTION 303910384462400, not started
  350. 0 lock struct(s), heap size 1136, 0 row lock(s)
  351. ---TRANSACTION 303910384460560, not started
  352. 0 lock struct(s), heap size 1136, 0 row lock(s)
  353. ---TRANSACTION 303910384381440, not started
  354. 0 lock struct(s), heap size 1136, 0 row lock(s)
  355. ---TRANSACTION 303910384329000, not started
  356. 0 lock struct(s), heap size 1136, 0 row lock(s)
  357. ---TRANSACTION 303910384436640, not started
  358. 0 lock struct(s), heap size 1136, 0 row lock(s)
  359. ---TRANSACTION 303910384400760, not started
  360. 0 lock struct(s), heap size 1136, 0 row lock(s)
  361. ---TRANSACTION 303910384387880, not started
  362. 0 lock struct(s), heap size 1136, 0 row lock(s)
  363. ---TRANSACTION 303910384399840, not started
  364. 0 lock struct(s), heap size 1136, 0 row lock(s)
  365. ---TRANSACTION 303910384364880, not started
  366. 0 lock struct(s), heap size 1136, 0 row lock(s)
  367. ---TRANSACTION 303910384360280, not started
  368. 0 lock struct(s), heap size 1136, 0 row lock(s)
  369. ---TRANSACTION 303910384332680, not started
  370. 0 lock struct(s), heap size 1136, 0 row lock(s)
  371. ---TRANSACTION 303910384340960, not started
  372. 0 lock struct(s), heap size 1136, 0 row lock(s)
  373. ---TRANSACTION 303910384353840, not started
  374. 0 lock struct(s), heap size 1136, 0 row lock(s)
  375. ---TRANSACTION 303910384467000, not started
  376. 0 lock struct(s), heap size 1136, 0 row lock(s)
  377. ---TRANSACTION 303910384321640, not started
  378. 0 lock struct(s), heap size 1136, 0 row lock(s)
  379. ---TRANSACTION 303910384312440, not started
  380. 0 lock struct(s), heap size 1136, 0 row lock(s)
  381. ---TRANSACTION 303910384392480, not started
  382. 0 lock struct(s), heap size 1136, 0 row lock(s)
  383. ---TRANSACTION 303910384403520, not started
  384. 0 lock struct(s), heap size 1136, 0 row lock(s)
  385. ---TRANSACTION 303910384390640, not started
  386. 0 lock struct(s), heap size 1136, 0 row lock(s)
  387. ---TRANSACTION 303910384370400, not started
  388. 0 lock struct(s), heap size 1136, 0 row lock(s)
  389. ---TRANSACTION 303910384486320, not started
  390. 0 lock struct(s), heap size 1136, 0 row lock(s)
  391. ---TRANSACTION 303910384463320, not started
  392. 0 lock struct(s), heap size 1136, 0 row lock(s)
  393. ---TRANSACTION 303910384424680, not started
  394. 0 lock struct(s), heap size 1136, 0 row lock(s)
  395. ---TRANSACTION 303910384402600, not started
  396. 0 lock struct(s), heap size 1136, 0 row lock(s)
  397. ---TRANSACTION 303910384502880, not started
  398. 0 lock struct(s), heap size 1136, 0 row lock(s)
  399. ---TRANSACTION 303910384410880, not started
  400. 0 lock struct(s), heap size 1136, 0 row lock(s)
  401. ---TRANSACTION 303910384404440, not started
  402. 0 lock struct(s), heap size 1136, 0 row lock(s)
  403. ---TRANSACTION 303910384380520, not started
  404. 0 lock struct(s), heap size 1136, 0 row lock(s)
  405. ---TRANSACTION 303910384485400, not started
  406. 0 lock struct(s), heap size 1136, 0 row lock(s)
  407. ---TRANSACTION 303910384319800, not started
  408. 0 lock struct(s), heap size 1136, 0 row lock(s)
  409. ---TRANSACTION 303910384434800, not started
  410. 0 lock struct(s), heap size 1136, 0 row lock(s)
  411. ---TRANSACTION 303910384473440, not started
  412. 0 lock struct(s), heap size 1136, 0 row lock(s)
  413. ---TRANSACTION 303910384461480, not started
  414. 0 lock struct(s), heap size 1136, 0 row lock(s)
  415. ---TRANSACTION 303910384395240, not started
  416. 0 lock struct(s), heap size 1136, 0 row lock(s)
  417. ---TRANSACTION 303910384355680, not started
  418. 0 lock struct(s), heap size 1136, 0 row lock(s)
  419. ---TRANSACTION 303910384337280, not started
  420. 0 lock struct(s), heap size 1136, 0 row lock(s)
  421. ---TRANSACTION 303910384442160, not started
  422. 0 lock struct(s), heap size 1136, 0 row lock(s)
  423. ---TRANSACTION 303910384430200, not started
  424. 0 lock struct(s), heap size 1136, 0 row lock(s)
  425. ---TRANSACTION 303910384314280, not started
  426. 0 lock struct(s), heap size 1136, 0 row lock(s)
  427. ---TRANSACTION 303910384374080, not started
  428. 0 lock struct(s), heap size 1136, 0 row lock(s)
  429. ---TRANSACTION 303910384453200, not started
  430. 0 lock struct(s), heap size 1136, 0 row lock(s)
  431. ---TRANSACTION 303910384428360, not started
  432. 0 lock struct(s), heap size 1136, 0 row lock(s)
  433. ---TRANSACTION 303910384425600, not started
  434. 0 lock struct(s), heap size 1136, 0 row lock(s)
  435. ---TRANSACTION 303910384405360, not started
  436. 0 lock struct(s), heap size 1136, 0 row lock(s)
  437. ---TRANSACTION 303910384417320, not started
  438. 0 lock struct(s), heap size 1136, 0 row lock(s)
  439. ---TRANSACTION 303910384447680, not started
  440. 0 lock struct(s), heap size 1136, 0 row lock(s)
  441. ---TRANSACTION 303910384309680, not started
  442. 0 lock struct(s), heap size 1136, 0 row lock(s)
  443. ---TRANSACTION 303910384345560, not started
  444. 0 lock struct(s), heap size 1136, 0 row lock(s)
  445. ---TRANSACTION 303910384469760, not started
  446. 0 lock struct(s), heap size 1136, 0 row lock(s)
  447. ---TRANSACTION 303910384393400, not started
  448. 0 lock struct(s), heap size 1136, 0 row lock(s)
  449. ---TRANSACTION 303910384528640, not started
  450. 0 lock struct(s), heap size 1136, 0 row lock(s)
  451. ---TRANSACTION 303910384527720, not started
  452. 0 lock struct(s), heap size 1136, 0 row lock(s)
  453. ---TRANSACTION 303910384500120, not started
  454. 0 lock struct(s), heap size 1136, 0 row lock(s)
  455. ---TRANSACTION 303910384459640, not started
  456. 0 lock struct(s), heap size 1136, 0 row lock(s)
  457. ---TRANSACTION 303910384490000, not started
  458. 0 lock struct(s), heap size 1136, 0 row lock(s)
  459. ---TRANSACTION 303910384440320, not started
  460. 0 lock struct(s), heap size 1136, 0 row lock(s)
  461. ---TRANSACTION 303910384421000, not started
  462. 0 lock struct(s), heap size 1136, 0 row lock(s)
  463. ---TRANSACTION 303910384388800, not started
  464. 0 lock struct(s), heap size 1136, 0 row lock(s)
  465. ---TRANSACTION 303910384384200, not started
  466. 0 lock struct(s), heap size 1136, 0 row lock(s)
  467. ---TRANSACTION 303910384352000, not started
  468. 0 lock struct(s), heap size 1136, 0 row lock(s)
  469. ---TRANSACTION 303910384375000, not started
  470. 0 lock struct(s), heap size 1136, 0 row lock(s)
  471. ---TRANSACTION 303910384375920, not started
  472. 0 lock struct(s), heap size 1136, 0 row lock(s)
  473. ---TRANSACTION 303910384357520, not started
  474. 0 lock struct(s), heap size 1136, 0 row lock(s)
  475. ---TRANSACTION 303910384341880, not started
  476. 0 lock struct(s), heap size 1136, 0 row lock(s)
  477. ---TRANSACTION 303910384347400, not started
  478. 0 lock struct(s), heap size 1136, 0 row lock(s)
  479. ---TRANSACTION 303910384330840, not started
  480. 0 lock struct(s), heap size 1136, 0 row lock(s)
  481. ---TRANSACTION 303910384383280, not started
  482. 0 lock struct(s), heap size 1136, 0 row lock(s)
  483. ---TRANSACTION 303910384412720, not started
  484. 0 lock struct(s), heap size 1136, 0 row lock(s)
  485. ---TRANSACTION 303910384503800, not started
  486. 0 lock struct(s), heap size 1136, 0 row lock(s)
  487. ---TRANSACTION 303910384339120, not started
  488. 0 lock struct(s), heap size 1136, 0 row lock(s)
  489. ---TRANSACTION 303910384391560, not started
  490. 0 lock struct(s), heap size 1136, 0 row lock(s)
  491. ---TRANSACTION 303910384582000, not started
  492. 0 lock struct(s), heap size 1136, 0 row lock(s)
  493. ---TRANSACTION 303910384396160, not started
  494. 0 lock struct(s), heap size 1136, 0 row lock(s)
  495. ---TRANSACTION 303910384558080, not started
  496. 0 lock struct(s), heap size 1136, 0 row lock(s)
  497. ---TRANSACTION 303910384555320, not started
  498. 0 lock struct(s), heap size 1136, 0 row lock(s)
  499. ---TRANSACTION 303910384521280, not started
  500. 0 lock struct(s), heap size 1136, 0 row lock(s)
  501. ---TRANSACTION 303910384316120, not started
  502. 0 lock struct(s), heap size 1136, 0 row lock(s)
  503. ---TRANSACTION 303910384614200, not started
  504. 0 lock struct(s), heap size 1136, 0 row lock(s)
  505. ---TRANSACTION 303910384611440, not started
  506. 0 lock struct(s), heap size 1136, 0 row lock(s)
  507. ---TRANSACTION 303910384488160, not started
  508. 0 lock struct(s), heap size 1136, 0 row lock(s)
  509. ---TRANSACTION 303910384484480, not started
  510. 0 lock struct(s), heap size 1136, 0 row lock(s)
  511. ---TRANSACTION 303910384450440, not started
  512. 0 lock struct(s), heap size 1136, 0 row lock(s)
  513. ---TRANSACTION 303910384571880, not started
  514. 0 lock struct(s), heap size 1136, 0 row lock(s)
  515. ---TRANSACTION 303910384497360, not started
  516. 0 lock struct(s), heap size 1136, 0 row lock(s)
  517. ---TRANSACTION 303910384437560, not started
  518. 0 lock struct(s), heap size 1136, 0 row lock(s)
  519. ---TRANSACTION 303910384609600, not started
  520. 0 lock struct(s), heap size 1136, 0 row lock(s)
  521. ---TRANSACTION 303910384602240, not started
  522. 0 lock struct(s), heap size 1136, 0 row lock(s)
  523. ---TRANSACTION 303910384581080, not started
  524. 0 lock struct(s), heap size 1136, 0 row lock(s)
  525. ---TRANSACTION 303910384378680, not started
  526. 0 lock struct(s), heap size 1136, 0 row lock(s)
  527. ---TRANSACTION 303910384432040, not started
  528. 0 lock struct(s), heap size 1136, 0 row lock(s)
  529. ---TRANSACTION 303910384361200, not started
  530. 0 lock struct(s), heap size 1136, 0 row lock(s)
  531. ---TRANSACTION 303910384532320, not started
  532. 0 lock struct(s), heap size 1136, 0 row lock(s)
  533. ---TRANSACTION 303910384431120, not started
  534. 0 lock struct(s), heap size 1136, 0 row lock(s)
  535. ---TRANSACTION 303910384406280, not started
  536. 0 lock struct(s), heap size 1136, 0 row lock(s)
  537. ---TRANSACTION 303910384563600, not started
  538. 0 lock struct(s), heap size 1136, 0 row lock(s)
  539. ---TRANSACTION 303910384490920, not started
  540. 0 lock struct(s), heap size 1136, 0 row lock(s)
  541. ---TRANSACTION 303910384409960, not started
  542. 0 lock struct(s), heap size 1136, 0 row lock(s)
  543. ---TRANSACTION 303910384605920, not started
  544. 0 lock struct(s), heap size 1136, 0 row lock(s)
  545. ---TRANSACTION 303910384575560, not started
  546. 0 lock struct(s), heap size 1136, 0 row lock(s)
  547. ---TRANSACTION 303910384530480, not started
  548. 0 lock struct(s), heap size 1136, 0 row lock(s)
  549. ---TRANSACTION 303910384373160, not started
  550. 0 lock struct(s), heap size 1136, 0 row lock(s)
  551. ---TRANSACTION 303910384359360, not started
  552. 0 lock struct(s), heap size 1136, 0 row lock(s)
  553. ---TRANSACTION 303910384422840, not started
  554. 0 lock struct(s), heap size 1136, 0 row lock(s)
  555. ---TRANSACTION 303910384418240, not started
  556. 0 lock struct(s), heap size 1136, 0 row lock(s)
  557. ---TRANSACTION 303910384328080, not started
  558. 0 lock struct(s), heap size 1136, 0 row lock(s)
  559. ---TRANSACTION 303910384511160, not started
  560. 0 lock struct(s), heap size 1136, 0 row lock(s)
  561. ---TRANSACTION 303910384451360, not started
  562. 0 lock struct(s), heap size 1136, 0 row lock(s)
  563. ---TRANSACTION 303910384454120, not started
  564. 0 lock struct(s), heap size 1136, 0 row lock(s)
  565. ---TRANSACTION 303910384349240, not started
  566. 0 lock struct(s), heap size 1136, 0 row lock(s)
  567. ---TRANSACTION 303910384368560, not started
  568. 0 lock struct(s), heap size 1136, 0 row lock(s)
  569. ---TRANSACTION 303910384499200, not started
  570. 0 lock struct(s), heap size 1136, 0 row lock(s)
  571. ---TRANSACTION 303910384598560, not started
  572. 0 lock struct(s), heap size 1136, 0 row lock(s)
  573. ---TRANSACTION 303910384597640, not started
  574. 0 lock struct(s), heap size 1136, 0 row lock(s)
  575. ---TRANSACTION 303910384596720, not started
  576. 0 lock struct(s), heap size 1136, 0 row lock(s)
  577. ---TRANSACTION 303910384456880, not started
  578. 0 lock struct(s), heap size 1136, 0 row lock(s)
  579. ---TRANSACTION 303910384492760, not started
  580. 0 lock struct(s), heap size 1136, 0 row lock(s)
  581. ---TRANSACTION 303910384576480, not started
  582. 0 lock struct(s), heap size 1136, 0 row lock(s)
  583. ---TRANSACTION 303910384574640, not started
  584. 0 lock struct(s), heap size 1136, 0 row lock(s)
  585. ---TRANSACTION 303910384569120, not started
  586. 0 lock struct(s), heap size 1136, 0 row lock(s)
  587. ---TRANSACTION 303910384545200, not started
  588. 0 lock struct(s), heap size 1136, 0 row lock(s)
  589. ---TRANSACTION 303910384315200, not started
  590. 0 lock struct(s), heap size 1136, 0 row lock(s)
  591. ---TRANSACTION 303910384426520, not started
  592. 0 lock struct(s), heap size 1136, 0 row lock(s)
  593. ---TRANSACTION 303910384367640, not started
  594. 0 lock struct(s), heap size 1136, 0 row lock(s)
  595. ---TRANSACTION 303910384317960, not started
  596. 0 lock struct(s), heap size 1136, 0 row lock(s)
  597. ---TRANSACTION 303910384307840, not started
  598. 0 lock struct(s), heap size 1136, 0 row lock(s)
  599. ---TRANSACTION 303910384526800, not started
  600. 0 lock struct(s), heap size 1136, 0 row lock(s)
  601. ---TRANSACTION 303910384482640, not started
  602. 0 lock struct(s), heap size 1136, 0 row lock(s)
  603. ---TRANSACTION 303910384524960, not started
  604. 0 lock struct(s), heap size 1136, 0 row lock(s)
  605. ---TRANSACTION 303910384513920, not started
  606. 0 lock struct(s), heap size 1136, 0 row lock(s)
  607. ---TRANSACTION 303910384501960, not started
  608. 0 lock struct(s), heap size 1136, 0 row lock(s)
  609. ---TRANSACTION 303910384414560, not started
  610. 0 lock struct(s), heap size 1136, 0 row lock(s)
  611. ---TRANSACTION 303910384458720, not started
  612. 0 lock struct(s), heap size 1136, 0 row lock(s)
  613. ---TRANSACTION 303910384443080, not started
  614. 0 lock struct(s), heap size 1136, 0 row lock(s)
  615. ---TRANSACTION 303910384474360, not started
  616. 0 lock struct(s), heap size 1136, 0 row lock(s)
  617. ---TRANSACTION 303910384310600, not started
  618. 0 lock struct(s), heap size 1136, 0 row lock(s)
  619. ---TRANSACTION 303910384445840, not started
  620. 0 lock struct(s), heap size 1136, 0 row lock(s)
  621. ---TRANSACTION 303910384419160, not started
  622. 0 lock struct(s), heap size 1136, 0 row lock(s)
  623. ---TRANSACTION 303910384344640, not started
  624. 0 lock struct(s), heap size 1136, 0 row lock(s)
  625. ---TRANSACTION 303910384429280, not started
  626. 0 lock struct(s), heap size 1136, 0 row lock(s)
  627. ---TRANSACTION 303910384311520, not started
  628. 0 lock struct(s), heap size 1136, 0 row lock(s)
  629. ---TRANSACTION 303910384386960, not started
  630. 0 lock struct(s), heap size 1136, 0 row lock(s)
  631. ---TRANSACTION 303910384313360, not started
  632. 0 lock struct(s), heap size 1136, 0 row lock(s)
  633. ---TRANSACTION 303910384335440, not started
  634. 0 lock struct(s), heap size 1136, 0 row lock(s)
  635. ---TRANSACTION 303910384308760, not started
  636. 0 lock struct(s), heap size 1136, 0 row lock(s)
  637. ---TRANSACTION 303910384334520, not started
  638. 0 lock struct(s), heap size 1136, 0 row lock(s)
  639. ---TRANSACTION 303910384325320, not started
  640. 0 lock struct(s), heap size 1136, 0 row lock(s)
  641. ---TRANSACTION 303910384617880, not started
  642. 0 lock struct(s), heap size 1136, 0 row lock(s)
  643. ---TRANSACTION 303910384616960, not started
  644. 0 lock struct(s), heap size 1136, 0 row lock(s)
  645. ---TRANSACTION 303910384306920, not started
  646. 0 lock struct(s), heap size 1136, 0 row lock(s)
  647. ---TRANSACTION 303910384306000, not started
  648. 0 lock struct(s), heap size 1136, 0 row lock(s)
  649. --------
  650. FILE I/O
  651. --------
  652. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  653. I/O thread 1 state: waiting for completed aio requests (log thread)
  654. I/O thread 2 state: waiting for completed aio requests (read thread)
  655. I/O thread 3 state: waiting for completed aio requests (read thread)
  656. I/O thread 4 state: waiting for completed aio requests (read thread)
  657. I/O thread 5 state: waiting for completed aio requests (read thread)
  658. I/O thread 6 state: waiting for completed aio requests (write thread)
  659. I/O thread 7 state: waiting for completed aio requests (write thread)
  660. I/O thread 8 state: waiting for completed aio requests (write thread)
  661. I/O thread 9 state: waiting for completed aio requests (write thread)
  662. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  663. ibuf aio reads:, log i/o's:, sync i/o's:
  664. Pending flushes (fsync) log: 0; buffer pool: 0
  665. 1480034 OS file reads, 18351476 OS file writes, 1201900 OS fsyncs
  666. 0.00 reads/s, 0 avg bytes/read, 0.08 writes/s, 0.08 fsyncs/s
  667. -------------------------------------
  668. INSERT BUFFER AND ADAPTIVE HASH INDEX
  669. -------------------------------------
  670. Ibuf: size 1, free list len 42911, seg size 42913, 269267 merges
  671. merged operations:
  672. insert 939502, delete mark 117178516, delete 3147032
  673. discarded operations:
  674. insert 0, delete mark 0, delete 0
  675. Hash table size 1328213, node heap has 9 buffer(s)
  676. Hash table size 1328213, node heap has 2 buffer(s)
  677. Hash table size 1328213, node heap has 16 buffer(s)
  678. Hash table size 1328213, node heap has 5 buffer(s)
  679. Hash table size 1328213, node heap has 2 buffer(s)
  680. Hash table size 1328213, node heap has 10447 buffer(s)
  681. Hash table size 1328213, node heap has 68 buffer(s)
  682. Hash table size 1328213, node heap has 9207 buffer(s)
  683. 14.15 hash searches/s, 55.28 non-hash searches/s
  684. ---
  685. LOG
  686. ---
  687. Log sequence number 3820212680683
  688. Log flushed up to 3820212680683
  689. Pages flushed up to 3820212607137
  690. Last checkpoint at 3820212607128
  691. 0 pending log flushes, 0 pending chkp writes
  692. 257793 log i/o's done, 0.08 log i/o's/second
  693. ----------------------
  694. BUFFER POOL AND MEMORY
  695. ----------------------
  696. Total large memory allocated 5497159680
  697. Dictionary memory allocated 725676
  698. Buffer pool size 327680
  699. Free buffers 65997
  700. Database pages 241927
  701. Old database pages 89143
  702. Modified db pages 178
  703. Pending reads 0
  704. Pending writes: LRU 0, flush list 0, single page 0
  705. Pages made young 1867725, not young 1376687259
  706. 0.00 youngs/s, 0.00 non-youngs/s
  707. Pages read 1479903, created 708186, written 17564409
  708. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  709. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  710. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  711. LRU len: 241927, unzip_LRU len: 0
  712. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  713. ----------------------
  714. INDIVIDUAL BUFFER POOL INFO
  715. ----------------------
  716. ---BUFFER POOL 0
  717. Buffer pool size 40960
  718. Free buffers 8347
  719. Database pages 30181
  720. Old database pages 11121
  721. Modified db pages 86
  722. Pending reads 0
  723. Pending writes: LRU 0, flush list 0, single page 0
  724. Pages made young 240494, not young 203181115
  725. 0.00 youngs/s, 0.00 non-youngs/s
  726. Pages read 209903, created 89176, written 2461867
  727. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  728. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  729. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  730. LRU len: 30181, unzip_LRU len: 0
  731. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  732. ---BUFFER POOL 1
  733. Buffer pool size 40960
  734. Free buffers 8276
  735. Database pages 30241
  736. Old database pages 11143
  737. Modified db pages 1
  738. Pending reads 0
  739. Pending writes: LRU 0, flush list 0, single page 0
  740. Pages made young 230908, not young 176032332
  741. 0.00 youngs/s, 0.00 non-youngs/s
  742. Pages read 187172, created 89414, written 2050430
  743. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  744. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  745. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  746. LRU len: 30241, unzip_LRU len: 0
  747. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  748. ---BUFFER POOL 2
  749. Buffer pool size 40960
  750. Free buffers 8291
  751. Database pages 30225
  752. Old database pages 11137
  753. Modified db pages 6
  754. Pending reads 0
  755. Pending writes: LRU 0, flush list 0, single page 0
  756. Pages made young 229411, not young 170960464
  757. 0.00 youngs/s, 0.00 non-youngs/s
  758. Pages read 184718, created 90135, written 1868589
  759. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  760. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  761. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  762. LRU len: 30225, unzip_LRU len: 0
  763. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  764. ---BUFFER POOL 3
  765. Buffer pool size 40960
  766. Free buffers 8189
  767. Database pages 30277
  768. Old database pages 11156
  769. Modified db pages 27
  770. Pending reads 0
  771. Pending writes: LRU 0, flush list 0, single page 0
  772. Pages made young 233550, not young 177215263
  773. 0.00 youngs/s, 0.00 non-youngs/s
  774. Pages read 191056, created 89788, written 2521045
  775. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  776. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  777. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  778. LRU len: 30277, unzip_LRU len: 0
  779. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  780. ---BUFFER POOL 4
  781. Buffer pool size 40960
  782. Free buffers 8310
  783. Database pages 30249
  784. Old database pages 11146
  785. Modified db pages 29
  786. Pending reads 0
  787. Pending writes: LRU 0, flush list 0, single page 0
  788. Pages made young 235485, not young 173729909
  789. 0.00 youngs/s, 0.00 non-youngs/s
  790. Pages read 190568, created 85940, written 2391820
  791. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  792. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  793. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  794. LRU len: 30249, unzip_LRU len: 0
  795. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  796. ---BUFFER POOL 5
  797. Buffer pool size 40960
  798. Free buffers 8101
  799. Database pages 30321
  800. Old database pages 11172
  801. Modified db pages 4
  802. Pending reads 0
  803. Pending writes: LRU 0, flush list 0, single page 0
  804. Pages made young 237497, not young 145285153
  805. 0.00 youngs/s, 0.00 non-youngs/s
  806. Pages read 168073, created 87004, written 1876599
  807. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  808. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  809. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  810. LRU len: 30321, unzip_LRU len: 0
  811. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  812. ---BUFFER POOL 6
  813. Buffer pool size 40960
  814. Free buffers 8290
  815. Database pages 30211
  816. Old database pages 11132
  817. Modified db pages 0
  818. Pending reads 0
  819. Pending writes: LRU 0, flush list 0, single page 0
  820. Pages made young 231438, not young 179659550
  821. 0.00 youngs/s, 0.00 non-youngs/s
  822. Pages read 182471, created 88014, written 2283899
  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: 30211, unzip_LRU len: 0
  827. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  828. ---BUFFER POOL 7
  829. Buffer pool size 40960
  830. Free buffers 8193
  831. Database pages 30222
  832. Old database pages 11136
  833. Modified db pages 25
  834. Pending reads 0
  835. Pending writes: LRU 0, flush list 0, single page 0
  836. Pages made young 228942, not young 150623473
  837. 0.00 youngs/s, 0.00 non-youngs/s
  838. Pages read 165942, created 88715, written 2110160
  839. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  840. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  841. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  842. LRU len: 30222, unzip_LRU len: 0
  843. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  844. --------------
  845. ROW OPERATIONS
  846. --------------
  847. 0 queries inside InnoDB, 0 queries in queue
  848. 84 read views open inside InnoDB
  849. Process ID=18854, Main thread ID=22429342619392, state: sleeping
  850. Number of rows inserted 584074982, updated 8146, deleted 140104586, read 1852352373
  851. 428.84 inserts/s, 0.00 updates/s, 0.00 deletes/s, 74154.53 reads/s
  852. ----------------------------
  853. END OF INNODB MONITOR OUTPUT
  854. ============================
  855. |
  856.  
  857. 1 row in set (0.04 sec)
  858.  
  859. mysql> SHOW ENGINE INNODB STATUS;
  860.  
  861. | InnoDB | |
  862. =====================================
  863. 2022-04-14 14:54:07 0x14666b86b700 INNODB MONITOR OUTPUT
  864. =====================================
  865. Per second averages calculated from the last 11 seconds
  866. -----------------
  867. BACKGROUND THREAD
  868. -----------------
  869. srv_master_thread loops: 1228831 srv_active, 0 srv_shutdown, 205 srv_idle
  870. srv_master_thread log flush and writes: 1229036
  871. ----------
  872. SEMAPHORES
  873. ----------
  874. OS WAIT ARRAY INFO: reservation count 1884755
  875. OS WAIT ARRAY INFO: signal count 11171703
  876. RW-shared spins 0, rounds 5184518, OS waits 612256
  877. RW-excl spins 0, rounds 59123170, OS waits 964754
  878. RW-sx spins 45445, rounds 628055, OS waits 14655
  879. Spin rounds per wait: 5184518.00 RW-shared, 59123170.00 RW-excl, 13.82 RW-sx
  880. ------------
  881. TRANSACTIONS
  882. ------------
  883. Trx id counter 10788796
  884. Purge done for trx's n:o < 10788770 undo n:o < 0 state: running but idle
  885. History list length 0
  886. LIST OF TRANSACTIONS FOR EACH SESSION:
  887. ---TRANSACTION 303910384457800, not started
  888. 0 lock struct(s), heap size 1136, 0 row lock(s)
  889. ---TRANSACTION 303910384455040, not started
  890. 0 lock struct(s), heap size 1136, 0 row lock(s)
  891. ---TRANSACTION 303910384452280, not started
  892. 0 lock struct(s), heap size 1136, 0 row lock(s)
  893. ---TRANSACTION 303910384333600, not started
  894. 0 lock struct(s), heap size 1136, 0 row lock(s)
  895. ---TRANSACTION 303910384444920, not started
  896. 0 lock struct(s), heap size 1136, 0 row lock(s)
  897. ---TRANSACTION 303910384342800, not started
  898. 0 lock struct(s), heap size 1136, 0 row lock(s)
  899. ---TRANSACTION 303910384678600, not started
  900. 0 lock struct(s), heap size 1136, 0 row lock(s)
  901. ---TRANSACTION 303910384606840, not started
  902. 0 lock struct(s), heap size 1136, 0 row lock(s)
  903. ---TRANSACTION 303910384585680, not started
  904. 0 lock struct(s), heap size 1136, 0 row lock(s)
  905. ---TRANSACTION 303910384675840, not started
  906. 0 lock struct(s), heap size 1136, 0 row lock(s)
  907. ---TRANSACTION 303910384674920, not started
  908. 0 lock struct(s), heap size 1136, 0 row lock(s)
  909. ---TRANSACTION 303910384673080, not started
  910. 0 lock struct(s), heap size 1136, 0 row lock(s)
  911. ---TRANSACTION 303910384672160, not started
  912. 0 lock struct(s), heap size 1136, 0 row lock(s)
  913. ---TRANSACTION 303910384671240, not started
  914. 0 lock struct(s), heap size 1136, 0 row lock(s)
  915. ---TRANSACTION 303910384670320, not started
  916. 0 lock struct(s), heap size 1136, 0 row lock(s)
  917. ---TRANSACTION 303910384669400, not started
  918. 0 lock struct(s), heap size 1136, 0 row lock(s)
  919. ---TRANSACTION 303910384668480, not started
  920. 0 lock struct(s), heap size 1136, 0 row lock(s)
  921. ---TRANSACTION 303910384666640, not started
  922. 0 lock struct(s), heap size 1136, 0 row lock(s)
  923. ---TRANSACTION 303910384667560, not started
  924. 0 lock struct(s), heap size 1136, 0 row lock(s)
  925. ---TRANSACTION 303910384665720, not started
  926. 0 lock struct(s), heap size 1136, 0 row lock(s)
  927. ---TRANSACTION 303910384664800, not started
  928. 0 lock struct(s), heap size 1136, 0 row lock(s)
  929. ---TRANSACTION 303910384663880, not started
  930. 0 lock struct(s), heap size 1136, 0 row lock(s)
  931. ---TRANSACTION 303910384662960, not started
  932. 0 lock struct(s), heap size 1136, 0 row lock(s)
  933. ---TRANSACTION 303910384662040, not started
  934. 0 lock struct(s), heap size 1136, 0 row lock(s)
  935. ---TRANSACTION 303910384661120, not started
  936. 0 lock struct(s), heap size 1136, 0 row lock(s)
  937. ---TRANSACTION 303910384660200, not started
  938. 0 lock struct(s), heap size 1136, 0 row lock(s)
  939. ---TRANSACTION 303910384659280, not started
  940. 0 lock struct(s), heap size 1136, 0 row lock(s)
  941. ---TRANSACTION 303910384658360, not started
  942. 0 lock struct(s), heap size 1136, 0 row lock(s)
  943. ---TRANSACTION 303910384657440, not started
  944. 0 lock struct(s), heap size 1136, 0 row lock(s)
  945. ---TRANSACTION 303910384656520, not started
  946. 0 lock struct(s), heap size 1136, 0 row lock(s)
  947. ---TRANSACTION 303910384655600, not started
  948. 0 lock struct(s), heap size 1136, 0 row lock(s)
  949. ---TRANSACTION 303910384654680, not started
  950. 0 lock struct(s), heap size 1136, 0 row lock(s)
  951. ---TRANSACTION 303910384653760, not started
  952. 0 lock struct(s), heap size 1136, 0 row lock(s)
  953. ---TRANSACTION 303910384652840, not started
  954. 0 lock struct(s), heap size 1136, 0 row lock(s)
  955. ---TRANSACTION 303910384651920, not started
  956. 0 lock struct(s), heap size 1136, 0 row lock(s)
  957. ---TRANSACTION 303910384651000, not started
  958. 0 lock struct(s), heap size 1136, 0 row lock(s)
  959. ---TRANSACTION 303910384650080, not started
  960. 0 lock struct(s), heap size 1136, 0 row lock(s)
  961. ---TRANSACTION 303910384649160, not started
  962. 0 lock struct(s), heap size 1136, 0 row lock(s)
  963. ---TRANSACTION 303910384648240, not started
  964. 0 lock struct(s), heap size 1136, 0 row lock(s)
  965. ---TRANSACTION 303910384647320, not started
  966. 0 lock struct(s), heap size 1136, 0 row lock(s)
  967. ---TRANSACTION 303910384646400, not started
  968. 0 lock struct(s), heap size 1136, 0 row lock(s)
  969. ---TRANSACTION 303910384645480, not started
  970. 0 lock struct(s), heap size 1136, 0 row lock(s)
  971. ---TRANSACTION 303910384644560, not started
  972. 0 lock struct(s), heap size 1136, 0 row lock(s)
  973. ---TRANSACTION 303910384643640, not started
  974. 0 lock struct(s), heap size 1136, 0 row lock(s)
  975. ---TRANSACTION 303910384642720, not started
  976. 0 lock struct(s), heap size 1136, 0 row lock(s)
  977. ---TRANSACTION 303910384641800, not started
  978. 0 lock struct(s), heap size 1136, 0 row lock(s)
  979. ---TRANSACTION 303910384640880, not started
  980. 0 lock struct(s), heap size 1136, 0 row lock(s)
  981. ---TRANSACTION 303910384639040, not started
  982. 0 lock struct(s), heap size 1136, 0 row lock(s)
  983. ---TRANSACTION 303910384639960, not started
  984. 0 lock struct(s), heap size 1136, 0 row lock(s)
  985. ---TRANSACTION 303910384638120, not started
  986. 0 lock struct(s), heap size 1136, 0 row lock(s)
  987. ---TRANSACTION 303910384636280, not started
  988. 0 lock struct(s), heap size 1136, 0 row lock(s)
  989. ---TRANSACTION 303910384635360, not started
  990. 0 lock struct(s), heap size 1136, 0 row lock(s)
  991. ---TRANSACTION 303910384634440, not started
  992. 0 lock struct(s), heap size 1136, 0 row lock(s)
  993. ---TRANSACTION 303910384633520, not started
  994. 0 lock struct(s), heap size 1136, 0 row lock(s)
  995. ---TRANSACTION 303910384632600, not started
  996. 0 lock struct(s), heap size 1136, 0 row lock(s)
  997. ---TRANSACTION 303910384631680, not started
  998. 0 lock struct(s), heap size 1136, 0 row lock(s)
  999. ---TRANSACTION 303910384630760, not started
  1000. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1001. ---TRANSACTION 303910384629840, not started
  1002. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1003. ---TRANSACTION 303910384628920, not started
  1004. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1005. ---TRANSACTION 303910384628000, not started
  1006. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1007. ---TRANSACTION 303910384627080, not started
  1008. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1009. ---TRANSACTION 303910384626160, not started
  1010. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1011. ---TRANSACTION 303910384625240, not started
  1012. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1013. ---TRANSACTION 303910384624320, not started
  1014. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1015. ---TRANSACTION 303910384622480, not started
  1016. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1017. ---TRANSACTION 303910384621560, not started
  1018. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1019. ---TRANSACTION 303910384620640, not started
  1020. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1021. ---TRANSACTION 303910384618800, not started
  1022. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1023. ---TRANSACTION 303910384616040, not started
  1024. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1025. ---TRANSACTION 303910384610520, not started
  1026. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1027. ---TRANSACTION 303910384607760, not started
  1028. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1029. ---TRANSACTION 303910384605000, not started
  1030. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1031. ---TRANSACTION 303910384603160, not started
  1032. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1033. ---TRANSACTION 303910384601320, not started
  1034. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1035. ---TRANSACTION 303910384595800, not started
  1036. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1037. ---TRANSACTION 303910384594880, not started
  1038. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1039. ---TRANSACTION 303910384593960, not started
  1040. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1041. ---TRANSACTION 303910384592120, not started
  1042. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1043. ---TRANSACTION 303910384591200, not started
  1044. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1045. ---TRANSACTION 303910384589360, not started
  1046. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1047. ---TRANSACTION 303910384586600, not started
  1048. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1049. ---TRANSACTION 303910384584760, not started
  1050. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1051. ---TRANSACTION 303910384583840, not started
  1052. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1053. ---TRANSACTION 303910384580160, not started
  1054. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1055. ---TRANSACTION 303910384579240, not started
  1056. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1057. ---TRANSACTION 303910384577400, not started
  1058. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1059. ---TRANSACTION 303910384570960, not started
  1060. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1061. ---TRANSACTION 303910384570040, not started
  1062. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1063. ---TRANSACTION 303910384568200, not started
  1064. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1065. ---TRANSACTION 303910384567280, not started
  1066. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1067. ---TRANSACTION 303910384566360, not started
  1068. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1069. ---TRANSACTION 303910384565440, not started
  1070. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1071. ---TRANSACTION 303910384562680, not started
  1072. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1073. ---TRANSACTION 303910384561760, not started
  1074. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1075. ---TRANSACTION 303910384560840, not started
  1076. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1077. ---TRANSACTION 303910384559920, not started
  1078. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1079. ---TRANSACTION 303910384559000, not started
  1080. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1081. ---TRANSACTION 303910384557160, not started
  1082. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1083. ---TRANSACTION 303910384556240, not started
  1084. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1085. ---TRANSACTION 303910384554400, not started
  1086. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1087. ---TRANSACTION 303910384553480, not started
  1088. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1089. ---TRANSACTION 303910384552560, not started
  1090. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1091. ---TRANSACTION 303910384551640, not started
  1092. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1093. ---TRANSACTION 303910384489080, not started
  1094. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1095. ---TRANSACTION 303910384444000, not started
  1096. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1097. ---TRANSACTION 303910384433880, not started
  1098. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1099. ---TRANSACTION 303910384432960, not started
  1100. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1101. ---TRANSACTION 303910384372240, not started
  1102. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1103. ---TRANSACTION 303910384363040, not started
  1104. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1105. ---TRANSACTION 303910384348320, not started
  1106. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1107. ---TRANSACTION 303910384327160, not started
  1108. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1109. ---TRANSACTION 303910384354760, not started
  1110. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1111. ---TRANSACTION 303910384547040, not started
  1112. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1113. ---TRANSACTION 303910384535080, not started
  1114. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1115. ---TRANSACTION 303910384522200, not started
  1116. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1117. ---TRANSACTION 303910384475280, not started
  1118. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1119. ---TRANSACTION 303910384446760, not started
  1120. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1121. ---TRANSACTION 303910384439400, not started
  1122. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1123. ---TRANSACTION 303910384379600, not started
  1124. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1125. ---TRANSACTION 303910384365800, not started
  1126. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1127. ---TRANSACTION 303910384416400, not started
  1128. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1129. ---TRANSACTION 303910384549800, not started
  1130. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1131. ---TRANSACTION 303910384366720, not started
  1132. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1133. ---TRANSACTION 303910384507480, not started
  1134. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1135. ---TRANSACTION 303910384376840, not started
  1136. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1137. ---TRANSACTION 303910384548880, not started
  1138. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1139. ---TRANSACTION 303910384547960, not started
  1140. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1141. ---TRANSACTION 303910384546120, not started
  1142. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1143. ---TRANSACTION 303910384544280, not started
  1144. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1145. ---TRANSACTION 303910384536000, not started
  1146. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1147. ---TRANSACTION 303910384351080, not started
  1148. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1149. ---TRANSACTION 303910384491840, not started
  1150. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1151. ---TRANSACTION 303910384543360, not started
  1152. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1153. ---TRANSACTION 303910384542440, not started
  1154. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1155. ---TRANSACTION 303910384413640, not started
  1156. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1157. ---TRANSACTION 303910384541520, not started
  1158. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1159. ---TRANSACTION 303910384501040, not started
  1160. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1161. ---TRANSACTION 303910384540600, not started
  1162. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1163. ---TRANSACTION 303910384538760, not started
  1164. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1165. ---TRANSACTION 303910384504720, not started
  1166. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1167. ---TRANSACTION 303910384498280, not started
  1168. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1169. ---TRANSACTION 303910384483560, not started
  1170. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1171. ---TRANSACTION 303910384465160, not started
  1172. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1173. ---TRANSACTION 303910384441240, not started
  1174. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1175. ---TRANSACTION 303910384435720, not started
  1176. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1177. ---TRANSACTION 303910384427440, not started
  1178. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1179. ---TRANSACTION 303910384421920, not started
  1180. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1181. ---TRANSACTION 303910384407200, not started
  1182. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1183. ---TRANSACTION 303910384398000, not started
  1184. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1185. ---TRANSACTION 303910384331760, not started
  1186. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1187. ---TRANSACTION 303910384340040, not started
  1188. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1189. ---TRANSACTION 303910384323480, not started
  1190. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1191. ---TRANSACTION 303910384356600, not started
  1192. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1193. ---TRANSACTION 303910384343720, not started
  1194. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1195. ---TRANSACTION 303910384326240, not started
  1196. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1197. ---TRANSACTION 303910384350160, not started
  1198. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1199. ---TRANSACTION 303910384438480, not started
  1200. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1201. ---TRANSACTION 303910384537840, not started
  1202. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1203. ---TRANSACTION 303910384329920, not started
  1204. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1205. ---TRANSACTION 303910384322560, not started
  1206. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1207. ---TRANSACTION 303910384520360, not started
  1208. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1209. ---TRANSACTION 303910384509320, not started
  1210. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1211. ---TRANSACTION 303910384494600, not started
  1212. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1213. ---TRANSACTION 303910384369480, not started
  1214. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1215. ---TRANSACTION 303910384536920, not started
  1216. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1217. ---TRANSACTION 303910384534160, not started
  1218. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1219. ---TRANSACTION 303910384533240, not started
  1220. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1221. ---TRANSACTION 303910384531400, not started
  1222. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1223. ---TRANSACTION 303910384318880, not started
  1224. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1225. ---TRANSACTION 303910384529560, not started
  1226. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1227. ---TRANSACTION 303910384525880, not started
  1228. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1229. ---TRANSACTION 303910384518520, not started
  1230. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1231. ---TRANSACTION 303910384517600, not started
  1232. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1233. ---TRANSACTION 303910384515760, not started
  1234. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1235. ---TRANSACTION 303910384514840, not started
  1236. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1237. ---TRANSACTION 303910384513000, not started
  1238. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1239. ---TRANSACTION 303910384478040, not started
  1240. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1241. ---TRANSACTION 303910384385120, not started
  1242. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1243. ---TRANSACTION 303910384512080, not started
  1244. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1245. ---TRANSACTION 303910384408120, not started
  1246. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1247. ---TRANSACTION 303910384352920, not started
  1248. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1249. ---TRANSACTION 303910384508400, not started
  1250. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1251. ---TRANSACTION 303910384382360, not started
  1252. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1253. ---TRANSACTION 303910384411800, not started
  1254. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1255. ---TRANSACTION 303910384506560, not started
  1256. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1257. ---TRANSACTION 303910384505640, not started
  1258. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1259. ---TRANSACTION 303910384496440, not started
  1260. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1261. ---TRANSACTION 303910384358440, not started
  1262. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1263. ---TRANSACTION 303910384493680, not started
  1264. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1265. ---TRANSACTION 303910384480800, not started
  1266. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1267. ---TRANSACTION 303910384460560, not started
  1268. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1269. ---TRANSACTION 303910384381440, not started
  1270. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1271. ---TRANSACTION 303910384478960, not started
  1272. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1273. ---TRANSACTION 303910384477120, not started
  1274. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1275. ---TRANSACTION 303910384476200, not started
  1276. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1277. ---TRANSACTION 303910384329000, not started
  1278. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1279. ---TRANSACTION 303910384436640, not started
  1280. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1281. ---TRANSACTION 303910384400760, not started
  1282. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1283. ---TRANSACTION 303910384387880, not started
  1284. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1285. ---TRANSACTION 303910384399840, not started
  1286. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1287. ---TRANSACTION 303910384364880, not started
  1288. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1289. ---TRANSACTION 303910384360280, not started
  1290. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1291. ---TRANSACTION 303910384332680, not started
  1292. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1293. ---TRANSACTION 303910384362120, not started
  1294. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1295. ---TRANSACTION 303910384340960, not started
  1296. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1297. ---TRANSACTION 303910384467000, not started
  1298. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1299. ---TRANSACTION 303910384470680, not started
  1300. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1301. ---TRANSACTION 303910384321640, not started
  1302. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1303. ---TRANSACTION 303910384409040, not started
  1304. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1305. ---TRANSACTION 303910384312440, not started
  1306. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1307. ---TRANSACTION 303910384392480, not started
  1308. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1309. ---TRANSACTION 303910384403520, not started
  1310. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1311. ---TRANSACTION 303910384317040, not started
  1312. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1313. ---TRANSACTION 303910384390640, not started
  1314. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1315. ---TRANSACTION 303910384370400, not started
  1316. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1317. ---TRANSACTION 303910384338200, not started
  1318. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1319. ---TRANSACTION 303910384486320, not started
  1320. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1321. ---TRANSACTION 303910384463320, not started
  1322. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1323. ---TRANSACTION 303910384449520, not started
  1324. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1325. ---TRANSACTION 303910384424680, not started
  1326. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1327. ---TRANSACTION 303910384402600, not started
  1328. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1329. ---TRANSACTION 303910384415480, not started
  1330. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1331. ---TRANSACTION 303910384502880, not started
  1332. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1333. ---TRANSACTION 303910384410880, not started
  1334. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1335. ---TRANSACTION 303910384404440, not started
  1336. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1337. ---TRANSACTION 303910384380520, not started
  1338. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1339. ---TRANSACTION 303910384324400, not started
  1340. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1341. ---TRANSACTION 303910384485400, not started
  1342. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1343. ---TRANSACTION 303910384319800, not started
  1344. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1345. ---TRANSACTION 303910384479880, not started
  1346. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1347. ---TRANSACTION 303910384434800, not started
  1348. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1349. ---TRANSACTION 303910384473440, not started
  1350. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1351. ---TRANSACTION 303910384468840, not started
  1352. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1353. ---TRANSACTION 303910384466080, not started
  1354. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1355. ---TRANSACTION 303910384461480, not started
  1356. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1357. ---TRANSACTION 303910384395240, not started
  1358. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1359. ---TRANSACTION 303910384355680, not started
  1360. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1361. ---TRANSACTION 303910384337280, not started
  1362. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1363. ---TRANSACTION 303910384442160, not started
  1364. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1365. ---TRANSACTION 303910384430200, not started
  1366. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1367. ---TRANSACTION 303910384314280, not started
  1368. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1369. ---TRANSACTION 303910384374080, not started
  1370. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1371. ---TRANSACTION 303910384453200, not started
  1372. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1373. ---TRANSACTION 303910384428360, not started
  1374. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1375. ---TRANSACTION 303910384425600, not started
  1376. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1377. ---TRANSACTION 303910384405360, not started
  1378. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1379. ---TRANSACTION 303910384417320, not started
  1380. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1381. ---TRANSACTION 303910384447680, not started
  1382. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1383. ---TRANSACTION 303910384309680, not started
  1384. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1385. ---TRANSACTION 303910384345560, not started
  1386. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1387. ---TRANSACTION 303910384469760, not started
  1388. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1389. ---TRANSACTION 303910384393400, not started
  1390. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1391. ---TRANSACTION 303910384528640, not started
  1392. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1393. ---TRANSACTION 303910384527720, not started
  1394. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1395. ---TRANSACTION 303910384500120, not started
  1396. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1397. ---TRANSACTION 303910384459640, not started
  1398. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1399. ---TRANSACTION 303910384490000, not started
  1400. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1401. ---TRANSACTION 303910384440320, not started
  1402. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1403. ---TRANSACTION 303910384421000, not started
  1404. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1405. ---TRANSACTION 303910384388800, not started
  1406. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1407. ---TRANSACTION 303910384384200, not started
  1408. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1409. ---TRANSACTION 303910384352000, not started
  1410. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1411. ---TRANSACTION 303910384375000, not started
  1412. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1413. ---TRANSACTION 303910384375920, not started
  1414. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1415. ---TRANSACTION 303910384357520, not started
  1416. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1417. ---TRANSACTION 303910384341880, not started
  1418. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1419. ---TRANSACTION 303910384347400, not started
  1420. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1421. ---TRANSACTION 303910384330840, not started
  1422. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1423. ---TRANSACTION 303910384383280, not started
  1424. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1425. ---TRANSACTION 303910384412720, not started
  1426. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1427. ---TRANSACTION 303910384503800, not started
  1428. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1429. ---TRANSACTION 303910384346480, not started
  1430. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1431. ---TRANSACTION 303910384398920, not started
  1432. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1433. ---TRANSACTION 303910384339120, not started
  1434. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1435. ---TRANSACTION 303910384391560, not started
  1436. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1437. ---TRANSACTION 303910384396160, not started
  1438. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1439. ---TRANSACTION 303910384558080, not started
  1440. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1441. ---TRANSACTION 303910384555320, not started
  1442. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1443. ---TRANSACTION 303910384521280, not started
  1444. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1445. ---TRANSACTION 303910384389720, not started
  1446. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1447. ---TRANSACTION 303910384386040, not started
  1448. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1449. ---TRANSACTION 303910384316120, not started
  1450. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1451. ---TRANSACTION 303910384614200, not started
  1452. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1453. ---TRANSACTION 303910384612360, not started
  1454. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1455. ---TRANSACTION 303910384611440, not started
  1456. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1457. ---TRANSACTION 303910384484480, not started
  1458. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1459. ---TRANSACTION 303910384450440, not started
  1460. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1461. ---TRANSACTION 303910384571880, not started
  1462. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1463. ---TRANSACTION 303910384497360, not started
  1464. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1465. ---TRANSACTION 303910384437560, not started
  1466. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1467. ---TRANSACTION 303910384609600, not started
  1468. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1469. ---TRANSACTION 303910384602240, not started
  1470. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1471. ---TRANSACTION 303910384581080, not started
  1472. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1473. ---TRANSACTION 303910384378680, not started
  1474. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1475. ---TRANSACTION 303910384432040, not started
  1476. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1477. ---TRANSACTION 303910384361200, not started
  1478. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1479. ---TRANSACTION 303910384532320, not started
  1480. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1481. ---TRANSACTION 303910384431120, not started
  1482. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1483. ---TRANSACTION 303910384406280, not started
  1484. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1485. ---TRANSACTION 303910384563600, not started
  1486. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1487. ---TRANSACTION 303910384490920, not started
  1488. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1489. ---TRANSACTION 303910384605920, not started
  1490. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1491. ---TRANSACTION 303910384401680, not started
  1492. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1493. ---TRANSACTION 303910384578320, not started
  1494. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1495. ---TRANSACTION 303910384575560, not started
  1496. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1497. ---TRANSACTION 303910384530480, not started
  1498. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1499. ---TRANSACTION 303910384373160, not started
  1500. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1501. ---TRANSACTION 303910384363960, not started
  1502. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1503. ---TRANSACTION 303910384359360, not started
  1504. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1505. ---TRANSACTION 303910384422840, not started
  1506. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1507. ---TRANSACTION 303910384418240, not started
  1508. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1509. ---TRANSACTION 303910384328080, not started
  1510. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1511. ---TRANSACTION 303910384511160, not started
  1512. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1513. ---TRANSACTION 303910384451360, not started
  1514. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1515. ---TRANSACTION 303910384454120, not started
  1516. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1517. ---TRANSACTION 303910384349240, not started
  1518. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1519. ---TRANSACTION 303910384368560, not started
  1520. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1521. ---TRANSACTION 303910384499200, not started
  1522. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1523. ---TRANSACTION 303910384598560, not started
  1524. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1525. ---TRANSACTION 303910384397080, not started
  1526. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1527. ---TRANSACTION 303910384596720, not started
  1528. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1529. ---TRANSACTION 303910384456880, not started
  1530. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1531. ---TRANSACTION 303910384492760, not started
  1532. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1533. ---TRANSACTION 303910384576480, not started
  1534. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1535. ---TRANSACTION 303910384574640, not started
  1536. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1537. ---TRANSACTION 303910384569120, not started
  1538. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1539. ---TRANSACTION 303910384545200, not started
  1540. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1541. ---TRANSACTION 303910384315200, not started
  1542. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1543. ---TRANSACTION 303910384426520, not started
  1544. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1545. ---TRANSACTION 303910384367640, not started
  1546. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1547. ---TRANSACTION 303910384317960, not started
  1548. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1549. ---TRANSACTION 303910384307840, not started
  1550. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1551. ---TRANSACTION 303910384526800, not started
  1552. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1553. ---TRANSACTION 303910384482640, not started
  1554. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1555. ---TRANSACTION 303910384524960, not started
  1556. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1557. ---TRANSACTION 303910384513920, not started
  1558. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1559. ---TRANSACTION 303910384501960, not started
  1560. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1561. ---TRANSACTION 303910384414560, not started
  1562. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1563. ---TRANSACTION 303910384458720, not started
  1564. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1565. ---TRANSACTION 303910384443080, not started
  1566. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1567. ---TRANSACTION 303910384474360, not started
  1568. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1569. ---TRANSACTION 303910384310600, not started
  1570. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1571. ---TRANSACTION 303910384445840, not started
  1572. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1573. ---TRANSACTION 303910384419160, not started
  1574. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1575. ---TRANSACTION 303910384344640, not started
  1576. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1577. ---TRANSACTION 303910384429280, not started
  1578. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1579. ---TRANSACTION 303910384311520, not started
  1580. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1581. ---TRANSACTION 303910384386960, not started
  1582. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1583. ---TRANSACTION 303910384313360, not started
  1584. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1585. ---TRANSACTION 303910384335440, not started
  1586. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1587. ---TRANSACTION 303910384308760, not started
  1588. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1589. ---TRANSACTION 303910384334520, not started
  1590. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1591. ---TRANSACTION 303910384325320, not started
  1592. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1593. ---TRANSACTION 303910384617880, not started
  1594. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1595. ---TRANSACTION 303910384616960, not started
  1596. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1597. ---TRANSACTION 303910384306920, not started
  1598. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1599. ---TRANSACTION 303910384306000, not started
  1600. 0 lock struct(s), heap size 1136, 0 row lock(s)
  1601. --------
  1602. FILE I/O
  1603. --------
  1604. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  1605. I/O thread 1 state: waiting for completed aio requests (log thread)
  1606. I/O thread 2 state: waiting for completed aio requests (read thread)
  1607. I/O thread 3 state: waiting for completed aio requests (read thread)
  1608. I/O thread 4 state: waiting for completed aio requests (read thread)
  1609. I/O thread 5 state: waiting for completed aio requests (read thread)
  1610. I/O thread 6 state: waiting for completed aio requests (write thread)
  1611. I/O thread 7 state: waiting for completed aio requests (write thread)
  1612. I/O thread 8 state: waiting for completed aio requests (write thread)
  1613. I/O thread 9 state: waiting for completed aio requests (write thread)
  1614. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  1615. ibuf aio reads:, log i/o's:, sync i/o's:
  1616. Pending flushes (fsync) log: 0; buffer pool: 0
  1617. 1480034 OS file reads, 18351476 OS file writes, 1201900 OS fsyncs
  1618. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  1619. -------------------------------------
  1620. INSERT BUFFER AND ADAPTIVE HASH INDEX
  1621. -------------------------------------
  1622. Ibuf: size 1, free list len 42911, seg size 42913, 269267 merges
  1623. merged operations:
  1624. insert 939502, delete mark 117178516, delete 3147032
  1625. discarded operations:
  1626. insert 0, delete mark 0, delete 0
  1627. Hash table size 1328213, node heap has 9 buffer(s)
  1628. Hash table size 1328213, node heap has 2 buffer(s)
  1629. Hash table size 1328213, node heap has 16 buffer(s)
  1630. Hash table size 1328213, node heap has 5 buffer(s)
  1631. Hash table size 1328213, node heap has 2 buffer(s)
  1632. Hash table size 1328213, node heap has 10447 buffer(s)
  1633. Hash table size 1328213, node heap has 68 buffer(s)
  1634. Hash table size 1328213, node heap has 9207 buffer(s)
  1635. 5.09 hash searches/s, 27.27 non-hash searches/s
  1636. ---
  1637. LOG
  1638. ---
  1639. Log sequence number 3820212680683
  1640. Log flushed up to 3820212680683
  1641. Pages flushed up to 3820212607137
  1642. Last checkpoint at 3820212607128
  1643. 0 pending log flushes, 0 pending chkp writes
  1644. 257793 log i/o's done, 0.00 log i/o's/second
  1645. ----------------------
  1646. BUFFER POOL AND MEMORY
  1647. ----------------------
  1648. Total large memory allocated 5497159680
  1649. Dictionary memory allocated 725676
  1650. Buffer pool size 327680
  1651. Free buffers 65997
  1652. Database pages 241927
  1653. Old database pages 89143
  1654. Modified db pages 178
  1655. Pending reads 0
  1656. Pending writes: LRU 0, flush list 0, single page 0
  1657. Pages made young 1867725, not young 1376687259
  1658. 0.00 youngs/s, 0.00 non-youngs/s
  1659. Pages read 1479903, created 708186, written 17564409
  1660. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1661. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1662. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1663. LRU len: 241927, unzip_LRU len: 0
  1664. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1665. ----------------------
  1666. INDIVIDUAL BUFFER POOL INFO
  1667. ----------------------
  1668. ---BUFFER POOL 0
  1669. Buffer pool size 40960
  1670. Free buffers 8347
  1671. Database pages 30181
  1672. Old database pages 11121
  1673. Modified db pages 86
  1674. Pending reads 0
  1675. Pending writes: LRU 0, flush list 0, single page 0
  1676. Pages made young 240494, not young 203181115
  1677. 0.00 youngs/s, 0.00 non-youngs/s
  1678. Pages read 209903, created 89176, written 2461867
  1679. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1680. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1681. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1682. LRU len: 30181, unzip_LRU len: 0
  1683. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1684. ---BUFFER POOL 1
  1685. Buffer pool size 40960
  1686. Free buffers 8276
  1687. Database pages 30241
  1688. Old database pages 11143
  1689. Modified db pages 1
  1690. Pending reads 0
  1691. Pending writes: LRU 0, flush list 0, single page 0
  1692. Pages made young 230908, not young 176032332
  1693. 0.00 youngs/s, 0.00 non-youngs/s
  1694. Pages read 187172, created 89414, written 2050430
  1695. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1696. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1697. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1698. LRU len: 30241, unzip_LRU len: 0
  1699. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1700. ---BUFFER POOL 2
  1701. Buffer pool size 40960
  1702. Free buffers 8291
  1703. Database pages 30225
  1704. Old database pages 11137
  1705. Modified db pages 6
  1706. Pending reads 0
  1707. Pending writes: LRU 0, flush list 0, single page 0
  1708. Pages made young 229411, not young 170960464
  1709. 0.00 youngs/s, 0.00 non-youngs/s
  1710. Pages read 184718, created 90135, written 1868589
  1711. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1712. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1713. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1714. LRU len: 30225, unzip_LRU len: 0
  1715. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1716. ---BUFFER POOL 3
  1717. Buffer pool size 40960
  1718. Free buffers 8189
  1719. Database pages 30277
  1720. Old database pages 11156
  1721. Modified db pages 27
  1722. Pending reads 0
  1723. Pending writes: LRU 0, flush list 0, single page 0
  1724. Pages made young 233550, not young 177215263
  1725. 0.00 youngs/s, 0.00 non-youngs/s
  1726. Pages read 191056, created 89788, written 2521045
  1727. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1728. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1729. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1730. LRU len: 30277, unzip_LRU len: 0
  1731. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1732. ---BUFFER POOL 4
  1733. Buffer pool size 40960
  1734. Free buffers 8310
  1735. Database pages 30249
  1736. Old database pages 11146
  1737. Modified db pages 29
  1738. Pending reads 0
  1739. Pending writes: LRU 0, flush list 0, single page 0
  1740. Pages made young 235485, not young 173729909
  1741. 0.00 youngs/s, 0.00 non-youngs/s
  1742. Pages read 190568, created 85940, written 2391820
  1743. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1744. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1745. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1746. LRU len: 30249, unzip_LRU len: 0
  1747. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1748. ---BUFFER POOL 5
  1749. Buffer pool size 40960
  1750. Free buffers 8101
  1751. Database pages 30321
  1752. Old database pages 11172
  1753. Modified db pages 4
  1754. Pending reads 0
  1755. Pending writes: LRU 0, flush list 0, single page 0
  1756. Pages made young 237497, not young 145285153
  1757. 0.00 youngs/s, 0.00 non-youngs/s
  1758. Pages read 168073, created 87004, written 1876599
  1759. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1760. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1761. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1762. LRU len: 30321, unzip_LRU len: 0
  1763. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1764. ---BUFFER POOL 6
  1765. Buffer pool size 40960
  1766. Free buffers 8290
  1767. Database pages 30211
  1768. Old database pages 11132
  1769. Modified db pages 0
  1770. Pending reads 0
  1771. Pending writes: LRU 0, flush list 0, single page 0
  1772. Pages made young 231438, not young 179659550
  1773. 0.00 youngs/s, 0.00 non-youngs/s
  1774. Pages read 182471, created 88014, written 2283899
  1775. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1776. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1777. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1778. LRU len: 30211, unzip_LRU len: 0
  1779. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1780. ---BUFFER POOL 7
  1781. Buffer pool size 40960
  1782. Free buffers 8193
  1783. Database pages 30222
  1784. Old database pages 11136
  1785. Modified db pages 25
  1786. Pending reads 0
  1787. Pending writes: LRU 0, flush list 0, single page 0
  1788. Pages made young 228942, not young 150623473
  1789. 0.00 youngs/s, 0.00 non-youngs/s
  1790. Pages read 165942, created 88715, written 2110160
  1791. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1792. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1793. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1794. LRU len: 30222, unzip_LRU len: 0
  1795. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1796. --------------
  1797. ROW OPERATIONS
  1798. --------------
  1799. 0 queries inside InnoDB, 0 queries in queue
  1800. 38 read views open inside InnoDB
  1801. Process ID=18854, Main thread ID=22429342619392, state: sleeping
  1802. Number of rows inserted 584079569, updated 8146, deleted 140104586, read 1852695159
  1803. 416.96 inserts/s, 0.00 updates/s, 0.00 deletes/s, 31159.53 reads/s
  1804. ----------------------------
  1805. END OF INNODB MONITOR OUTPUT
  1806. ============================
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!