API tools faq
paste
Advertisement
herhor67

MYSQL innodb monitor for dba.stack

herhor67
Jul 29th, 2023 (edited)
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.27 KB | None | 0 0
raw download clone embed print report
  1. | InnoDB | |
  2. =====================================
  3. 2023-07-29 21:50:41 140473485739584 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 21 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 1415 srv_active, 0 srv_shutdown, 146345 srv_idle
  10. srv_master_thread log flush and writes: 0
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 50125
  15. OS WAIT ARRAY INFO: signal count 65817
  16. RW-shared spins 0, rounds 0, OS waits 0
  17. RW-excl spins 0, rounds 0, OS waits 0
  18. RW-sx spins 0, rounds 0, OS waits 0
  19. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 288636638
  24. Purge done for trx's n:o < 288636637 undo n:o < 0 state: running but idle
  25. History list length 0
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 421953560673496, not started
  28. 0 lock struct(s), heap size 1128, 0 row lock(s)
  29. ---TRANSACTION 421953560672688, not started
  30. 0 lock struct(s), heap size 1128, 0 row lock(s)
  31. ---TRANSACTION 421953560671880, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. --------
  34. FILE I/O
  35. --------
  36. I/O thread 0 state: waiting for completed aio requests ((null))
  37. I/O thread 1 state: waiting for completed aio requests (insert buffer thread)
  38. I/O thread 2 state: waiting for completed aio requests (read thread)
  39. I/O thread 3 state: waiting for completed aio requests (read thread)
  40. I/O thread 4 state: waiting for completed aio requests (read thread)
  41. I/O thread 5 state: waiting for completed aio requests (read thread)
  42. I/O thread 6 state: waiting for completed aio requests (write thread)
  43. I/O thread 7 state: waiting for completed aio requests (write thread)
  44. I/O thread 8 state: waiting for completed aio requests (write thread)
  45. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  46. ibuf aio reads:
  47. Pending flushes (fsync) log: 0; buffer pool: 0
  48. 3689227 OS file reads, 6134094 OS file writes, 338655 OS fsyncs
  49. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  50. -------------------------------------
  51. INSERT BUFFER AND ADAPTIVE HASH INDEX
  52. -------------------------------------
  53. Ibuf: size 5, free list len 35800, seg size 35806, 0 merges
  54. merged operations:
  55. insert 0, delete mark 0, delete 0
  56. discarded operations:
  57. insert 0, delete mark 0, delete 0
  58. Hash table size 1106407, node heap has 312 buffer(s)
  59. Hash table size 1106407, node heap has 36 buffer(s)
  60. Hash table size 1106407, node heap has 349 buffer(s)
  61. Hash table size 1106407, node heap has 34 buffer(s)
  62. Hash table size 1106407, node heap has 82 buffer(s)
  63. Hash table size 1106407, node heap has 88 buffer(s)
  64. Hash table size 1106407, node heap has 65 buffer(s)
  65. Hash table size 1106407, node heap has 24 buffer(s)
  66. 0.00 hash searches/s, 0.00 non-hash searches/s
  67. ---
  68. LOG
  69. ---
  70. Log sequence number 1032624029300
  71. Log buffer assigned up to 1032624029300
  72. Log buffer completed up to 1032624029300
  73. Log written up to 1032624029300
  74. Log flushed up to 1032624029300
  75. Added dirty pages up to 1032624029300
  76. Pages flushed up to 1032624029300
  77. Last checkpoint at 1032624029300
  78. Log minimum file id is 213960
  79. Log maximum file id is 213962
  80. 4924376 log i/o's done, 0.00 log i/o's/second
  81. ----------------------
  82. BUFFER POOL AND MEMORY
  83. ----------------------
  84. Total large memory allocated 0
  85. Dictionary memory allocated 25561027
  86. Buffer pool size 262120
  87. Free buffers 8190
  88. Database pages 252940
  89. Old database pages 93207
  90. Modified db pages 0
  91. Pending reads 0
  92. Pending writes: LRU 0, flush list 0, single page 0
  93. Pages made young 53305, not young 81164621
  94. 0.00 youngs/s, 0.00 non-youngs/s
  95. Pages read 3677205, created 810891, written 934422
  96. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  97. No buffer pool page gets since the last printout
  98. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  99. LRU len: 252940, unzip_LRU len: 0
  100. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  101. ----------------------
  102. INDIVIDUAL BUFFER POOL INFO
  103. ----------------------
  104. ---BUFFER POOL 0
  105. Buffer pool size 32765
  106. Free buffers 1024
  107. Database pages 31616
  108. Old database pages 11650
  109. Modified db pages 0
  110. Pending reads 0
  111. Pending writes: LRU 0, flush list 0, single page 0
  112. Pages made young 6316, not young 10314379
  113. 0.00 youngs/s, 0.00 non-youngs/s
  114. Pages read 469749, created 101517, written 117037
  115. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  116. No buffer pool page gets since the last printout
  117. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  118. LRU len: 31616, unzip_LRU len: 0
  119. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  120. ---BUFFER POOL 1
  121. Buffer pool size 32764
  122. Free buffers 1024
  123. Database pages 31630
  124. Old database pages 11655
  125. Modified db pages 0
  126. Pending reads 0
  127. Pending writes: LRU 0, flush list 0, single page 0
  128. Pages made young 6335, not young 10254394
  129. 0.00 youngs/s, 0.00 non-youngs/s
  130. Pages read 451456, created 103081, written 117717
  131. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  132. No buffer pool page gets since the last printout
  133. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  134. LRU len: 31630, unzip_LRU len: 0
  135. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  136. ---BUFFER POOL 2
  137. Buffer pool size 32764
  138. Free buffers 1024
  139. Database pages 31612
  140. Old database pages 11649
  141. Modified db pages 0
  142. Pending reads 0
  143. Pending writes: LRU 0, flush list 0, single page 0
  144. Pages made young 6236, not young 10165269
  145. 0.00 youngs/s, 0.00 non-youngs/s
  146. Pages read 455067, created 99773, written 114369
  147. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  148. No buffer pool page gets since the last printout
  149. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  150. LRU len: 31612, unzip_LRU len: 0
  151. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  152. ---BUFFER POOL 3
  153. Buffer pool size 32767
  154. Free buffers 1024
  155. Database pages 31611
  156. Old database pages 11648
  157. Modified db pages 0
  158. Pending reads 0
  159. Pending writes: LRU 0, flush list 0, single page 0
  160. Pages made young 6083, not young 10012204
  161. 0.00 youngs/s, 0.00 non-youngs/s
  162. Pages read 452499, created 98421, written 113192
  163. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  164. No buffer pool page gets since the last printout
  165. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  166. LRU len: 31611, unzip_LRU len: 0
  167. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  168. ---BUFFER POOL 4
  169. Buffer pool size 32764
  170. Free buffers 1024
  171. Database pages 31622
  172. Old database pages 11652
  173. Modified db pages 0
  174. Pending reads 0
  175. Pending writes: LRU 0, flush list 0, single page 0
  176. Pages made young 6600, not young 10158298
  177. 0.00 youngs/s, 0.00 non-youngs/s
  178. Pages read 464824, created 103263, written 118990
  179. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  180. No buffer pool page gets since the last printout
  181. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  182. LRU len: 31622, unzip_LRU len: 0
  183. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  184. ---BUFFER POOL 5
  185. Buffer pool size 32766
  186. Free buffers 1024
  187. Database pages 31601
  188. Old database pages 11645
  189. Modified db pages 0
  190. Pending reads 0
  191. Pending writes: LRU 0, flush list 0, single page 0
  192. Pages made young 6551, not young 9893828
  193. 0.00 youngs/s, 0.00 non-youngs/s
  194. Pages read 453452, created 101100, written 117597
  195. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  196. No buffer pool page gets since the last printout
  197. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  198. LRU len: 31601, unzip_LRU len: 0
  199. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  200. ---BUFFER POOL 6
  201. Buffer pool size 32764
  202. Free buffers 1022
  203. Database pages 31616
  204. Old database pages 11652
  205. Modified db pages 0
  206. Pending reads 0
  207. Pending writes: LRU 0, flush list 0, single page 0
  208. Pages made young 6577, not young 10361797
  209. 0.00 youngs/s, 0.00 non-youngs/s
  210. Pages read 461371, created 104674, written 121355
  211. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  212. No buffer pool page gets since the last printout
  213. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  214. LRU len: 31616, unzip_LRU len: 0
  215. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  216. ---BUFFER POOL 7
  217. Buffer pool size 32766
  218. Free buffers 1024
  219. Database pages 31632
  220. Old database pages 11656
  221. Modified db pages 0
  222. Pending reads 0
  223. Pending writes: LRU 0, flush list 0, single page 0
  224. Pages made young 8607, not young 10004452
  225. 0.00 youngs/s, 0.00 non-youngs/s
  226. Pages read 468787, created 99062, written 114165
  227. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  228. No buffer pool page gets since the last printout
  229. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  230. LRU len: 31632, unzip_LRU len: 0
  231. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  232. --------------
  233. ROW OPERATIONS
  234. --------------
  235. 0 queries inside InnoDB, 0 queries in queue
  236. 0 read views open inside InnoDB
  237. Process ID=26648, Main thread ID=140473506743872 , state=sleeping
  238. Number of rows inserted 147076188, updated 38327, deleted 186, read 572919279
  239. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  240. Number of system rows inserted 196, updated 531, deleted 147, read 1073583
  241. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  242. ----------------------------
  243. END OF INNODB MONITOR OUTPUT
  244. ============================
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!