Advertisement
Guest User

InnoDB Status

a guest
Mar 9th, 2023
319
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.41 KB | None | 0 0
  1. MariaDB [(none)]> SHOW ENGINE INNODB STATUS\G
  2. *************************** 1. row ***************************
  3. Type: InnoDB
  4. Name:
  5. Status:
  6. =====================================
  7. 2023-03-09 11:48:14 0x7f261e8cd700 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 35 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 36732 srv_active, 0 srv_shutdown, 51018 srv_idle
  14. srv_master_thread log flush and writes: 87737
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 1163771
  19. OS WAIT ARRAY INFO: signal count 632201
  20. RW-shared spins 114313, rounds 2866820, OS waits 93876
  21. RW-excl spins 101210, rounds 491835, OS waits 8694
  22. RW-sx spins 3108, rounds 70807, OS waits 2289
  23. Spin rounds per wait: 25.08 RW-shared, 4.86 RW-excl, 22.78 RW-sx
  24. ------------
  25. TRANSACTIONS
  26. ------------
  27. Trx id counter 539735827
  28. Purge done for trx's n:o < 539586225 undo n:o < 0 state: running
  29. History list length 17
  30. LIST OF TRANSACTIONS FOR EACH SESSION:
  31. ---TRANSACTION 421300747204952, not started
  32. 0 lock struct(s), heap size 1128, 0 row lock(s)
  33. ---TRANSACTION 539570313, ACTIVE 17 sec doing SYNC index
  34. 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 693055
  35. ---TRANSACTION 539718750, ACTIVE 6 sec
  36. 54 lock struct(s), heap size 8312, 1439 row lock(s), undo log entries 5
  37. MySQL thread id 239991, OS thread handle 139802291545856, query id 51269077 XXXXXXXXXXXXXX XXXXXXXXXXXXXX XXXXXXXXXXXXXX
  38. Trx read view will not see trx with id >= 539584824, sees < 539570313
  39. ---TRANSACTION 421300747129784, not started
  40. 0 lock struct(s), heap size 1128, 0 row lock(s)
  41. ---TRANSACTION 421300747171544, not started
  42. 0 lock struct(s), heap size 1128, 0 row lock(s)
  43. ---TRANSACTION 421300747230008, not started
  44. 0 lock struct(s), heap size 1128, 0 row lock(s)
  45. ---TRANSACTION 421300747200776, not started
  46. 0 lock struct(s), heap size 1128, 0 row lock(s)
  47. ---TRANSACTION 421300747263416, not started
  48. 0 lock struct(s), heap size 1128, 0 row lock(s)
  49. ---TRANSACTION 421300747238360, not started
  50. 0 lock struct(s), heap size 1128, 0 row lock(s)
  51. ---TRANSACTION 421300747234184, not started
  52. 0 lock struct(s), heap size 1128, 0 row lock(s)
  53. ---TRANSACTION 421300747192424, not started
  54. 0 lock struct(s), heap size 1128, 0 row lock(s)
  55. ---TRANSACTION 421300747184072, not started
  56. 0 lock struct(s), heap size 1128, 0 row lock(s)
  57. ---TRANSACTION 421300747225832, not started
  58. 0 lock struct(s), heap size 1128, 0 row lock(s)
  59. ---TRANSACTION 421300747188248, not started
  60. 0 lock struct(s), heap size 1128, 0 row lock(s)
  61. ---TRANSACTION 421300747138136, not started
  62. 0 lock struct(s), heap size 1128, 0 row lock(s)
  63. ---TRANSACTION 421300747133960, not started
  64. 0 lock struct(s), heap size 1128, 0 row lock(s)
  65. ---TRANSACTION 421300747121432, not started
  66. 0 lock struct(s), heap size 1128, 0 row lock(s)
  67. ---TRANSACTION 421300747179896, not started
  68. 0 lock struct(s), heap size 1128, 0 row lock(s)
  69. ---TRANSACTION 421300747175720, not started
  70. 0 lock struct(s), heap size 1128, 0 row lock(s)
  71. ---TRANSACTION 421300747167368, not started
  72. 0 lock struct(s), heap size 1128, 0 row lock(s)
  73. ---TRANSACTION 421300747163192, not started
  74. 0 lock struct(s), heap size 1128, 0 row lock(s)
  75. ---TRANSACTION 421300747159016, not started
  76. 0 lock struct(s), heap size 1128, 0 row lock(s)
  77. ---TRANSACTION 421300747154840, not started
  78. 0 lock struct(s), heap size 1128, 0 row lock(s)
  79. ---TRANSACTION 421300747150664, not started
  80. 0 lock struct(s), heap size 1128, 0 row lock(s)
  81. ---TRANSACTION 421300747146488, not started
  82. 0 lock struct(s), heap size 1128, 0 row lock(s)
  83. ---TRANSACTION 421300747142312, not started
  84. 0 lock struct(s), heap size 1128, 0 row lock(s)
  85. ---TRANSACTION 421300747125608, not started
  86. 0 lock struct(s), heap size 1128, 0 row lock(s)
  87. --------
  88. FILE I/O
  89. --------
  90. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  91. I/O thread 1 state: waiting for completed aio requests (log thread)
  92. I/O thread 2 state: waiting for completed aio requests (read thread)
  93. I/O thread 3 state: waiting for completed aio requests (read thread)
  94. I/O thread 4 state: waiting for completed aio requests (read thread)
  95. I/O thread 5 state: waiting for completed aio requests (read thread)
  96. I/O thread 6 state: waiting for completed aio requests (write thread)
  97. I/O thread 7 state: waiting for completed aio requests (write thread)
  98. I/O thread 8 state: waiting for completed aio requests (write thread)
  99. I/O thread 9 state: waiting for completed aio requests (write thread)
  100. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  101. ibuf aio reads:, log i/o's:, sync i/o's:
  102. Pending flushes (fsync) log: 0; buffer pool: 0
  103. 1404524 OS file reads, 54985554 OS file writes, 2072566 OS fsyncs
  104. 78.43 reads/s, 16384 avg bytes/read, 5685.01 writes/s, 131.31 fsyncs/s
  105. -------------------------------------
  106. INSERT BUFFER AND ADAPTIVE HASH INDEX
  107. -------------------------------------
  108. Ibuf: size 1, free list len 10893, seg size 10895, 20131 merges
  109. merged operations:
  110. insert 19326, delete mark 41419, delete 13357
  111. discarded operations:
  112. insert 0, delete mark 0, delete 0
  113. 0.00 hash searches/s, 146024.09 non-hash searches/s
  114. ---
  115. LOG
  116. ---
  117. Log sequence number 2524694141348
  118. Log flushed up to 2524683896429
  119. Pages flushed up to 2524625093493
  120. Last checkpoint at 2524621774065
  121. 0 pending log flushes, 0 pending chkp writes
  122. 206424 log i/o's done, 10.06 log i/o's/second
  123. ----------------------
  124. BUFFER POOL AND MEMORY
  125. ----------------------
  126. Total large memory allocated 21959278592
  127. Dictionary memory allocated 820512
  128. Buffer pool size 1310720
  129. Free buffers 8190
  130. Database pages 1302530
  131. Old database pages 480656
  132. Modified db pages 57594
  133. Percent of dirty pages(LRU & free pages): 4.394
  134. Max dirty pages percent: 75.000
  135. Pending reads 0
  136. Pending writes: LRU 0, flush list 0, single page 0
  137. Pages made young 1098072, not young 4800980
  138. 432.96 youngs/s, 220.22 non-youngs/s
  139. Pages read 1404194, created 97362, written 53650702
  140. 78.43 reads/s, 3.83 creates/s, 5575.07 writes/s
  141. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  142. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  143. LRU len: 1302530, unzip_LRU len: 0
  144. I/O sum[2288672]:cur[6456], unzip sum[0]:cur[0]
  145. ----------------------
  146. INDIVIDUAL BUFFER POOL INFO
  147. ----------------------
  148. ---BUFFER POOL 0
  149. Buffer pool size 163840
  150. Free buffers 1024
  151. Database pages 162816
  152. Old database pages 60082
  153. Modified db pages 7343
  154. Percent of dirty pages(LRU & free pages): 4.482
  155. Max dirty pages percent: 75.000
  156. Pending reads 0
  157. Pending writes: LRU 0, flush list 0, single page 0
  158. Pages made young 137729, not young 624469
  159. 59.23 youngs/s, 48.66 non-youngs/s
  160. Pages read 176145, created 11776, written 6800193
  161. 9.66 reads/s, 0.03 creates/s, 694.75 writes/s
  162. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  163. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  164. LRU len: 162816, unzip_LRU len: 0
  165. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  166. ---BUFFER POOL 1
  167. Buffer pool size 163840
  168. Free buffers 1024
  169. Database pages 162816
  170. Old database pages 60082
  171. Modified db pages 7428
  172. Percent of dirty pages(LRU & free pages): 4.534
  173. Max dirty pages percent: 75.000
  174. Pending reads 0
  175. Pending writes: LRU 0, flush list 0, single page 0
  176. Pages made young 136259, not young 610636
  177. 55.97 youngs/s, 33.11 non-youngs/s
  178. Pages read 174252, created 12445, written 6728748
  179. 9.97 reads/s, 0.86 creates/s, 700.15 writes/s
  180. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  181. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  182. LRU len: 162816, unzip_LRU len: 0
  183. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  184. ---BUFFER POOL 2
  185. Buffer pool size 163840
  186. Free buffers 1024
  187. Database pages 162816
  188. Old database pages 60082
  189. Modified db pages 6918
  190. Percent of dirty pages(LRU & free pages): 4.222
  191. Max dirty pages percent: 75.000
  192. Pending reads 0
  193. Pending writes: LRU 0, flush list 0, single page 0
  194. Pages made young 130702, not young 464917
  195. 55.34 youngs/s, 24.74 non-youngs/s
  196. Pages read 174655, created 11913, written 6583056
  197. 10.46 reads/s, 1.89 creates/s, 678.07 writes/s
  198. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  199. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  200. LRU len: 162816, unzip_LRU len: 0
  201. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  202. ---BUFFER POOL 3
  203. Buffer pool size 163840
  204. Free buffers 1022
  205. Database pages 162818
  206. Old database pages 60082
  207. Modified db pages 7487
  208. Percent of dirty pages(LRU & free pages): 4.570
  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 140469, not young 678974
  213. 50.06 youngs/s, 19.80 non-youngs/s
  214. Pages read 175955, created 12262, written 6933633
  215. 9.80 reads/s, 0.86 creates/s, 712.35 writes/s
  216. Buffer pool hit rate 999 / 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: 162818, unzip_LRU len: 0
  219. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  220. ---BUFFER POOL 4
  221. Buffer pool size 163840
  222. Free buffers 1024
  223. Database pages 162816
  224. Old database pages 60082
  225. Modified db pages 7128
  226. Percent of dirty pages(LRU & free pages): 4.351
  227. Max dirty pages percent: 75.000
  228. Pending reads 0
  229. Pending writes: LRU 0, flush list 0, single page 0
  230. Pages made young 135781, not young 559626
  231. 50.66 youngs/s, 17.60 non-youngs/s
  232. Pages read 173765, created 12185, written 6674812
  233. 8.74 reads/s, 0.00 creates/s, 691.24 writes/s
  234. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  235. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  236. LRU len: 162816, unzip_LRU len: 0
  237. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  238. ---BUFFER POOL 5
  239. Buffer pool size 163840
  240. Free buffers 1024
  241. Database pages 162816
  242. Old database pages 60082
  243. Modified db pages 7175
  244. Percent of dirty pages(LRU & free pages): 4.379
  245. Max dirty pages percent: 75.000
  246. Pending reads 0
  247. Pending writes: LRU 0, flush list 0, single page 0
  248. Pages made young 135831, not young 604644
  249. 58.94 youngs/s, 32.54 non-youngs/s
  250. Pages read 175044, created 11853, written 6656589
  251. 10.54 reads/s, 0.00 creates/s, 698.27 writes/s
  252. Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000
  253. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  254. LRU len: 162816, unzip_LRU len: 0
  255. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  256. ---BUFFER POOL 6
  257. Buffer pool size 163840
  258. Free buffers 1024
  259. Database pages 162816
  260. Old database pages 60082
  261. Modified db pages 7081
  262. Percent of dirty pages(LRU & free pages): 4.322
  263. Max dirty pages percent: 75.000
  264. Pending reads 0
  265. Pending writes: LRU 0, flush list 0, single page 0
  266. Pages made young 141397, not young 598200
  267. 49.77 youngs/s, 18.60 non-youngs/s
  268. Pages read 177610, created 12626, written 6675950
  269. 8.60 reads/s, 0.11 creates/s, 700.35 writes/s
  270. Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000
  271. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  272. LRU len: 162816, unzip_LRU len: 0
  273. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  274. ---BUFFER POOL 7
  275. Buffer pool size 163840
  276. Free buffers 1024
  277. Database pages 162816
  278. Old database pages 60082
  279. Modified db pages 7034
  280. Percent of dirty pages(LRU & free pages): 4.293
  281. Max dirty pages percent: 75.000
  282. Pending reads 0
  283. Pending writes: LRU 0, flush list 0, single page 0
  284. Pages made young 139904, not young 659514
  285. 53.00 youngs/s, 25.17 non-youngs/s
  286. Pages read 176768, created 12302, written 6597721
  287. 10.66 reads/s, 0.09 creates/s, 699.89 writes/s
  288. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  289. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  290. LRU len: 162816, unzip_LRU len: 0
  291. I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
  292. --------------
  293. ROW OPERATIONS
  294. --------------
  295. 0 queries inside InnoDB, 0 queries in queue
  296. 1 read views open inside InnoDB
  297. Process ID=15676, Main thread ID=139801724438272, state: sleeping
  298. Number of rows inserted 71254, updated 11185439, deleted 26361, read 12201341947
  299. 2.83 inserts/s, 3.14 updates/s, 0.00 deletes/s, 116691.92 reads/s
  300. Number of system rows inserted 0, updated 0, deleted 0, read 0
  301. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  302. ----------------------------
  303. END OF INNODB MONITOR OUTPUT
  304. ============================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement