API tools faq
paste
Advertisement
KevinDundee

ShowEngineInnodbStatus

KevinDundee
Nov 17th, 2017
564
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.12 KB | None | 0 0
raw download clone embed print report
  1. ----------------------------------------------------------------------------------------+
  2. | InnoDB | |
  3. =====================================
  4. 2017-11-17 14:14:30 0x20c8 INNODB MONITOR OUTPUT
  5. =====================================
  6. Per second averages calculated from the last 3 seconds
  7. -----------------
  8. BACKGROUND THREAD
  9. -----------------
  10. srv_master_thread loops: 4 srv_active, 0 srv_shutdown, 1 srv_idle
  11. srv_master_thread log flush and writes: 4
  12. ----------
  13. SEMAPHORES
  14. ----------
  15. OS WAIT ARRAY INFO: reservation count 5937
  16. --Thread 9852 has waited at srv0srv.cc line 1968 for 55.00 seconds the semaphore:
  17. X-lock (wait_ex) on RW-latch at 0000009F7D63E9C8 created in file dict0dict.cc line 1184
  18. a writer (thread id 9852) has reserved it in mode wait exclusive
  19. number of readers 1, waiters flag 1, lock_word: ffffffff
  20. Last time read locked in file row0undo.cc line 319
  21. Last time write locked in file G:\ade\build\sb_0-20577873-1475083314.04\mysql-5.7.16\storage\innobase\fts\fts0fts.cc line 7574
  22. --Thread 3760 has waited at row0purge.cc line 861 for 30.00 seconds the semaphore:
  23. S-lock on RW-latch at 0000009F7D63E9C8 created in file dict0dict.cc line 1184
  24. a writer (thread id 9852) has reserved it in mode wait exclusive
  25. number of readers 1, waiters flag 1, lock_word: ffffffff
  26. Last time read locked in file row0undo.cc line 319
  27. Last time write locked in file G:\ade\build\sb_0-20577873-1475083314.04\mysql-5.7.16\storage\innobase\fts\fts0fts.cc line 7574
  28. --Thread 9380 has waited at row0purge.cc line 861 for 30.00 seconds the semaphore:
  29. S-lock on RW-latch at 0000009F7D63E9C8 created in file dict0dict.cc line 1184
  30. a writer (thread id 9852) has reserved it in mode wait exclusive
  31. number of readers 1, waiters flag 1, lock_word: ffffffff
  32. Last time read locked in file row0undo.cc line 319
  33. Last time write locked in file G:\ade\build\sb_0-20577873-1475083314.04\mysql-5.7.16\storage\innobase\fts\fts0fts.cc line 7574
  34. --Thread 5648 has waited at row0purge.cc line 861 for 30.00 seconds the semaphore:
  35. S-lock on RW-latch at 0000009F7D63E9C8 created in file dict0dict.cc line 1184
  36. a writer (thread id 9852) has reserved it in mode wait exclusive
  37. number of readers 1, waiters flag 1, lock_word: ffffffff
  38. Last time read locked in file row0undo.cc line 319
  39. Last time write locked in file G:\ade\build\sb_0-20577873-1475083314.04\mysql-5.7.16\storage\innobase\fts\fts0fts.cc line 7574
  40. --Thread 10020 has waited at row0purge.cc line 861 for 30.00 seconds the semaphore:
  41. S-lock on RW-latch at 0000009F7D63E9C8 created in file dict0dict.cc line 1184
  42. a writer (thread id 9852) has reserved it in mode wait exclusive
  43. number of readers 1, waiters flag 1, lock_word: ffffffff
  44. Last time read locked in file row0undo.cc line 319
  45. Last time write locked in file G:\ade\build\sb_0-20577873-1475083314.04\mysql-5.7.16\storage\innobase\fts\fts0fts.cc line 7574
  46. OS WAIT ARRAY INFO: signal count 2046
  47. RW-shared spins 0, rounds 2325, OS waits 1173
  48. RW-excl spins 0, rounds 5940, OS waits 180
  49. RW-sx spins 1, rounds 30, OS waits 1
  50. Spin rounds per wait: 2325.00 RW-shared, 5940.00 RW-excl, 30.00 RW-sx
  51. ------------
  52. TRANSACTIONS
  53. ------------
  54. Trx id counter 331364162
  55. Purge done for trx's n:o < 329566520 undo n:o < 0 state: running
  56. History list length 728759
  57. LIST OF TRANSACTIONS FOR EACH SESSION:
  58. ---TRANSACTION 282159827673448, not started
  59. 0 lock struct(s), heap size 1136, 0 row lock(s)
  60. ---TRANSACTION 282159827677808, not started
  61. 0 lock struct(s), heap size 1136, 0 row lock(s)
  62. ---TRANSACTION 282159827674320, not started
  63. mysql tables in use 11, locked 0
  64. 0 lock struct(s), heap size 1136, 0 row lock(s)
  65. ---TRANSACTION 282159827676064, not started
  66. 0 lock struct(s), heap size 1136, 0 row lock(s)
  67. ---TRANSACTION 282159827672576, not started
  68. 0 lock struct(s), heap size 1136, 0 row lock(s)
  69. ---TRANSACTION 282159827671704, not started estimating records in index range
  70. mysql tables in use 1, locked 0
  71. 0 lock struct(s), heap size 1136, 0 row lock(s)
  72. ---TRANSACTION 309725166, ACTIVE 358 sec recovered trx
  73. ROLLING BACK 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17856916
  74. --------
  75. FILE I/O
  76. --------
  77. I/O thread 0 state: wait Windows aio (insert buffer thread)
  78. I/O thread 1 state: wait Windows aio (log thread)
  79. I/O thread 2 state: wait Windows aio (read thread)
  80. I/O thread 3 state: wait Windows aio (read thread)
  81. I/O thread 4 state: wait Windows aio (read thread)
  82. I/O thread 5 state: wait Windows aio (read thread)
  83. I/O thread 6 state: wait Windows aio (read thread)
  84. I/O thread 7 state: wait Windows aio (read thread)
  85. I/O thread 8 state: wait Windows aio (read thread)
  86. I/O thread 9 state: wait Windows aio (read thread)
  87. I/O thread 10 state: wait Windows aio (read thread)
  88. I/O thread 11 state: wait Windows aio (read thread)
  89. I/O thread 12 state: wait Windows aio (read thread)
  90. I/O thread 13 state: wait Windows aio (read thread)
  91. I/O thread 14 state: wait Windows aio (read thread)
  92. I/O thread 15 state: wait Windows aio (read thread)
  93. I/O thread 16 state: wait Windows aio (read thread)
  94. I/O thread 17 state: wait Windows aio (read thread)
  95. I/O thread 18 state: wait Windows aio (read thread)
  96. I/O thread 19 state: wait Windows aio (read thread)
  97. I/O thread 20 state: wait Windows aio (read thread)
  98. I/O thread 21 state: wait Windows aio (read thread)
  99. I/O thread 22 state: wait Windows aio (read thread)
  100. I/O thread 23 state: wait Windows aio (read thread)
  101. I/O thread 24 state: wait Windows aio (read thread)
  102. I/O thread 25 state: wait Windows aio (read thread)
  103. I/O thread 26 state: wait Windows aio (read thread)
  104. I/O thread 27 state: wait Windows aio (read thread)
  105. I/O thread 28 state: wait Windows aio (read thread)
  106. I/O thread 29 state: wait Windows aio (read thread)
  107. I/O thread 30 state: wait Windows aio (read thread)
  108. I/O thread 31 state: wait Windows aio (read thread)
  109. I/O thread 32 state: wait Windows aio (read thread)
  110. I/O thread 33 state: wait Windows aio (read thread)
  111. I/O thread 34 state: wait Windows aio (read thread)
  112. I/O thread 35 state: wait Windows aio (read thread)
  113. I/O thread 36 state: wait Windows aio (read thread)
  114. I/O thread 37 state: wait Windows aio (read thread)
  115. I/O thread 38 state: wait Windows aio (read thread)
  116. I/O thread 39 state: wait Windows aio (read thread)
  117. I/O thread 40 state: wait Windows aio (read thread)
  118. I/O thread 41 state: wait Windows aio (read thread)
  119. I/O thread 42 state: wait Windows aio (read thread)
  120. I/O thread 43 state: wait Windows aio (read thread)
  121. I/O thread 44 state: wait Windows aio (read thread)
  122. I/O thread 45 state: wait Windows aio (read thread)
  123. I/O thread 46 state: wait Windows aio (read thread)
  124. I/O thread 47 state: wait Windows aio (read thread)
  125. I/O thread 48 state: wait Windows aio (read thread)
  126. I/O thread 49 state: wait Windows aio (read thread)
  127. I/O thread 50 state: wait Windows aio (read thread)
  128. I/O thread 51 state: wait Windows aio (read thread)
  129. I/O thread 52 state: wait Windows aio (read thread)
  130. I/O thread 53 state: wait Windows aio (read thread)
  131. I/O thread 54 state: wait Windows aio (read thread)
  132. I/O thread 55 state: wait Windows aio (read thread)
  133. I/O thread 56 state: wait Windows aio (read thread)
  134. I/O thread 57 state: wait Windows aio (read thread)
  135. I/O thread 58 state: wait Windows aio (read thread)
  136. I/O thread 59 state: wait Windows aio (read thread)
  137. I/O thread 60 state: wait Windows aio (read thread)
  138. I/O thread 61 state: wait Windows aio (read thread)
  139. I/O thread 62 state: wait Windows aio (read thread)
  140. I/O thread 63 state: wait Windows aio (read thread)
  141. I/O thread 64 state: wait Windows aio (read thread)
  142. I/O thread 65 state: wait Windows aio (read thread)
  143. I/O thread 66 state: wait Windows aio (write thread)
  144. I/O thread 67 state: wait Windows aio (write thread)
  145. I/O thread 68 state: wait Windows aio (write thread)
  146. I/O thread 69 state: wait Windows aio (write thread)
  147. I/O thread 70 state: wait Windows aio (write thread)
  148. I/O thread 71 state: wait Windows aio (write thread)
  149. I/O thread 72 state: wait Windows aio (write thread)
  150. I/O thread 73 state: wait Windows aio (write thread)
  151. I/O thread 74 state: wait Windows aio (write thread)
  152. I/O thread 75 state: wait Windows aio (write thread)
  153. I/O thread 76 state: wait Windows aio (write thread)
  154. I/O thread 77 state: wait Windows aio (write thread)
  155. I/O thread 78 state: wait Windows aio (write thread)
  156. I/O thread 79 state: wait Windows aio (write thread)
  157. I/O thread 80 state: wait Windows aio (write thread)
  158. I/O thread 81 state: wait Windows aio (write thread)
  159. 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
  160. 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] ,
  161. ibuf aio reads:, log i/o's:, sync i/o's:
  162. Pending flushes (fsync) log: 0; buffer pool: 0
  163. 109792 OS file reads, 2011 OS file writes, 656 OS fsyncs
  164. 172.94 reads/s, 16384 avg bytes/read, 10.66 writes/s, 3.67 fsyncs/s
  165. -------------------------------------
  166. INSERT BUFFER AND ADAPTIVE HASH INDEX
  167. -------------------------------------
  168. Ibuf: size 14, free list len 1099, seg size 1114, 688 merges
  169. merged operations:
  170. insert 11056, delete mark 180, delete 0
  171. discarded operations:
  172. insert 0, delete mark 0, delete 0
  173. Hash table size 34679, node heap has 0 buffer(s)
  174. Hash table size 34679, node heap has 0 buffer(s)
  175. Hash table size 34679, node heap has 0 buffer(s)
  176. Hash table size 34679, node heap has 0 buffer(s)
  177. Hash table size 34679, node heap has 0 buffer(s)
  178. Hash table size 34679, node heap has 0 buffer(s)
  179. Hash table size 34679, node heap has 0 buffer(s)
  180. Hash table size 34679, node heap has 0 buffer(s)
  181. 0.00 hash searches/s, 1432.86 non-hash searches/s
  182. ---
  183. LOG
  184. ---
  185. Log sequence number 619518026531
  186. Log flushed up to 619518010674
  187. Pages flushed up to 619517997193
  188. Last checkpoint at 619478986174
  189. 0 pending log flushes, 0 pending chkp writes
  190. 751 log i/o's done, 4.33 log i/o's/second
  191. ----------------------
  192. BUFFER POOL AND MEMORY
  193. ----------------------
  194. Total large memory allocated 137297920
  195. Dictionary memory allocated 1892774
  196. Buffer pool size 8192
  197. Free buffers 942
  198. Database pages 7250
  199. Old database pages 2696
  200. Modified db pages 68
  201. Pending reads 2
  202. Pending writes: LRU 0, flush list 0, single page 0
  203. Pages made young 2281, not young 189145
  204. 23.99 youngs/s, 1306.90 non-youngs/s
  205. Pages read 107664, created 52, written 1739
  206. 173.61 reads/s, 0.33 creates/s, 5.33 writes/s
  207. Buffer pool hit rate 968 / 1000, young-making rate 4 / 1000 not 247 / 1000
  208. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  209. LRU len: 7250, unzip_LRU len: 0
  210. I/O sum[6963]:cur[8], unzip sum[0]:cur[0]
  211. --------------
  212. ROW OPERATIONS
  213. --------------
  214. 0 queries inside InnoDB, 0 queries in queue
  215. 0 read views open inside InnoDB
  216. Process ID=4140, Main thread ID=9852, state: enforcing dict cache limit
  217. Number of rows inserted 428, updated 1033, deleted 0, read 455088
  218. 2.67 inserts/s, 29.32 updates/s, 0.00 deletes/s, 81.31 reads/s
  219. ----------------------------
  220. END OF INNODB MONITOR OUTPUT
  221. ============================
  222. +--------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------
  223. |
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!