Advertisement
Pseudofailure

MySQL: SHOW ENGINE INNODB STATUS

Mar 14th, 2023
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.03 KB | Fixit | 0 0
  1.  
  2. =====================================
  3. 2023-03-14 22:39:21 0x7f4e8aa53700 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 45 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 2 srv_active, 0 srv_shutdown, 713 srv_idle
  10. srv_master_thread log flush and writes: 715
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 9
  15. OS WAIT ARRAY INFO: signal count 9
  16. RW-shared spins 0, rounds 4, OS waits 2
  17. RW-excl spins 0, rounds 0, OS waits 0
  18. RW-sx spins 0, rounds 0, OS waits 0
  19. Spin rounds per wait: 4.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 41149954
  24. Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
  25. History list length 0
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 421450461829856, not started
  28. 0 lock struct(s), heap size 1136, 0 row lock(s)
  29. ---TRANSACTION 421450461828944, 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. 571 OS file reads, 56 OS file writes, 7 OS fsyncs
  48. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  49. -------------------------------------
  50. INSERT BUFFER AND ADAPTIVE HASH INDEX
  51. -------------------------------------
  52. Ibuf: size 1, free list len 3, seg size 5, 0 merges
  53. merged operations:
  54. insert 0, delete mark 0, delete 0
  55. discarded operations:
  56. insert 0, delete mark 0, delete 0
  57. Hash table size 34673, node heap has 2 buffer(s)
  58. Hash table size 34673, node heap has 0 buffer(s)
  59. Hash table size 34673, node heap has 0 buffer(s)
  60. Hash table size 34673, node heap has 0 buffer(s)
  61. Hash table size 34673, node heap has 0 buffer(s)
  62. Hash table size 34673, node heap has 0 buffer(s)
  63. Hash table size 34673, node heap has 0 buffer(s)
  64. Hash table size 34673, node heap has 2 buffer(s)
  65. 0.00 hash searches/s, 0.00 non-hash searches/s
  66. ---
  67. LOG
  68. ---
  69. Log sequence number 54730492261
  70. Log flushed up to 54730492261
  71. Pages flushed up to 54730492261
  72. Last checkpoint at 54730492252
  73. 0 pending log flushes, 0 pending chkp writes
  74. 10 log i/o's done, 0.00 log i/o's/second
  75. ----------------------
  76. BUFFER POOL AND MEMORY
  77. ----------------------
  78. Total large memory allocated 137428992
  79. Dictionary memory allocated 94124
  80. Buffer pool size 8191
  81. Free buffers 7630
  82. Database pages 557
  83. Old database pages 225
  84. Modified db pages 0
  85. Pending reads 0
  86. Pending writes: LRU 0, flush list 0, single page 0
  87. Pages made young 0, not young 0
  88. 0.00 youngs/s, 0.00 non-youngs/s
  89. Pages read 522, created 35, written 39
  90. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  91. No buffer pool page gets since the last printout
  92. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  93. LRU len: 557, unzip_LRU len: 0
  94. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  95. --------------
  96. ROW OPERATIONS
  97. --------------
  98. 0 queries inside InnoDB, 0 queries in queue
  99. 0 read views open inside InnoDB
  100. Process ID=1, Main thread ID=139975114872576, state: sleeping
  101. Number of rows inserted 44, updated 0, deleted 0, read 52
  102. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  103. ----------------------------
  104. END OF INNODB MONITOR OUTPUT
  105. ============================
  106.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement