API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
219
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.10 KB | None | 0 0
raw download clone embed print report
  1. | InnoDB |      |
  2. =====================================
  3. 2018-06-25 17:43:06 0x7f6bf5126700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 34 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 57153 srv_active, 0 srv_shutdown, 49740 srv_idle
  10. srv_master_thread log flush and writes: 106874
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 234982
  15. OS WAIT ARRAY INFO: signal count 224002
  16. RW-shared spins 0, rounds 106964, OS waits 53707
  17. RW-excl spins 0, rounds 70137, OS waits 923
  18. RW-sx spins 79, rounds 1717, OS waits 31
  19. Spin rounds per wait: 106964.00 RW-shared, 70137.00 RW-excl, 21.73 RW-sx
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 221271224
  24. Purge done for trx's n:o < 221271224 undo n:o < 0 state: running but idle
  25. History list length 21
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 421585767442272, not started
  28. 0 lock struct(s), heap size 1136, 0 row lock(s)
  29. ---TRANSACTION 421585767443192, not started
  30. 0 lock struct(s), heap size 1136, 0 row lock(s)
  31. --------
  32. FILE I/O
  33. --------
  34. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  35. I/O thread 1 state: waiting for completed aio requests (log thread)
  36. I/O thread 2 state: waiting for completed aio requests (read thread)
  37. I/O thread 3 state: waiting for completed aio requests (read thread)
  38. I/O thread 4 state: waiting for completed aio requests (read thread)
  39. I/O thread 5 state: waiting for completed aio requests (read thread)
  40. I/O thread 6 state: waiting for completed aio requests (write thread)
  41. I/O thread 7 state: waiting for completed aio requests (write thread)
  42. I/O thread 8 state: waiting for completed aio requests (write thread)
  43. I/O thread 9 state: waiting for completed aio requests (write thread)
  44. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  45. ibuf aio reads:, log i/o's:, sync i/o's:
  46. Pending flushes (fsync) log: 0; buffer pool: 0
  47. 264804 OS file reads, 14432636 OS file writes, 10185604 OS fsyncs
  48. 0.62 reads/s, 16384 avg bytes/read, 132.41 writes/s, 90.88 fsyncs/s
  49. -------------------------------------
  50. INSERT BUFFER AND ADAPTIVE HASH INDEX
  51. -------------------------------------
  52. Ibuf: size 1, free list len 12, seg size 14, 296 merges
  53. merged operations:
  54. insert 292, delete mark 592, delete 2
  55. discarded operations:
  56. insert 0, delete mark 0, delete 0
  57. Hash table size 2365241, node heap has 120 buffer(s)
  58. Hash table size 2365241, node heap has 10 buffer(s)
  59. Hash table size 2365241, node heap has 2 buffer(s)
  60. Hash table size 2365241, node heap has 1052 buffer(s)
  61. Hash table size 2365241, node heap has 243 buffer(s)
  62. Hash table size 2365241, node heap has 2590 buffer(s)
  63. Hash table size 2365241, node heap has 456 buffer(s)
  64. Hash table size 2365241, node heap has 111 buffer(s)
  65. 127.76 hash searches/s, 99.85 non-hash searches/s
  66. ---
  67. LOG
  68. ---
  69. Log sequence number 37571640522
  70. Log flushed up to   37571640522
  71. Pages flushed up to 37571512305
  72. Last checkpoint at  37571512173
  73. 0 pending log flushes, 0 pending chkp writes
  74. 8844446 log i/o's done, 76.59 log i/o's/second
  75. ----------------------
  76. BUFFER POOL AND MEMORY
  77. ----------------------
  78. Total large memory allocated 8795455488
  79. Dictionary memory allocated 14679870
  80. Buffer pool size   524224
  81. Free buffers       266113
  82. Database pages     253527
  83. Old database pages 93643
  84. Modified db pages  360
  85. Pending reads      0
  86. Pending writes: LRU 0, flush list 0, single page 0
  87. Pages made young 157, not young 0
  88. 0.00 youngs/s, 0.00 non-youngs/s
  89. Pages read 206028, created 47499, written 5127098
  90. 0.56 reads/s, 0.24 creates/s, 51.15 writes/s
  91. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  92. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  93. LRU len: 253527, unzip_LRU len: 0
  94. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  95. ----------------------
  96. INDIVIDUAL BUFFER POOL INFO
  97. ----------------------
  98. ---BUFFER POOL 0
  99. Buffer pool size   65528
  100. Free buffers       32936
  101. Database pages     32021
  102. Old database pages 11840
  103. Modified db pages  23
  104. Pending reads      0
  105. Pending writes: LRU 0, flush list 0, single page 0
  106. Pages made young 12, not young 0
  107. 0.00 youngs/s, 0.00 non-youngs/s
  108. Pages read 25875, created 6146, written 667240
  109. 0.29 reads/s, 0.00 creates/s, 8.29 writes/s
  110. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  111. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  112. LRU len: 32021, unzip_LRU len: 0
  113. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  114. ---BUFFER POOL 1
  115. Buffer pool size   65528
  116. Free buffers       32876
  117. Database pages     32063
  118. Old database pages 11848
  119. Modified db pages  4
  120. Pending reads      0
  121. Pending writes: LRU 0, flush list 0, single page 0
  122. Pages made young 10, not young 0
  123. 0.00 youngs/s, 0.00 non-youngs/s
  124. Pages read 25892, created 6171, written 462408
  125. 0.00 reads/s, 0.21 creates/s, 2.21 writes/s
  126. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  127. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  128. LRU len: 32063, unzip_LRU len: 0
  129. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  130. ---BUFFER POOL 2
  131. Buffer pool size   65528
  132. Free buffers       33242
  133. Database pages     31694
  134. Old database pages 11719
  135. Modified db pages  18
  136. Pending reads      0
  137. Pending writes: LRU 0, flush list 0, single page 0
  138. Pages made young 22, not young 0
  139. 0.00 youngs/s, 0.00 non-youngs/s
  140. Pages read 25749, created 5945, written 557176
  141. 0.18 reads/s, 0.00 creates/s, 3.68 writes/s
  142. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  143. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  144. LRU len: 31694, unzip_LRU len: 0
  145. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  146. ---BUFFER POOL 3
  147. Buffer pool size   65528
  148. Free buffers       33661
  149. Database pages     31329
  150. Old database pages 11554
  151. Modified db pages  88
  152. Pending reads      0
  153. Pending writes: LRU 0, flush list 0, single page 0
  154. Pages made young 5, not young 0
  155. 0.00 youngs/s, 0.00 non-youngs/s
  156. Pages read 25471, created 5858, written 804078
  157. 0.00 reads/s, 0.00 creates/s, 8.62 writes/s
  158. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  159. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  160. LRU len: 31329, unzip_LRU len: 0
  161. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  162. ---BUFFER POOL 4
  163. Buffer pool size   65528
  164. Free buffers       32446
  165. Database pages     32498
  166. Old database pages 12010
  167. Modified db pages  61
  168. Pending reads      0
  169. Pending writes: LRU 0, flush list 0, single page 0
  170. Pages made young 31, not young 0
  171. 0.00 youngs/s, 0.00 non-youngs/s
  172. Pages read 26621, created 5877, written 717776
  173. 0.00 reads/s, 0.00 creates/s, 7.35 writes/s
  174. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  175. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  176. LRU len: 32498, unzip_LRU len: 0
  177. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  178. ---BUFFER POOL 5
  179. Buffer pool size   65528
  180. Free buffers       32818
  181. Database pages     32123
  182. Old database pages 11854
  183. Modified db pages  76
  184. Pending reads      0
  185. Pending writes: LRU 0, flush list 0, single page 0
  186. Pages made young 17, not young 0
  187. 0.00 youngs/s, 0.00 non-youngs/s
  188. Pages read 25995, created 6128, written 702868
  189. 0.00 reads/s, 0.03 creates/s, 8.65 writes/s
  190. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  191. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  192. LRU len: 32123, unzip_LRU len: 0
  193. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  194. ---BUFFER POOL 6
  195. Buffer pool size   65528
  196. Free buffers       33805
  197. Database pages     31168
  198. Old database pages 11524
  199. Modified db pages  62
  200. Pending reads      0
  201. Pending writes: LRU 0, flush list 0, single page 0
  202. Pages made young 33, not young 0
  203. 0.00 youngs/s, 0.00 non-youngs/s
  204. Pages read 25554, created 5614, written 714494
  205. 0.00 reads/s, 0.00 creates/s, 7.59 writes/s
  206. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  207. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  208. LRU len: 31168, unzip_LRU len: 0
  209. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  210. ---BUFFER POOL 7
  211. Buffer pool size   65528
  212. Free buffers       34329
  213. Database pages     30631
  214. Old database pages 11294
  215. Modified db pages  28
  216. Pending reads      0
  217. Pending writes: LRU 0, flush list 0, single page 0
  218. Pages made young 27, not young 0
  219. 0.00 youngs/s, 0.00 non-youngs/s
  220. Pages read 24871, created 5760, written 501058
  221. 0.09 reads/s, 0.00 creates/s, 4.76 writes/s
  222. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  223. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  224. LRU len: 30631, unzip_LRU len: 0
  225. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  226. --------------
  227. ROW OPERATIONS
  228. --------------
  229. 0 queries inside InnoDB, 0 queries in queue
  230. 0 read views open inside InnoDB
  231. Process ID=5834, Main thread ID=140101742470912, state: sleeping
  232. Number of rows inserted 8445246, updated 7790717, deleted 292, read 28589650
  233. 11.68 inserts/s, 66.91 updates/s, 0.00 deletes/s, 135.14 reads/s
  234. ----------------------------
  235. END OF INNODB MONITOR OUTPUT
  236. ============================
  237. |
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!