Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 13:20:21 140736348665536 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 0 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 0 srv_active, 0 srv_shutdown, 0 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 5\nOS WAIT ARRAY INFO: signal count 2\nRW-shared spins 0, rounds 0, OS waits 0\nRW-excl spins 0, rounds 0, OS waits 0\nRW-sx spins 0, rounds 0, OS waits 0\nSpin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx\n------------\nTRANSACTIONS\n------------\nTrx id counter 1726988\nPurge done for trx's n:o < 1726985 undo n:o < 0 state: running but idle\nHistory list length 4\nLIST OF TRANSACTIONS FOR EACH SESSION:\n---TRANSACTION 422212275707128, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n---TRANSACTION 422212275706312, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n---TRANSACTION 422212275705496, not started\n0 lock struct(s), heap size 1128, 0 row lock(s)\n--------\nFILE I/O\n--------\nI/O thread 0 state: waiting for i/o request (insert buffer thread)\nI/O thread 1 state: waiting for i/o request (read thread)\nI/O thread 2 state: waiting for i/o request (read thread)\nI/O thread 3 state: waiting for i/o request (read thread)\nI/O thread 4 state: waiting for i/o request (read thread)\nI/O thread 5 state: waiting for i/o request (read thread)\nI/O thread 6 state: waiting for i/o request (read thread)\nI/O thread 7 state: waiting for i/o request (read thread)\nI/O thread 8 state: waiting for i/o request (read thread)\nI/O thread 9 state: waiting for i/o request (read thread)\nI/O thread 10 state: waiting for i/o request (read thread)\nI/O thread 11 state: waiting for i/o request (read thread)\nI/O thread 12 state: waiting for i/o request (read thread)\nI/O thread 13 state: waiting for i/o request (read thread)\nI/O thread 14 state: waiting for i/o request (read thread)\nI/O thread 15 state: waiting for i/o request (read thread)\nI/O thread 16 state: waiting for i/o request (read thread)\nI/O thread 17 state: waiting for i/o request (write thread)\nI/O thread 18 state: waiting for i/o request (write thread)\nI/O thread 19 state: waiting for i/o request (write thread)\nI/O thread 20 state: waiting for i/o request (write thread)\nI/O thread 21 state: waiting for i/o request (write thread)\nI/O thread 22 state: waiting for i/o request (write thread)\nI/O thread 23 state: waiting for i/o request (write thread)\nI/O thread 24 state: waiting for i/o request (write thread)\nI/O thread 25 state: waiting for i/o request (write thread)\nI/O thread 26 state: waiting for i/o request (write thread)\nI/O thread 27 state: waiting for i/o request (write thread)\nI/O thread 28 state: waiting for i/o request (write thread)\nI/O thread 29 state: waiting for i/o request (write thread)\nI/O thread 30 state: waiting for i/o request (write thread)\nI/O thread 31 state: waiting for i/o request (write thread)\nI/O thread 32 state: waiting for i/o request (write thread)\nPending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,\n ibuf aio reads:\nPending flushes (fsync) log: 0; buffer pool: 0\n784 OS file reads, 61 OS file writes, 57 OS fsyncs\n278.78 reads/s, 112572 avg bytes/read, 21.69 writes/s, 20.27 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 0, seg size 2, 0 merges\nmerged operations:\n insert 0, delete mark 0, delete 0\ndiscarded operations:\n insert 0, delete mark 0, delete 0\nHash table size 17700857, node heap has 0 buffer(s)\nHash table size 17700857, node heap has 0 buffer(s)\nHash table size 17700857, node heap has 0 buffer(s)\nHash table size 17700857, node heap has 0 buffer(s)\nHash table size 17700857, node heap has 0 buffer(s)\nHash table size 17700857, node heap has 0 buffer(s)\nHash table size 17700857, node heap has 0 buffer(s)\nHash table size 17700857, node heap has 0 buffer(s)\n0.00 hash searches/s, 4011000.00 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          475821161301\nLog buffer assigned up to    475821161301\nLog buffer completed up to   475821161301\nLog written up to            475821161301\nLog flushed up to            475821159760\nAdded dirty pages up to      475821161301\nPages flushed up to          475821114300\nLast checkpoint at           475821114300\nLog minimum file id is       450\nLog maximum file id is       450\n30 log i/o's done, 30.00 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 753993\nBuffer pool size   4193928\nFree buffers       4193048\nDatabase pages     880\nOld database pages 0\nModified db pages  193\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 734, created 147, written 0\n815.11 reads/s, 163.24 creates/s, 0.00 writes/s\nBuffer pool hit rate 953 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 880, unzip_LRU len: 0\nI/O sum[0]:cur[4304], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262123\nFree buffers       261941\nDatabase pages     182\nOld database pages 0\nModified db pages  21\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 178, created 4, written 0\n197.67 reads/s, 4.44 creates/s, 0.00 writes/s\nBuffer pool hit rate 949 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 182, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262119\nFree buffers       261929\nDatabase pages     190\nOld database pages 0\nModified db pages  77\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 126, created 64, written 0\n139.92 reads/s, 71.07 creates/s, 0.00 writes/s\nBuffer pool hit rate 980 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 190, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262122\nFree buffers       262059\nDatabase pages     63\nOld database pages 0\nModified db pages  63\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 0, created 63, written 0\n0.00 reads/s, 69.96 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 63, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262118\nFree buffers       262118\nDatabase pages     0\nOld database pages 0\nModified db pages  0\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 0, created 0, written 0\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nNo buffer pool page gets since the last printout\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 0, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262117\nFree buffers       262117\nDatabase pages     0\nOld database pages 0\nModified db pages  0\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 0, created 0, written 0\n0.00 reads/s, 0.00 creates/s, 0.00 writes/s\nNo buffer pool page gets since the last printout\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 0, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262125\nFree buffers       262122\nDatabase pages     3\nOld database pages 0\nModified db pages  3\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 0, created 4, written 0\n0.00 reads/s, 4.44 creates/s, 0.00 writes/s\nBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 3, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262120\nFree buffers       262119\nDatabase pages     1\nOld database pages 0\nModified db pages  1\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 0, created 1, written 0\n0.00 reads/s, 1.11 creates/s, 0.00 writes/s\nNo buffer pool page gets since the last printout\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 1, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262119\nFree buffers       262118\nDatabase pages     1\nOld database pages 0\nModified db pages  1\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 0, created 1, written 0\n0.00 reads/s, 1.11 creates/s, 0.00 writes/s\nNo buffer pool page gets since the last printout\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 1, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262119\nFree buffers       262099\nDatabase pages     20\nOld database pages 0\nModified db pages  2\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 19, created 1, written 0\n21.10 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 891 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 20, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262125\nFree buffers       262106\nDatabase pages     19\nOld database pages 0\nModified db pages  6\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 17, created 2, written 0\n18.88 reads/s, 2.22 creates/s, 0.00 writes/s\nBuffer pool hit rate 978 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 19, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262128\nFree buffers       262110\nDatabase pages     18\nOld database pages 0\nModified db pages  1\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 17, created 1, written 0\n18.88 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 0 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 18, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262118\nFree buffers       262071\nDatabase pages     47\nOld database pages 0\nModified db pages  2\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 46, created 1, written 0\n51.08 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 963 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 47, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262117\nFree buffers       262073\nDatabase pages     44\nOld database pages 0\nModified db pages  3\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 43, created 1, written 0\n47.75 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 899 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 44, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262120\nFree buffers       262054\nDatabase pages     66\nOld database pages 0\nModified db pages  4\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 64, created 2, written 0\n71.07 reads/s, 2.22 creates/s, 0.00 writes/s\nBuffer pool hit rate 613 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 66, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262119\nFree buffers       262043\nDatabase pages     76\nOld database pages 0\nModified db pages  4\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 75, created 1, written 0\n83.29 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 852 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 76, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262119\nFree buffers       261969\nDatabase pages     150\nOld database pages 0\nModified db pages  5\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 0, not young 0\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 149, created 1, written 0\n165.47 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 913 / 1000, young-making rate 0 / 1000 not 0 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 150, unzip_LRU len: 0\nI/O sum[0]:cur[269], unzip sum[0]:cur[0]\n--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n0 read views open inside InnoDB\nProcess ID=4073126, Main thread ID=140678087718592 , state=sleeping\nNumber of rows inserted 43, updated 0, deleted 0, read 43\n43000.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 43000.00 reads/s\nNumber of system rows inserted 8, updated 331, deleted 8, read 4978\n8000.00 inserts/s, 331000.00 updates/s, 8000.00 deletes/s, 4978000.00 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n
