Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 09:45:12 140678411458240 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 12 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1804 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 9422803\nOS WAIT ARRAY INFO: signal count 4294826\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 18805107\nPurge done for trx's n:o < 18805107 undo n:o < 0 state: running but idle\nHistory list length 83\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: doing file i/o (write thread) ev set\nI/O thread 21 state: doing file i/o (write thread) ev set\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, 47, 61, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,\n ibuf aio reads:\nPending flushes (fsync) log: 0; buffer pool: 0\n71174282 OS file reads, 71288713 OS file writes, 7844950 OS fsyncs\n0 pending preads, 2 pending pwrites\n0.00 reads/s, 0 avg bytes/read, 5086.75 writes/s, 150.83 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 98, seg size 100, 46676 merges\nmerged operations:\n insert 50872, 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, 1.75 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          508527062996\nLog buffer assigned up to    508527062996\nLog buffer completed up to   508527062996\nLog written up to            508527062996\nLog flushed up to            508527062996\nAdded dirty pages up to      508527062996\nPages flushed up to          508006867832\nLast checkpoint at           508006867832\nLog minimum file id is       450\nLog maximum file id is       480\n10949201 log i/o's done, 0.23 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 899999\nBuffer pool size   4193931\nFree buffers       32928\nDatabase pages     4161003\nOld database pages 1535871\nModified db pages  878360\nPending reads      0\nPending writes: LRU 0, flush list 226, single page 0\nPages made young 22163449, not young 154632895\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 71193910, created 423418, written 53527612\n0.00 reads/s, 0.00 creates/s, 5045.16 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: 4161003, unzip_LRU len: 0\nI/O sum[30766688]:cur[16000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262126\nFree buffers       2048\nDatabase pages     260078\nOld database pages 95988\nModified db pages  54827\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1355680, not young 9615162\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4446407, created 26370, written 3348105\n0.00 reads/s, 0.00 creates/s, 331.02 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 96003\nModified db pages  55097\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1391314, not young 9607298\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4459824, created 26425, written 3342250\n0.00 reads/s, 0.00 creates/s, 331.02 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262116\nFree buffers       2048\nDatabase pages     260068\nOld database pages 96021\nModified db pages  54814\nPending reads      0\nPending writes: LRU 0, flush list 45, single page 0\nPages made young 1363702, not young 9595122\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4467235, created 26787, written 3364212\n0.00 reads/s, 0.00 creates/s, 327.52 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262119\nFree buffers       2058\nDatabase pages     260061\nOld database pages 96004\nModified db pages  55631\nPending reads      0\nPending writes: LRU 0, flush list 181, single page 0\nPages made young 1389701, not young 9600851\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4440655, created 26668, written 3334665\n0.00 reads/s, 0.00 creates/s, 316.93 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: 260061, unzip_LRU len: 0\nI/O sum[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95989\nModified db pages  55327\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1385656, not young 9682204\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4452488, created 27118, written 3348110\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262129\nFree buffers       2107\nDatabase pages     260022\nOld database pages 96004\nModified db pages  54793\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1463598, not young 10144151\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4441075, created 26905, written 3359123\n0.00 reads/s, 0.00 creates/s, 311.56 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: 260022, unzip_LRU len: 0\nI/O sum[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262119\nFree buffers       2117\nDatabase pages     260002\nOld database pages 95989\nModified db pages  54989\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1385494, not young 9655440\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4468315, created 27052, written 3352489\n0.00 reads/s, 0.00 creates/s, 311.56 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: 260002, unzip_LRU len: 0\nI/O sum[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262116\nFree buffers       2070\nDatabase pages     260046\nOld database pages 96007\nModified db pages  54735\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1386384, not young 9591116\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4455484, created 26564, written 3345364\n0.00 reads/s, 0.00 creates/s, 311.56 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: 260046, unzip_LRU len: 0\nI/O sum[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262115\nFree buffers       2048\nDatabase pages     260067\nOld database pages 95981\nModified db pages  55386\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1367828, not young 9592530\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4452661, created 26234, written 3360394\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  54516\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1370306, not young 9677049\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4442079, created 26126, written 3336575\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  54726\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1342557, not young 9664311\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4440647, created 25965, written 3337738\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262129\nFree buffers       2048\nDatabase pages     260081\nOld database pages 95986\nModified db pages  55338\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1382217, not young 9608085\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4428461, created 25972, written 3333322\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  55186\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1397835, not young 9692970\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4452669, created 26850, written 3342893\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  55415\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1362769, not young 9590259\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4425778, created 25816, written 3335662\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262128\nFree buffers       2048\nDatabase pages     260080\nOld database pages 95986\nModified db pages  53824\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1419184, not young 9691699\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4463384, created 26358, written 3348730\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  53756\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1399224, not young 9624648\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4456748, created 26208, written 3337980\n0.00 reads/s, 0.00 creates/s, 311.56 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[1922918]:cur[1000], 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=3611023, Main thread ID=140694418196160 , state=sleeping\nNumber of rows inserted 52735574, updated 101561249, deleted 4063254, read 496416176\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
