Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 09:10:28 140694473893568 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 3 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1803 srv_active, 0 srv_shutdown, 13 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 1896918\nOS WAIT ARRAY INFO: signal count 1719168\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 16716619\nPurge done for trx's n:o < 16716619 undo n:o < 0 state: running but idle\nHistory list length 1\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\n62915118 OS file reads, 57674809 OS file writes, 1690003 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 4355.02 writes/s, 118.24 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 83, seg size 85, 47291 merges\nmerged operations:\n insert 50721, 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, 0.00 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          504659388684\nLog buffer assigned up to    504659388684\nLog buffer completed up to   504659388684\nLog written up to            504659388684\nLog flushed up to            504659388684\nAdded dirty pages up to      504659388684\nPages flushed up to          504108107874\nLast checkpoint at           504108107874\nLog minimum file id is       450\nLog maximum file id is       476\n9987668 log i/o's done, 0.00 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       32891\nDatabase pages     4161037\nOld database pages 1535695\nModified db pages  921661\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 20143002, not young 133469204\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 62926805, created 386687, written 47251541\n0.00 reads/s, 0.00 creates/s, 4319.35 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: 4161037, unzip_LRU len: 0\nI/O sum[35257088]:cur[64000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262122\nFree buffers       2098\nDatabase pages     260024\nOld database pages 95977\nModified db pages  57933\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1228700, not young 8300672\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3933972, created 23374, written 2950799\n0.00 reads/s, 0.00 creates/s, 269.96 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: 260024, unzip_LRU len: 0\nI/O sum[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262126\nFree buffers       2048\nDatabase pages     260078\nOld database pages 95985\nModified db pages  58003\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1272537, not young 8303639\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3942685, created 24514, written 2956600\n0.00 reads/s, 0.00 creates/s, 269.96 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: 260078, unzip_LRU len: 0\nI/O sum[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262127\nFree buffers       2048\nDatabase pages     260079\nOld database pages 95985\nModified db pages  58180\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1222190, not young 8257546\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3933351, created 23781, written 2944432\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  57767\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1275339, not young 8336901\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3942283, created 24644, written 2954720\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262117\nFree buffers       2121\nDatabase pages     259996\nOld database pages 95957\nModified db pages  57645\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1248551, not young 8344453\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3932341, created 24468, written 2950067\n0.00 reads/s, 0.00 creates/s, 269.96 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: 259996, unzip_LRU len: 0\nI/O sum[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  56727\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1324976, not young 8818657\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3917899, created 23949, written 2951662\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  57690\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1261658, not young 8330626\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3941718, created 24606, written 2956532\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  57152\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1263948, not young 8304302\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3944562, created 23953, written 2964083\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  57484\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1245703, not young 8279055\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3935067, created 24151, written 2969392\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95983\nModified db pages  58030\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1249816, not young 8290512\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3920252, created 23592, written 2947614\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  57602\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1219820, not young 8267571\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3922410, created 24139, written 2947238\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  57644\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1265263, not young 8297599\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3924609, created 24267, written 2950580\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  57569\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1268801, not young 8361543\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3942814, created 24469, written 2953888\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262116\nFree buffers       2048\nDatabase pages     260068\nOld database pages 95981\nModified db pages  57641\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1242467, not young 8257509\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3914660, created 23853, written 2947946\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262122\nFree buffers       2048\nDatabase pages     260074\nOld database pages 95983\nModified db pages  57643\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1296493, not young 8389605\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3946469, created 24504, written 2966817\n0.00 reads/s, 0.00 creates/s, 269.96 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: 260074, unzip_LRU len: 0\nI/O sum[2203568]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  56951\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1256740, not young 8329014\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3931713, created 24423, written 2939171\n0.00 reads/s, 0.00 creates/s, 269.96 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[2203568]: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=3546364, Main thread ID=140694216869568 , state=sleeping\nNumber of rows inserted 46260604, updated 89135715, deleted 3568288, read 435675896\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
