wtt133

show_engine_innodb_status

Jun 8th, 2020
41
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Type Name Status
  2. InnoDB
  3. =====================================
  4. 2020-06-08 11:28:57 0x70000943e000 INNODB MONITOR OUTPUT
  5. =====================================
  6. Per second averages calculated from the last 60 seconds
  7. -----------------
  8. BACKGROUND THREAD
  9. -----------------
  10. srv_master_thread loops: 7 srv_active, 0 srv_shutdown, 43694 srv_idle
  11. srv_master_thread log flush and writes: 43701
  12. ----------
  13. SEMAPHORES
  14. ----------
  15. OS WAIT ARRAY INFO: reservation count 3141
  16. OS WAIT ARRAY INFO: signal count 56960
  17. RW-shared spins 0, rounds 51487, OS waits 1127
  18. RW-excl spins 0, rounds 445061, OS waits 83
  19. RW-sx spins 39141, rounds 182704, OS waits 1656
  20. Spin rounds per wait: 51487.00 RW-shared, 445061.00 RW-excl, 4.67 RW-sx
  21. ------------
  22. TRANSACTIONS
  23. ------------
  24. Trx id counter 7947
  25. Purge done for trx's n:o < 7947 undo n:o < 0 state: running but idle
  26. History list length 3
  27. LIST OF TRANSACTIONS FOR EACH SESSION:
  28. ---TRANSACTION 281479447797312, not started
  29. 0 lock struct(s), heap size 1136, 0 row lock(s)
  30. ---TRANSACTION 281479447796408, not started
  31. 0 lock struct(s), heap size 1136, 0 row lock(s)
  32. ---TRANSACTION 281479447795504, not started
  33. 0 lock struct(s), heap size 1136, 0 row lock(s)
  34. --------
  35. FILE I/O
  36. --------
  37. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  38. I/O thread 1 state: waiting for i/o request (log thread)
  39. I/O thread 2 state: waiting for i/o request (read thread)
  40. I/O thread 3 state: waiting for i/o request (read thread)
  41. I/O thread 4 state: waiting for i/o request (read thread)
  42. I/O thread 5 state: waiting for i/o request (read thread)
  43. I/O thread 6 state: waiting for i/o request (read thread)
  44. I/O thread 7 state: waiting for i/o request (read thread)
  45. I/O thread 8 state: waiting for i/o request (read thread)
  46. I/O thread 9 state: waiting for i/o request (read thread)
  47. I/O thread 10 state: waiting for i/o request (read thread)
  48. I/O thread 11 state: waiting for i/o request (read thread)
  49. I/O thread 12 state: waiting for i/o request (read thread)
  50. I/O thread 13 state: waiting for i/o request (read thread)
  51. I/O thread 14 state: waiting for i/o request (read thread)
  52. I/O thread 15 state: waiting for i/o request (read thread)
  53. I/O thread 16 state: waiting for i/o request (read thread)
  54. I/O thread 17 state: waiting for i/o request (read thread)
  55. I/O thread 18 state: waiting for i/o request (read thread)
  56. I/O thread 19 state: waiting for i/o request (read thread)
  57. I/O thread 20 state: waiting for i/o request (read thread)
  58. I/O thread 21 state: waiting for i/o request (read thread)
  59. I/O thread 22 state: waiting for i/o request (read thread)
  60. I/O thread 23 state: waiting for i/o request (read thread)
  61. I/O thread 24 state: waiting for i/o request (read thread)
  62. I/O thread 25 state: waiting for i/o request (read thread)
  63. I/O thread 26 state: waiting for i/o request (read thread)
  64. I/O thread 27 state: waiting for i/o request (read thread)
  65. I/O thread 28 state: waiting for i/o request (read thread)
  66. I/O thread 29 state: waiting for i/o request (read thread)
  67. I/O thread 30 state: waiting for i/o request (read thread)
  68. I/O thread 31 state: waiting for i/o request (read thread)
  69. I/O thread 32 state: waiting for i/o request (read thread)
  70. I/O thread 33 state: waiting for i/o request (read thread)
  71. I/O thread 34 state: waiting for i/o request (write thread)
  72. I/O thread 35 state: waiting for i/o request (write thread)
  73. I/O thread 36 state: waiting for i/o request (write thread)
  74. I/O thread 37 state: waiting for i/o request (write thread)
  75. I/O thread 38 state: waiting for i/o request (write thread)
  76. I/O thread 39 state: waiting for i/o request (write thread)
  77. I/O thread 40 state: waiting for i/o request (write thread)
  78. I/O thread 41 state: waiting for i/o request (write thread)
  79. I/O thread 42 state: waiting for i/o request (write thread)
  80. I/O thread 43 state: waiting for i/o request (write thread)
  81. I/O thread 44 state: waiting for i/o request (write thread)
  82. I/O thread 45 state: waiting for i/o request (write thread)
  83. I/O thread 46 state: waiting for i/o request (write thread)
  84. I/O thread 47 state: waiting for i/o request (write thread)
  85. I/O thread 48 state: waiting for i/o request (write thread)
  86. I/O thread 49 state: waiting for i/o request (write thread)
  87. Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
  88. ibuf aio reads:, log i/o's:, sync i/o's:
  89. Pending flushes (fsync) log: 0; buffer pool: 0
  90. 22626 OS file reads, 9118 OS file writes, 363 OS fsyncs
  91. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  92. -------------------------------------
  93. INSERT BUFFER AND ADAPTIVE HASH INDEX
  94. -------------------------------------
  95. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  96. merged operations:
  97. insert 0, delete mark 0, delete 0
  98. discarded operations:
  99. insert 0, delete mark 0, delete 0
  100. Hash table size 553193, node heap has 0 buffer(s)
  101. Hash table size 553193, node heap has 0 buffer(s)
  102. Hash table size 553193, node heap has 0 buffer(s)
  103. Hash table size 553193, node heap has 0 buffer(s)
  104. Hash table size 553193, node heap has 2 buffer(s)
  105. Hash table size 553193, node heap has 0 buffer(s)
  106. Hash table size 553193, node heap has 0 buffer(s)
  107. Hash table size 553193, node heap has 0 buffer(s)
  108. 0.00 hash searches/s, 0.00 non-hash searches/s
  109. ---
  110. LOG
  111. ---
  112. Log sequence number 3632719013
  113. Log flushed up to 3632719013
  114. Pages flushed up to 3632719013
  115. Last checkpoint at 3632719004
  116. 0 pending log flushes, 0 pending chkp writes
  117. 92 log i/o's done, 0.00 log i/o's/second
  118. ----------------------
  119. BUFFER POOL AND MEMORY
  120. ----------------------
  121. Total large memory allocated 2198863872
  122. Dictionary memory allocated 104875
  123. Buffer pool size 131056
  124. Free buffers 104426
  125. Database pages 26628
  126. Old database pages 9668
  127. Modified db pages 0
  128. Pending reads 0
  129. Pending writes: LRU 0, flush list 0, single page 0
  130. Pages made young 0, not young 0
  131. 0.00 youngs/s, 0.00 non-youngs/s
  132. Pages read 22600, created 4028, written 8845
  133. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  134. No buffer pool page gets since the last printout
  135. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  136. LRU len: 26628, unzip_LRU len: 0
  137. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  138. ----------------------
  139. INDIVIDUAL BUFFER POOL INFO
  140. ----------------------
  141. ---BUFFER POOL 0
  142. Buffer pool size 16382
  143. Free buffers 13366
  144. Database pages 3015
  145. Old database pages 1092
  146. Modified db pages 0
  147. Pending reads 0
  148. Pending writes: LRU 0, flush list 0, single page 0
  149. Pages made young 0, not young 0
  150. 0.00 youngs/s, 0.00 non-youngs/s
  151. Pages read 2468, created 547, written 941
  152. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  153. No buffer pool page gets since the last printout
  154. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  155. LRU len: 3015, unzip_LRU len: 0
  156. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  157. ---BUFFER POOL 1
  158. Buffer pool size 16382
  159. Free buffers 12417
  160. Database pages 3965
  161. Old database pages 1443
  162. Modified db pages 0
  163. Pending reads 0
  164. Pending writes: LRU 0, flush list 0, single page 0
  165. Pages made young 0, not young 0
  166. 0.00 youngs/s, 0.00 non-youngs/s
  167. Pages read 3459, created 506, written 1103
  168. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  169. No buffer pool page gets since the last printout
  170. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  171. LRU len: 3965, unzip_LRU len: 0
  172. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  173. ---BUFFER POOL 2
  174. Buffer pool size 16382
  175. Free buffers 13539
  176. Database pages 2843
  177. Old database pages 1029
  178. Modified db pages 0
  179. Pending reads 0
  180. Pending writes: LRU 0, flush list 0, single page 0
  181. Pages made young 0, not young 0
  182. 0.00 youngs/s, 0.00 non-youngs/s
  183. Pages read 2395, created 448, written 1168
  184. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  185. No buffer pool page gets since the last printout
  186. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  187. LRU len: 2843, unzip_LRU len: 0
  188. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  189. ---BUFFER POOL 3
  190. Buffer pool size 16382
  191. Free buffers 12998
  192. Database pages 3384
  193. Old database pages 1229
  194. Modified db pages 0
  195. Pending reads 0
  196. Pending writes: LRU 0, flush list 0, single page 0
  197. Pages made young 0, not young 0
  198. 0.00 youngs/s, 0.00 non-youngs/s
  199. Pages read 2936, created 448, written 705
  200. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  201. No buffer pool page gets since the last printout
  202. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  203. LRU len: 3384, unzip_LRU len: 0
  204. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  205. ---BUFFER POOL 4
  206. Buffer pool size 16382
  207. Free buffers 12418
  208. Database pages 3964
  209. Old database pages 1443
  210. Modified db pages 0
  211. Pending reads 0
  212. Pending writes: LRU 0, flush list 0, single page 0
  213. Pages made young 0, not young 0
  214. 0.00 youngs/s, 0.00 non-youngs/s
  215. Pages read 3421, created 543, written 1376
  216. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  217. No buffer pool page gets since the last printout
  218. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  219. LRU len: 3964, unzip_LRU len: 0
  220. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  221. ---BUFFER POOL 5
  222. Buffer pool size 16382
  223. Free buffers 13727
  224. Database pages 2655
  225. Old database pages 960
  226. Modified db pages 0
  227. Pending reads 0
  228. Pending writes: LRU 0, flush list 0, single page 0
  229. Pages made young 0, not young 0
  230. 0.00 youngs/s, 0.00 non-youngs/s
  231. Pages read 2143, created 512, written 1022
  232. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  233. No buffer pool page gets since the last printout
  234. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  235. LRU len: 2655, unzip_LRU len: 0
  236. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  237. ---BUFFER POOL 6
  238. Buffer pool size 16382
  239. Free buffers 12951
  240. Database pages 3430
  241. Old database pages 1247
  242. Modified db pages 0
  243. Pending reads 0
  244. Pending writes: LRU 0, flush list 0, single page 0
  245. Pages made young 0, not young 0
  246. 0.00 youngs/s, 0.00 non-youngs/s
  247. Pages read 2918, created 512, written 1087
  248. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  249. No buffer pool page gets since the last printout
  250. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  251. LRU len: 3430, unzip_LRU len: 0
  252. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  253. ---BUFFER POOL 7
  254. Buffer pool size 16382
  255. Free buffers 13010
  256. Database pages 3372
  257. Old database pages 1225
  258. Modified db pages 0
  259. Pending reads 0
  260. Pending writes: LRU 0, flush list 0, single page 0
  261. Pages made young 0, not young 0
  262. 0.00 youngs/s, 0.00 non-youngs/s
  263. Pages read 2860, created 512, written 1443
  264. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  265. No buffer pool page gets since the last printout
  266. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  267. LRU len: 3372, unzip_LRU len: 0
  268. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  269. --------------
  270. ROW OPERATIONS
  271. --------------
  272. 0 queries inside InnoDB, 0 queries in queue
  273. 0 read views open inside InnoDB
  274. Process ID=78569, Main thread ID=123145451253760, state: sleeping
  275. Number of rows inserted 44, updated 0, deleted 1122166, read 472967716
  276. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  277. ----------------------------
  278. END OF INNODB MONITOR OUTPUT
  279. ============================
RAW Paste Data