API tools faq
paste
TELA9

ENGINE INNODB STATUS

TELA9
Mar 29th, 2019
330
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 26.42 KB | None | 0 0
raw download clone embed print report
  1. mysql> SHOW ENGINE INNODB STATUS;
  2. +--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | Type   | Name | Status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
  4. +--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | InnoDB |      |
  6. =====================================
  7. 2019-03-29 20:53:30 0x7f7e7bdb1700 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 36 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 2134 srv_active, 0 srv_shutdown, 106185 srv_idle
  14. srv_master_thread log flush and writes: 108307
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 12404
  19. OS WAIT ARRAY INFO: signal count 8893
  20. RW-shared spins 0, rounds 1902, OS waits 919
  21. RW-excl spins 0, rounds 723, OS waits 22
  22. RW-sx spins 22, rounds 498, OS waits 10
  23. Spin rounds per wait: 1902.00 RW-shared, 723.00 RW-excl, 22.64 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 9376810
  28. Purge done for trx's n:o < 9376809 undo n:o < 0 state: running but idle
  29. History list length 12
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421665469175648, not started
  32. 0 lock struct(s), heap size 1136, 0 row lock(s)
  33. --------
  34. FILE I/O
  35. --------
  36. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  37. I/O thread 1 state: waiting for completed aio requests (log 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. I/O thread 9 state: waiting for completed aio requests (write thread)
  46. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  47. ibuf aio reads:, log i/o's:, sync i/o's:
  48. Pending flushes (fsync) log: 0; buffer pool: 0
  49. 70991 OS file reads, 27712 OS file writes, 10930 OS fsyncs
  50. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  51. -------------------------------------
  52. INSERT BUFFER AND ADAPTIVE HASH INDEX
  53. -------------------------------------
  54. Ibuf: size 1, free list len 0, seg size 2, 92 merges
  55. merged operations:
  56. insert 34, delete mark 12, delete 0
  57. discarded operations:
  58. insert 0, delete mark 0, delete 0
  59. Hash table size 2365313, node heap has 11 buffer(s)
  60. Hash table size 2365313, node heap has 171 buffer(s)
  61. Hash table size 2365313, node heap has 266 buffer(s)
  62. Hash table size 2365313, node heap has 12 buffer(s)
  63. Hash table size 2365313, node heap has 292 buffer(s)
  64. Hash table size 2365313, node heap has 2 buffer(s)
  65. Hash table size 2365313, node heap has 184 buffer(s)
  66. Hash table size 2365313, node heap has 6 buffer(s)
  67. 0.00 hash searches/s, 0.00 non-hash searches/s
  68. ---
  69. LOG
  70. ---
  71. Log sequence number 6083235939
  72. Log flushed up to   6083235939
  73. Pages flushed up to 6083235939
  74. Last checkpoint at  6083235930
  75. 0 pending log flushes, 0 pending chkp writes
  76. 6804 log i/o's done, 0.00 log i/o's/second
  77. ----------------------
  78. BUFFER POOL AND MEMORY
  79. ----------------------
  80. Total large memory allocated 8795455488
  81. Dictionary memory allocated 634570
  82. Buffer pool size   524240
  83. Free buffers       451509
  84. Database pages     71787
  85. Old database pages 26417
  86. Modified db pages  0
  87. Pending reads      0
  88. Pending writes: LRU 0, flush list 0, single page 0
  89. Pages made young 857197, not young 39921
  90. 0.00 youngs/s, 0.00 non-youngs/s
  91. Pages read 70910, created 973, written 19211
  92. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  93. No buffer pool page gets since the last printout
  94. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  95. LRU len: 71787, unzip_LRU len: 0
  96. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  97. ----------------------
  98. INDIVIDUAL BUFFER POOL INFO
  99. ----------------------
  100. ---BUFFER POOL 0
  101. Buffer pool size   131056
  102. Free buffers       113212
  103. Database pages     17608
  104. Old database pages 6479
  105. Modified db pages  0
  106. Pending reads      0
  107. Pending writes: LRU 0, flush list 0, single page 0
  108. Pages made young 251899, not young 9529
  109. 0.00 youngs/s, 0.00 non-youngs/s
  110. Pages read 17406, created 226, written 5147
  111. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  112. No buffer pool page gets since the last printout
  113. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  114. LRU len: 17608, unzip_LRU len: 0
  115. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  116. ---BUFFER POOL 1
  117. Buffer pool size   131056
  118. Free buffers       113122
  119. Database pages     17699
  120. Old database pages 6513
  121. Modified db pages  0
  122. Pending reads      0
  123. Pending writes: LRU 0, flush list 0, single page 0
  124. Pages made young 219828, not young 5683
  125. 0.00 youngs/s, 0.00 non-youngs/s
  126. Pages read 17526, created 197, written 2311
  127. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  128. No buffer pool page gets since the last printout
  129. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  130. LRU len: 17699, unzip_LRU len: 0
  131. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  132. ---BUFFER POOL 2
  133. Buffer pool size   131056
  134. Free buffers       112633
  135. Database pages     18189
  136. Old database pages 6694
  137. Modified db pages  0
  138. Pending reads      0
  139. Pending writes: LRU 0, flush list 0, single page 0
  140. Pages made young 206248, not young 9130
  141. 0.00 youngs/s, 0.00 non-youngs/s
  142. Pages read 18005, created 208, written 2257
  143. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  144. No buffer pool page gets since the last printout
  145. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  146. LRU len: 18189, unzip_LRU len: 0
  147. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  148. ---BUFFER POOL 3
  149. Buffer pool size   131072
  150. Free buffers       112542
  151. Database pages     18291
  152. Old database pages 6731
  153. Modified db pages  0
  154. Pending reads      0
  155. Pending writes: LRU 0, flush list 0, single page 0
  156. Pages made young 179222, not young 15579
  157. 0.00 youngs/s, 0.00 non-youngs/s
  158. Pages read 17973, created 342, written 9496
  159. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  160. No buffer pool page gets since the last printout
  161. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  162. LRU len: 18291, unzip_LRU len: 0
  163. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  164. --------------
  165. ROW OPERATIONS
  166. --------------
  167. 0 queries inside InnoDB, 0 queries in queue
  168. 0 read views open inside InnoDB
  169. Process ID=1466, Main thread ID=140181273302784, state: sleeping
  170. Number of rows inserted 10611013, updated 3066, deleted 463, read 421528787
  171. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  172. ----------------------------
  173. END OF INNODB MONITOR OUTPUT
  174. ============================
  175. |
  176. +--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  177. 1 row in set (0.00 sec)
Add Comment
Please, Sign In to add comment
Public Pastes
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!