API tools faq
paste
Advertisement
Guest User

49094911-SHOW-ENGINE-INNODB-STATUS

a guest
Mar 5th, 2018
259
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.77 KB | None | 0 0
raw download clone embed print report
  1. InnoDB
  2. =====================================
  3. 2018-03-05 09:44:04 7f831b5d3b00 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 3 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 387 srv_idle
  10. srv_master_thread log flush and writes: 388
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 140
  15. OS WAIT ARRAY INFO: signal count 140
  16. Mutex spin waits 127, rounds 400, OS waits 9
  17. RW-shared spins 131, rounds 3930, OS waits 131
  18. RW-excl spins 0, rounds 0, OS waits 0
  19. Spin rounds per wait: 3.15 mutex, 30.00 RW-shared, 0.00 RW-excl
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 54605
  24. Purge done for trx's n:o < 54052 undo n:o < 0 state: running but idle
  25. History list length 70
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 0, not started
  28. MySQL thread id 5, OS thread handle 0x7f831b5d3b00, query id 95 94.54.99.84 tecdoc init
  29. SHOW ENGINE INNODB STATUS
  30. ---TRANSACTION 54531, not started
  31. MySQL thread id 1, OS thread handle 0x7f8320042b00, query id 0 Waiting for background binlog tasks
  32. --------
  33. FILE I/O
  34. --------
  35. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  36. I/O thread 1 state: waiting for completed aio requests (log thread)
  37. I/O thread 2 state: waiting for completed aio requests (read thread)
  38. I/O thread 3 state: waiting for completed aio requests (read thread)
  39. I/O thread 4 state: waiting for completed aio requests (read thread)
  40. I/O thread 5 state: waiting for completed aio requests (read thread)
  41. I/O thread 6 state: waiting for completed aio requests (write thread)
  42. I/O thread 7 state: waiting for completed aio requests (write thread)
  43. I/O thread 8 state: waiting for completed aio requests (write thread)
  44. I/O thread 9 state: waiting for completed aio requests (write thread)
  45. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  46. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  47. Pending flushes (fsync) log: 0; buffer pool: 0
  48. 35354 OS file reads, 5 OS file writes, 5 OS fsyncs
  49. 255.91 reads/s, 16384 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  50. -------------------------------------
  51. INSERT BUFFER AND ADAPTIVE HASH INDEX
  52. -------------------------------------
  53. Ibuf: size 1, free list len 5920, seg size 5922, 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. 0.00 hash searches/s, 43.32 non-hash searches/s
  59. ---
  60. LOG
  61. ---
  62. Log sequence number 287951632764
  63. Log flushed up to 287951632764
  64. Pages flushed up to 287951632764
  65. Last checkpoint at 287951632764
  66. Max checkpoint age 869019772
  67. Checkpoint age target 841862905
  68. Modified age 0
  69. Checkpoint age 0
  70. 0 pending log writes, 0 pending chkp writes
  71. 8 log i/o's done, 0.00 log i/o's/second
  72. ----------------------
  73. BUFFER POOL AND MEMORY
  74. ----------------------
  75. Total memory allocated 47233105920; in additional pool allocated 0
  76. Total memory allocated by read views 264
  77. Internal hash tables (constant factor + variable factor)
  78. Adaptive hash index 714011408 (713990824 + 20584)
  79. Page hash 5578984 (buffer pool 0 only)
  80. Dictionary cache 179159116 (178499312 + 659804)
  81. File system 914416 (812272 + 102144)
  82. Lock system 111563656 (111562216 + 1440)
  83. Recovery system 0 (0 + 0)
  84. Dictionary memory allocated 659804
  85. Buffer pool size 2752504
  86. Buffer pool size, bytes 45097025536
  87. Free buffers 2717235
  88. Database pages 35268
  89. Old database pages 13174
  90. Modified db pages 0
  91. Percent of dirty pages(LRU & free pages): 0.000
  92. Max dirty pages percent: 75.000
  93. Pending reads 0
  94. Pending writes: LRU 0, flush list 0, single page 0
  95. Pages made young 0, not young 0
  96. 0.00 youngs/s, 0.00 non-youngs/s
  97. Pages read 35268, created 0, written 1
  98. 253.58 reads/s, 0.00 creates/s, 0.00 writes/s
  99. Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 0 / 1000
  100. Pages read ahead 85.30/s, evicted without access 0.00/s, Random read ahead 0.00/s
  101. LRU len: 35268, unzip_LRU len: 0
  102. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  103. ----------------------
  104. INDIVIDUAL BUFFER POOL INFO
  105. ----------------------
  106. ---BUFFER POOL 0
  107. Buffer pool size 344063
  108. Buffer pool size, bytes 5637128192
  109. Free buffers 339534
  110. Database pages 4528
  111. Old database pages 1691
  112. Modified db pages 0
  113. Percent of dirty pages(LRU & free pages): 0.000
  114. Max dirty pages percent: 75.000
  115. Pending reads 0
  116. Pending writes: LRU 0, flush list 0, single page 0
  117. Pages made young 0, not young 0
  118. 0.00 youngs/s, 0.00 non-youngs/s
  119. Pages read 4528, created 0, written 1
  120. 5.00 reads/s, 0.00 creates/s, 0.00 writes/s
  121. Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 0 / 1000
  122. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  123. LRU len: 4528, unzip_LRU len: 0
  124. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  125. ---BUFFER POOL 1
  126. Buffer pool size 344063
  127. Buffer pool size, bytes 5637128192
  128. Free buffers 339653
  129. Database pages 4410
  130. Old database pages 1647
  131. Modified db pages 0
  132. Percent of dirty pages(LRU & free pages): 0.000
  133. Max dirty pages percent: 75.000
  134. Pending reads 0
  135. Pending writes: LRU 0, flush list 0, single page 0
  136. Pages made young 0, not young 0
  137. 0.00 youngs/s, 0.00 non-youngs/s
  138. Pages read 4410, created 0, written 0
  139. 29.32 reads/s, 0.00 creates/s, 0.00 writes/s
  140. Buffer pool hit rate 988 / 1000, young-making rate 0 / 1000 not 0 / 1000
  141. Pages read ahead 21.33/s, evicted without access 0.00/s, Random read ahead 0.00/s
  142. LRU len: 4410, unzip_LRU len: 0
  143. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  144. ---BUFFER POOL 2
  145. Buffer pool size 344063
  146. Buffer pool size, bytes 5637128192
  147. Free buffers 339706
  148. Database pages 4357
  149. Old database pages 1628
  150. Modified db pages 0
  151. Percent of dirty pages(LRU & free pages): 0.000
  152. Max dirty pages percent: 75.000
  153. Pending reads 0
  154. Pending writes: LRU 0, flush list 0, single page 0
  155. Pages made young 0, not young 0
  156. 0.00 youngs/s, 0.00 non-youngs/s
  157. Pages read 4357, created 0, written 0
  158. 21.66 reads/s, 0.00 creates/s, 0.00 writes/s
  159. Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 0 / 1000
  160. Pages read ahead 21.33/s, evicted without access 0.00/s, Random read ahead 0.00/s
  161. LRU len: 4357, unzip_LRU len: 0
  162. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  163. ---BUFFER POOL 3
  164. Buffer pool size 344063
  165. Buffer pool size, bytes 5637128192
  166. Free buffers 339707
  167. Database pages 4356
  168. Old database pages 1627
  169. Modified db pages 0
  170. Percent of dirty pages(LRU & free pages): 0.000
  171. Max dirty pages percent: 75.000
  172. Pending reads 0
  173. Pending writes: LRU 0, flush list 0, single page 0
  174. Pages made young 0, not young 0
  175. 0.00 youngs/s, 0.00 non-youngs/s
  176. Pages read 4356, created 0, written 0
  177. 25.32 reads/s, 0.00 creates/s, 0.00 writes/s
  178. Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 0 / 1000
  179. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  180. LRU len: 4356, unzip_LRU len: 0
  181. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  182. ---BUFFER POOL 4
  183. Buffer pool size 344063
  184. Buffer pool size, bytes 5637128192
  185. Free buffers 339652
  186. Database pages 4411
  187. Old database pages 1648
  188. Modified db pages 0
  189. Percent of dirty pages(LRU & free pages): 0.000
  190. Max dirty pages percent: 75.000
  191. Pending reads 0
  192. Pending writes: LRU 0, flush list 0, single page 0
  193. Pages made young 0, not young 0
  194. 0.00 youngs/s, 0.00 non-youngs/s
  195. Pages read 4411, created 0, written 0
  196. 37.65 reads/s, 0.00 creates/s, 0.00 writes/s
  197. Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 0 / 1000
  198. Pages read ahead 21.33/s, evicted without access 0.00/s, Random read ahead 0.00/s
  199. LRU len: 4411, unzip_LRU len: 0
  200. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  201. ---BUFFER POOL 5
  202. Buffer pool size 344063
  203. Buffer pool size, bytes 5637128192
  204. Free buffers 339627
  205. Database pages 4436
  206. Old database pages 1657
  207. Modified db pages 0
  208. Percent of dirty pages(LRU & free pages): 0.000
  209. Max dirty pages percent: 75.000
  210. Pending reads 0
  211. Pending writes: LRU 0, flush list 0, single page 0
  212. Pages made young 0, not young 0
  213. 0.00 youngs/s, 0.00 non-youngs/s
  214. Pages read 4436, created 0, written 0
  215. 51.98 reads/s, 0.00 creates/s, 0.00 writes/s
  216. Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 0 / 1000
  217. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  218. LRU len: 4436, unzip_LRU len: 0
  219. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  220. ---BUFFER POOL 6
  221. Buffer pool size 344063
  222. Buffer pool size, bytes 5637128192
  223. Free buffers 339624
  224. Database pages 4439
  225. Old database pages 1658
  226. Modified db pages 0
  227. Percent of dirty pages(LRU & free pages): 0.000
  228. Max dirty pages percent: 75.000
  229. Pending reads 0
  230. Pending writes: LRU 0, flush list 0, single page 0
  231. Pages made young 0, not young 0
  232. 0.00 youngs/s, 0.00 non-youngs/s
  233. Pages read 4439, created 0, written 0
  234. 48.32 reads/s, 0.00 creates/s, 0.00 writes/s
  235. Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 0 / 1000
  236. Pages read ahead 21.33/s, evicted without access 0.00/s, Random read ahead 0.00/s
  237. LRU len: 4439, unzip_LRU len: 0
  238. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  239. ---BUFFER POOL 7
  240. Buffer pool size 344063
  241. Buffer pool size, bytes 5637128192
  242. Free buffers 339732
  243. Database pages 4331
  244. Old database pages 1618
  245. Modified db pages 0
  246. Percent of dirty pages(LRU & free pages): 0.000
  247. Max dirty pages percent: 75.000
  248. Pending reads 0
  249. Pending writes: LRU 0, flush list 0, single page 0
  250. Pages made young 0, not young 0
  251. 0.00 youngs/s, 0.00 non-youngs/s
  252. Pages read 4331, created 0, written 0
  253. 34.32 reads/s, 0.00 creates/s, 0.00 writes/s
  254. Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 0 / 1000
  255. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  256. LRU len: 4331, unzip_LRU len: 0
  257. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  258. --------------
  259. ROW OPERATIONS
  260. --------------
  261. 0 queries inside InnoDB, 0 queries in queue
  262. 2 read views open inside InnoDB
  263. 0 RW transactions active inside InnoDB
  264. 0 RO transactions active inside InnoDB
  265. 0 out of 1000 descriptors used
  266. ---OLDEST VIEW---
  267. Normal read view
  268. Read view low limit trx n:o 54568
  269. Read view up limit trx id 54568
  270. Read view low limit trx id 54568
  271. Read view individually stored trx ids:
  272. -----------------
  273. Main thread process no. 14137, id 140151577626368, state: sleeping
  274. Number of rows inserted 0, updated 0, deleted 0, read 18688097
  275. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 201913.03 reads/s
  276. Number of system rows inserted 0, updated 0, deleted 0, read 0
  277. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  278. ----------------------------
  279. END OF INNODB MONITOR OUTPUT
  280. ============================
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!