Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 13:50:48 140678035248832 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 9648746\nOS WAIT ARRAY INFO: signal count 4109243\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 17979087\nPurge done for trx's n:o < 17979087 undo n:o < 0 state: running but idle\nHistory list length 193\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\n67794500 OS file reads, 69573005 OS file writes, 9066589 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 5343.92 writes/s, 158.51 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 93, seg size 95, 45385 merges\nmerged operations:\n insert 49477, 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          506923083709\nLog buffer assigned up to    506923083709\nLog buffer completed up to   506923083709\nLog written up to            506923083709\nLog flushed up to            506923083709\nAdded dirty pages up to      506923083709\nPages flushed up to          506403106430\nLast checkpoint at           506403106430\nLog minimum file id is       450\nLog maximum file id is       479\n10518437 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   4193928\nFree buffers       33607\nDatabase pages     4160321\nOld database pages 1535590\nModified db pages  877951\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 20890575, not young 147511159\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 67816359, created 404271, written 50910476\n0.00 reads/s, 0.00 creates/s, 5300.42 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: 4160321, unzip_LRU len: 0\nI/O sum[29822928]:cur[64000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262123\nFree buffers       2063\nDatabase pages     260060\nOld database pages 95979\nModified db pages  55638\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1279003, not young 9182281\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4239333, created 24843, written 3189691\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260060, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262119\nFree buffers       2153\nDatabase pages     259966\nOld database pages 95944\nModified db pages  54978\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1314027, not young 9172370\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4242276, created 25031, written 3182097\n0.00 reads/s, 0.00 creates/s, 331.28 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: 259966, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262122\nFree buffers       2093\nDatabase pages     260029\nOld database pages 95967\nModified db pages  55098\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1282275, not young 9146272\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4251988, created 25217, written 3188926\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260029, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  54688\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1322194, not young 9191394\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4237146, created 25504, written 3180331\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260070, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262117\nFree buffers       2184\nDatabase pages     259933\nOld database pages 95931\nModified db pages  55301\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1288229, not young 9232131\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4229574, created 25010, written 3165852\n0.00 reads/s, 0.00 creates/s, 331.28 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: 259933, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  55143\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1369368, not young 9668590\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4223090, created 24746, written 3185013\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260077, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262120\nFree buffers       2239\nDatabase pages     259881\nOld database pages 95912\nModified db pages  55008\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1314372, not young 9198797\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4254158, created 26014, written 3188855\n0.00 reads/s, 0.00 creates/s, 331.28 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: 259881, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262119\nFree buffers       2215\nDatabase pages     259904\nOld database pages 95921\nModified db pages  55483\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1307443, not young 9161740\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4246447, created 25797, written 3190530\n0.00 reads/s, 0.00 creates/s, 331.28 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: 259904, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  54867\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1280497, not young 9155575\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4233432, created 25535, written 3190893\n0.00 reads/s, 0.00 creates/s, 331.28 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[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  55538\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1297187, not young 9190026\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4225104, created 24907, written 3182655\n0.00 reads/s, 0.00 creates/s, 331.28 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[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262128\nFree buffers       2048\nDatabase pages     260080\nOld database pages 96008\nModified db pages  54067\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1268801, not young 9156921\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4229108, created 25363, written 3178340\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260080, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262118\nFree buffers       2111\nDatabase pages     260007\nOld database pages 95998\nModified db pages  55454\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1303158, not young 9194041\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4226730, created 24627, written 3176604\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260007, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 96013\nModified db pages  53658\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1313678, not young 9243062\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4249513, created 25770, written 3183606\n0.00 reads/s, 0.00 creates/s, 331.28 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[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 96001\nModified db pages  54592\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1289298, not young 9140982\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4212922, created 24769, written 3167085\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260072, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262119\nFree buffers       2128\nDatabase pages     259991\nOld database pages 95977\nModified db pages  54398\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1344352, not young 9285195\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4266781, created 25779, written 3190377\n0.00 reads/s, 0.00 creates/s, 331.28 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: 259991, unzip_LRU len: 0\nI/O sum[1863933]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262119\nFree buffers       2085\nDatabase pages     260034\nOld database pages 96007\nModified db pages  54040\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1316693, not young 9191782\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4248757, created 25359, written 3169621\n0.00 reads/s, 0.00 creates/s, 331.28 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: 260034, unzip_LRU len: 0\nI/O sum[1863933]: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=4073126, Main thread ID=140678087718592 , state=sleeping\nNumber of rows inserted 50159294, updated 96752402, deleted 3878247, read 472527864\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
