Advertisement
Guest User

Untitled

a guest
Nov 18th, 2024
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =====================================
  2. 2024-11-13 18:34:58 140014381950720 INNODB MONITOR OUTPUT
  3. =====================================
  4. Per second averages calculated from the last 15 seconds
  5. -----------------
  6. BACKGROUND THREAD
  7. -----------------
  8. srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 0 srv_idle
  9. srv_master_thread log flush and writes: 0
  10. ----------
  11. SEMAPHORES
  12. ----------
  13. OS WAIT ARRAY INFO: reservation count 5
  14. --Thread 140015195649792 has waited at fil0fil.cc line 8484 for 353 seconds the semaphore:
  15. Mutex at 0x657a058, Mutex FIL_SHARD created fil0fil.cc:2100, locked by 140015629396672
  16.  
  17. OS WAIT ARRAY INFO: signal count 4
  18. RW-shared spins 0, rounds 0, OS waits 0
  19. RW-excl spins 0, rounds 0, OS waits 0
  20. RW-sx spins 0, rounds 0, OS waits 0
  21. Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
  22. ------------
  23. TRANSACTIONS
  24. ------------
  25. Trx id counter 4863350785
  26. Purge done for trx's n:o < 0 undo n:o < 0 state: initializing
  27. History list length 2
  28. LIST OF TRANSACTIONS FOR EACH SESSION:
  29. --------
  30. FILE I/O
  31. --------
  32. I/O thread 0 state: waiting for i/o request ((null))
  33. I/O thread 1 state: waiting for i/o request (insert buffer thread)
  34. I/O thread 2 state: waiting for i/o request (read thread)
  35. I/O thread 3 state: waiting for i/o request (read thread)
  36. I/O thread 4 state: waiting for i/o request (read thread)
  37. I/O thread 5 state: waiting for i/o request (read thread)
  38. I/O thread 6 state: waiting for i/o request (write thread)
  39. I/O thread 7 state: waiting for i/o request (write thread)
  40. I/O thread 8 state: waiting for i/o request (write thread)
  41. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  42.  ibuf aio reads:
  43. Pending flushes (fsync) log: 0; buffer pool: 0
  44. 1093 OS file reads, 203 OS file writes, 19 OS fsyncs
  45. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  46. -------------------------------------
  47. INSERT BUFFER AND ADAPTIVE HASH INDEX
  48. -------------------------------------
  49. Ibuf: size 1, free list len 28321, seg size 28323, 0 merges
  50. merged operations:
  51.  insert 0, delete mark 0, delete 0
  52. discarded operations:
  53.  insert 0, delete mark 0, delete 0
  54. Hash table size 34679, node heap has 0 buffer(s)
  55. Hash table size 34679, node heap has 0 buffer(s)
  56. Hash table size 34679, node heap has 0 buffer(s)
  57. Hash table size 34679, node heap has 0 buffer(s)
  58. Hash table size 34679, node heap has 0 buffer(s)
  59. Hash table size 34679, node heap has 0 buffer(s)
  60. Hash table size 34679, node heap has 0 buffer(s)
  61. Hash table size 34679, node heap has 0 buffer(s)
  62. 0.00 hash searches/s, 0.00 non-hash searches/s
  63. ---
  64. LOG
  65. ---
  66. Log sequence number          10371045732374
  67. Log buffer assigned up to    10371045732374
  68. Log buffer completed up to   10371045732374
  69. Log written up to            10371045732374
  70. Log flushed up to            10371045732374
  71. Added dirty pages up to      10371045732374
  72. Pages flushed up to          10371045732374
  73. Last checkpoint at           10371045732364
  74. Log minimum file id is       0
  75. Log maximum file id is       0
  76. 1 log i/o's done, 0.00 log i/o's/second
  77. ----------------------
  78. BUFFER POOL AND MEMORY
  79. ----------------------
  80. Total large memory allocated 0
  81. Dictionary memory allocated 0
  82. Buffer pool size   8192
  83. Free buffers       7019
  84. Database pages     1173
  85. Old database pages 413
  86. Modified db pages  0
  87. Pending reads      0
  88. Pending writes: LRU 0, flush list 0, single page 0
  89. Pages made young 0, not young 0
  90. 0.00 youngs/s, 0.00 non-youngs/s
  91. Pages read 1032, created 141, written 142
  92. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  93. No buffer pool page gets since the last printout
  94. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  95. LRU len: 1173, unzip_LRU len: 0
  96. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  97. --------------
  98. ROW OPERATIONS
  99. --------------
  100. 0 queries inside InnoDB, 0 queries in queue
  101. 0 read views open inside InnoDB
  102. Process ID=0, Main thread ID=thread::id of a non-executing thread , state=
  103. Number of rows inserted 0, updated 0, deleted 0, read 0
  104. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  105. Number of system rows inserted 0, updated 0, deleted 0, read 0
  106. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  107. ----------------------------
  108. END OF INNODB MONITOR OUTPUT
  109. ============================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement