Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 12:45:35 140736617313984 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 16\nOS WAIT ARRAY INFO: signal count 4\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\n781 OS file reads, 59 OS file writes, 57 OS fsyncs\n278.80 reads/s, 112942 avg bytes/read, 21.06 writes/s, 20.35 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, 4027000.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\n28 log i/o's done, 28.00 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 753993\nBuffer pool size   4193936\nFree buffers       4193059\nDatabase pages     877\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 731, created 147, written 0\n809.47 reads/s, 162.78 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: 877, unzip_LRU len: 0\nI/O sum[0]:cur[4224], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262117\nFree buffers       261935\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.11 reads/s, 4.43 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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262122\nFree buffers       261933\nDatabase pages     189\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 125, created 64, written 0\n138.42 reads/s, 70.87 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: 189, unzip_LRU len: 0\nI/O sum[0]:cur[264], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262121\nFree buffers       262058\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.76 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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262115\nFree buffers       262115\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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262129\nFree buffers       262129\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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262116\nFree buffers       262113\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.43 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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262117\nFree buffers       262116\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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262129\nFree buffers       262128\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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262118\nFree buffers       262098\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.04 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 887 / 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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262120\nFree buffers       262103\nDatabase pages     17\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 15, created 2, written 0\n16.61 reads/s, 2.21 creates/s, 0.00 writes/s\nBuffer pool hit rate 981 / 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: 17, unzip_LRU len: 0\nI/O sum[0]:cur[264], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262124\nFree buffers       262106\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.82 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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262125\nFree buffers       262082\nDatabase pages     43\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 42, created 1, written 0\n46.51 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 966 / 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: 43, unzip_LRU len: 0\nI/O sum[0]:cur[264], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262118\nFree buffers       262074\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.62 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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262119\nFree buffers       262053\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\n70.87 reads/s, 2.21 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[264], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262127\nFree buffers       262050\nDatabase pages     77\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 76, created 1, written 0\n84.16 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 858 / 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: 77, unzip_LRU len: 0\nI/O sum[0]:cur[264], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262119\nFree buffers       261966\nDatabase pages     153\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 152, created 1, written 0\n168.32 reads/s, 1.11 creates/s, 0.00 writes/s\nBuffer pool hit rate 912 / 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: 153, unzip_LRU len: 0\nI/O sum[0]:cur[264], 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=4007106, Main thread ID=140707383973568 , 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 4984\n8000.00 inserts/s, 331000.00 updates/s, 8000.00 deletes/s, 4984000.00 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n
