API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 13th, 2020
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.86 KB | None | 0 0
raw download clone embed print report
  1. InnoDB
  2. =====================================
  3. 2020-07-13 17:22:51 0x7f6d09f3a700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 9 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 169221 srv_active, 0 srv_shutdown, 41265 srv_idle
  10. srv_master_thread log flush and writes: 210486
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 1250353
  15. OS WAIT ARRAY INFO: signal count 3064584
  16. RW-shared spins 0, rounds 4176217, OS waits 444923
  17. RW-excl spins 0, rounds 31600465, OS waits 453093
  18. RW-sx spins 732230, rounds 4327550, OS waits 37927
  19. Spin rounds per wait: 4176217.00 RW-shared, 31600465.00 RW-excl, 5.91 RW-sx
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 351861390
  24. Purge done for trx's n:o < 351861389 undo n:o < 0 state: running but idle
  25. History list length 3
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 421584140973904, not started
  28. 0 lock struct(s), heap size 1136, 0 row lock(s)
  29. ---TRANSACTION 421584140996704, not started
  30. 0 lock struct(s), heap size 1136, 0 row lock(s)
  31. ---TRANSACTION 421584140995792, not started
  32. 0 lock struct(s), heap size 1136, 0 row lock(s)
  33. ---TRANSACTION 421584140981200, not started
  34. 0 lock struct(s), heap size 1136, 0 row lock(s)
  35. ---TRANSACTION 421584140993968, not started
  36. 0 lock struct(s), heap size 1136, 0 row lock(s)
  37. ---TRANSACTION 421584140993056, not started
  38. 0 lock struct(s), heap size 1136, 0 row lock(s)
  39. ---TRANSACTION 421584140992144, not started
  40. 0 lock struct(s), heap size 1136, 0 row lock(s)
  41. ---TRANSACTION 421584140986672, not started
  42. 0 lock struct(s), heap size 1136, 0 row lock(s)
  43. ---TRANSACTION 421584140985760, not started
  44. 0 lock struct(s), heap size 1136, 0 row lock(s)
  45. ---TRANSACTION 421584140984848, not started
  46. 0 lock struct(s), heap size 1136, 0 row lock(s)
  47. ---TRANSACTION 421584140982112, not started
  48. 0 lock struct(s), heap size 1136, 0 row lock(s)
  49. ---TRANSACTION 421584140977552, not started
  50. 0 lock struct(s), heap size 1136, 0 row lock(s)
  51. ---TRANSACTION 421584140974816, not started
  52. 0 lock struct(s), heap size 1136, 0 row lock(s)
  53. ---TRANSACTION 421584140994880, not started
  54. 0 lock struct(s), heap size 1136, 0 row lock(s)
  55. ---TRANSACTION 421584140990320, not started
  56. 0 lock struct(s), heap size 1136, 0 row lock(s)
  57. ---TRANSACTION 421584140988496, not started
  58. 0 lock struct(s), heap size 1136, 0 row lock(s)
  59. ---TRANSACTION 421584140987584, not started
  60. 0 lock struct(s), heap size 1136, 0 row lock(s)
  61. ---TRANSACTION 421584140978464, not started
  62. 0 lock struct(s), heap size 1136, 0 row lock(s)
  63. ---TRANSACTION 421584140991232, not started
  64. 0 lock struct(s), heap size 1136, 0 row lock(s)
  65. ---TRANSACTION 421584140989408, not started
  66. 0 lock struct(s), heap size 1136, 0 row lock(s)
  67. ---TRANSACTION 421584140983936, not started
  68. 0 lock struct(s), heap size 1136, 0 row lock(s)
  69. ---TRANSACTION 421584140983024, not started
  70. 0 lock struct(s), heap size 1136, 0 row lock(s)
  71. ---TRANSACTION 421584140980288, not started
  72. 0 lock struct(s), heap size 1136, 0 row lock(s)
  73. ---TRANSACTION 421584140975728, not started
  74. 0 lock struct(s), heap size 1136, 0 row lock(s)
  75. ---TRANSACTION 421584140979376, not started
  76. 0 lock struct(s), heap size 1136, 0 row lock(s)
  77. ---TRANSACTION 421584140976640, not started
  78. 0 lock struct(s), heap size 1136, 0 row lock(s)
  79. --------
  80. FILE I/O
  81. --------
  82. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  83. I/O thread 1 state: waiting for completed aio requests (log thread)
  84. I/O thread 2 state: waiting for completed aio requests (read thread)
  85. I/O thread 3 state: waiting for completed aio requests (read thread)
  86. I/O thread 4 state: waiting for completed aio requests (read thread)
  87. I/O thread 5 state: waiting for completed aio requests (read thread)
  88. I/O thread 6 state: waiting for completed aio requests (write thread)
  89. I/O thread 7 state: waiting for completed aio requests (write thread)
  90. I/O thread 8 state: waiting for completed aio requests (write thread)
  91. I/O thread 9 state: waiting for completed aio requests (write thread)
  92. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  93. ibuf aio reads:, log i/o's:, sync i/o's:
  94. Pending flushes (fsync) log: 0; buffer pool: 0
  95. 41251832 OS file reads, 14795762 OS file writes, 5882939 OS fsyncs
  96. 93.55 reads/s, 16384 avg bytes/read, 8.00 writes/s, 7.67 fsyncs/s
  97. -------------------------------------
  98. INSERT BUFFER AND ADAPTIVE HASH INDEX
  99. -------------------------------------
  100. Ibuf: size 1, free list len 2016, seg size 2018, 1080801 merges
  101. merged operations:
  102. insert 1401924, delete mark 6295720, delete 560489
  103. discarded operations:
  104. insert 0, delete mark 0, delete 0
  105. Hash table size 553253, node heap has 662 buffer(s)
  106. Hash table size 553253, node heap has 186 buffer(s)
  107. Hash table size 553253, node heap has 7 buffer(s)
  108. Hash table size 553253, node heap has 617 buffer(s)
  109. Hash table size 553253, node heap has 3118 buffer(s)
  110. Hash table size 553253, node heap has 2625 buffer(s)
  111. Hash table size 553253, node heap has 1244 buffer(s)
  112. Hash table size 553253, node heap has 691 buffer(s)
  113. 9130.76 hash searches/s, 1431.29 non-hash searches/s
  114. ---
  115. LOG
  116. ---
  117. Log sequence number 419277907030
  118. Log flushed up to   419277907030
  119. Pages flushed up to 419274845437
  120. Last checkpoint at  419274845437
  121. 0 pending log flushes, 0 pending chkp writes
  122. 4650693 log i/o's done, 6.22 log i/o's/second
  123. ----------------------
  124. BUFFER POOL AND MEMORY
  125. ----------------------
  126. Total large memory allocated 2198863872
  127. Dictionary memory allocated 2481000
  128. Buffer pool size   131072
  129. Free buffers       2048
  130. Database pages     119874
  131. Old database pages 44210
  132. Modified db pages  2548
  133. Pending reads      0
  134. Pending writes: LRU 0, flush list 0, single page 0
  135. Pages made young 23660803, not young 821413571
  136. 0.00 youngs/s, 0.00 non-youngs/s
  137. Pages read 41251747, created 108697, written 9702376
  138. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  139. Buffer pool hit rate 998 / 1000, young-making rate 3 / 1000 not 10 / 1000
  140. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  141. LRU len: 119874, unzip_LRU len: 0
  142. I/O sum[30836]:cur[2], unzip sum[0]:cur[0]
  143. ----------------------
  144. INDIVIDUAL BUFFER POOL INFO
  145. ----------------------
  146. ---BUFFER POOL 0
  147. Buffer pool size   65536
  148. Free buffers       1024
  149. Database pages     59959
  150. Old database pages 22113
  151. Modified db pages  1268
  152. Pending reads      0
  153. Pending writes: LRU 0, flush list 0, single page 0
  154. Pages made young 11478510, not young 390555123
  155. 0.00 youngs/s, 0.00 non-youngs/s
  156. Pages read 20267220, created 48859, written 4614992
  157. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  158. Buffer pool hit rate 998 / 1000, young-making rate 2 / 1000 not 7 / 1000
  159. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  160. LRU len: 59959, unzip_LRU len: 0
  161. I/O sum[15418]:cur[1], unzip sum[0]:cur[0]
  162. ---BUFFER POOL 1
  163. Buffer pool size   65536
  164. Free buffers       1024
  165. Database pages     59915
  166. Old database pages 22097
  167. Modified db pages  1280
  168. Pending reads      0
  169. Pending writes: LRU 0, flush list 0, single page 0
  170. Pages made young 12182293, not young 430858448
  171. 0.00 youngs/s, 0.00 non-youngs/s
  172. Pages read 20984527, created 59838, written 5087384
  173. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  174. Buffer pool hit rate 997 / 1000, young-making rate 3 / 1000 not 16 / 1000
  175. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  176. LRU len: 59915, unzip_LRU len: 0
  177. I/O sum[15418]:cur[1], unzip sum[0]:cur[0]
  178. --------------
  179. ROW OPERATIONS
  180. --------------
  181. 0 queries inside InnoDB, 0 queries in queue
  182. 0 read views open inside InnoDB
  183. Process ID=12590, Main thread ID=140106796783360, state: sleeping
  184. Number of rows inserted 4613103, updated 7656435, deleted 5366509, read 7280891462
  185. 3.44 inserts/s, 5.00 updates/s, 0.00 deletes/s, 17515.39 reads/s
  186. ----------------------------
  187. END OF INNODB MONITOR OUTPUT
  188. ============================
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!