Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 13:16:02 140718833161920 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 12 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1803 srv_active, 0 srv_shutdown, 19 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 9501282\nOS WAIT ARRAY INFO: signal count 4081397\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 18002913\nPurge done for trx's n:o < 18002913 undo n:o < 0 state: running but idle\nHistory list length 31\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\n67909842 OS file reads, 69470472 OS file writes, 8803431 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 5049.62 writes/s, 154.60 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 93, seg size 95, 46929 merges\nmerged operations:\n insert 51368, 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, 2.17 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          507090770314\nLog buffer assigned up to    507090770314\nLog buffer completed up to   507090770314\nLog written up to            507090770314\nLog flushed up to            507090770314\nAdded dirty pages up to      507090770314\nPages flushed up to          506570181536\nLast checkpoint at           506570181536\nLog minimum file id is       450\nLog maximum file id is       479\n10567065 log i/o's done, 0.15 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 899999\nBuffer pool size   4193936\nFree buffers       32768\nDatabase pages     4161168\nOld database pages 1535820\nModified db pages  868447\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 20993723, not young 147666959\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 67927425, created 405344, written 51029961\n0.00 reads/s, 0.00 creates/s, 5008.54 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: 4161168, unzip_LRU len: 0\nI/O sum[29360560]:cur[64000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  55485\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1284150, not young 9196911\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4238813, created 24965, written 3193540\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260069, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262122\nFree buffers       2048\nDatabase pages     260074\nOld database pages 95983\nModified db pages  54113\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1320733, not young 9162690\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4252692, created 25494, written 3187985\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260074, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  54896\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1278089, not young 9182906\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4255582, created 25998, written 3197149\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260073, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262115\nFree buffers       2048\nDatabase pages     260067\nOld database pages 95991\nModified db pages  55144\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1328619, not young 9203486\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4247603, created 25200, written 3190859\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260067, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262129\nFree buffers       2048\nDatabase pages     260081\nOld database pages 96021\nModified db pages  53790\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1297879, not young 9241164\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4239060, created 25297, written 3182957\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260081, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262116\nFree buffers       2048\nDatabase pages     260068\nOld database pages 95988\nModified db pages  54036\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1380050, not young 9673016\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4226089, created 25406, written 3193680\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260068, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  54585\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1300430, not young 9196698\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4252392, created 25502, written 3184135\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260069, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262129\nFree buffers       2048\nDatabase pages     260081\nOld database pages 96026\nModified db pages  55249\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1321223, not young 9180396\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4255874, created 25190, written 3193205\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260081, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  53838\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1292982, not young 9166562\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4242443, created 25129, written 3200834\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260070, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  54162\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1295260, not young 9216729\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4231414, created 24681, written 3182226\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260072, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262124\nFree buffers       2048\nDatabase pages     260076\nOld database pages 95984\nModified db pages  55010\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1273805, not young 9168258\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4230751, created 25150, written 3181526\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260076, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  53466\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1313136, not young 9190003\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4239201, created 25682, written 3194496\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260077, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  53579\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1325072, not young 9261446\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4263325, created 25831, written 3191072\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260070, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  54378\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1301133, not young 9172616\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4234940, created 25347, written 3186636\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260071, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262127\nFree buffers       2048\nDatabase pages     260079\nOld database pages 95985\nModified db pages  53354\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1350920, not young 9244624\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4263651, created 25415, written 3192901\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260079, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  53362\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1330242, not young 9209454\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4253595, created 25057, written 3176760\n0.00 reads/s, 0.00 creates/s, 313.03 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: 260071, unzip_LRU len: 0\nI/O sum[1835035]:cur[4000], 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 50254880, updated 96736808, deleted 3868159, read 473453957\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s\nNumber of system rows inserted 8, updated 331, deleted 8, read 5634\n0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s\n----------------------------\nEND OF INNODB MONITOR OUTPUT\n============================\n
