Guest User

INNODB STATUS

a guest
Jul 23rd, 2020
26
73 days
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. =====================================
  3. 2020-07-23 17:12:55 0x1638 INNODB MONITOR OUTPUT
  4. =====================================
  5. Per second averages calculated from the last 11 seconds
  6. -----------------
  7. BACKGROUND THREAD
  8. -----------------
  9. srv_master_thread loops: 184 srv_active, 0 srv_shutdown, 40580 srv_idle
  10. srv_master_thread log flush and writes: 0
  11. ----------
  12. SEMAPHORES
  13. ----------
  14. OS WAIT ARRAY INFO: reservation count 1229
  15. OS WAIT ARRAY INFO: signal count 1110
  16. RW-shared spins 4, rounds 5, OS waits 1
  17. RW-excl spins 3, rounds 20, OS waits 0
  18. RW-sx spins 0, rounds 0, OS waits 0
  19. Spin rounds per wait: 1.25 RW-shared, 6.67 RW-excl, 0.00 RW-sx
  20. ------------
  21. TRANSACTIONS
  22. ------------
  23. Trx id counter 2425818
  24. Purge done for trx's n:o < 2425818 undo n:o < 0 state: running but idle
  25. History list length 36
  26. LIST OF TRANSACTIONS FOR EACH SESSION:
  27. ---TRANSACTION 281491452324408, not started
  28. 0 lock struct(s), heap size 1136, 0 row lock(s)
  29. ---TRANSACTION 281491452323568, 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: wait Windows aio (insert buffer thread)
  35. I/O thread 1 state: wait Windows aio (log thread)
  36. I/O thread 2 state: wait Windows aio (read thread)
  37. I/O thread 3 state: wait Windows aio (read thread)
  38. I/O thread 4 state: wait Windows aio (read thread)
  39. I/O thread 5 state: wait Windows aio (read thread)
  40. I/O thread 6 state: wait Windows aio (write thread)
  41. I/O thread 7 state: wait Windows aio (write thread)
  42. I/O thread 8 state: wait Windows aio (write thread)
  43. I/O thread 9 state: wait Windows aio (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. 3725 OS file reads, 16033 OS file writes, 10668 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 0, seg size 2, 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 18787, node heap has 12 buffer(s)
  58. Hash table size 18787, node heap has 61 buffer(s)
  59. Hash table size 18787, node heap has 42 buffer(s)
  60. Hash table size 18787, node heap has 0 buffer(s)
  61. Hash table size 18787, node heap has 1 buffer(s)
  62. Hash table size 18787, node heap has 0 buffer(s)
  63. Hash table size 18787, node heap has 15 buffer(s)
  64. Hash table size 18787, node heap has 71 buffer(s)
  65. 0.00 hash searches/s, 0.00 non-hash searches/s
  66. ---
  67. LOG
  68. ---
  69. Log sequence number 4255906655
  70. Log buffer assigned up to 4255906655
  71. Log buffer completed up to 4255906655
  72. Log written up to 4255906655
  73. Log flushed up to 4255906655
  74. Added dirty pages up to 4255906655
  75. Pages flushed up to 4255906655
  76. Last checkpoint at 4255906655
  77. 10856 log i/o's done, 0.00 log i/o's/second
  78. ----------------------
  79. BUFFER POOL AND MEMORY
  80. ----------------------
  81. Total large memory allocated 77266944
  82. Dictionary memory allocated 415980
  83. Buffer pool size 4608
  84. Free buffers 1024
  85. Database pages 3382
  86. Old database pages 1228
  87. Modified db pages 0
  88. Pending reads 0
  89. Pending writes: LRU 0, flush list 0, single page 0
  90. Pages made young 1258, not young 44093
  91. 0.00 youngs/s, 0.00 non-youngs/s
  92. Pages read 3702, created 301, written 4895
  93. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  94. No buffer pool page gets since the last printout
  95. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  96. LRU len: 3382, unzip_LRU len: 0
  97. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  98. --------------
  99. ROW OPERATIONS
  100. --------------
  101. 0 queries inside InnoDB, 0 queries in queue
  102. 0 read views open inside InnoDB
  103. Process ID=1480, Main thread ID=0000000000001974 , state=sleeping
  104. Number of rows inserted 4798, updated 7049, deleted 265, read 5583759
  105. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  106. ----------------------------
  107. END OF INNODB MONITOR OUTPUT
  108. ============================
RAW Paste Data