Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 10:20:04 140694508308160 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 19 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1802 srv_active, 0 srv_shutdown, 24 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 34029027\nOS WAIT ARRAY INFO: signal count 6053664\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 18397729\nPurge done for trx's n:o < 18397729 undo n:o < 0 state: running but idle\nHistory list length 2\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\n69523950 OS file reads, 67761651 OS file writes, 6287447 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 7270.24 writes/s, 234.17 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 75, seg size 77, 48405 merges\nmerged operations:\n insert 52885, 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.11 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          507798858644\nLog buffer assigned up to    507798858644\nLog buffer completed up to   507798858644\nLog written up to            507798858644\nLog flushed up to            507798858644\nAdded dirty pages up to      507798858644\nPages flushed up to          507297027543\nLast checkpoint at           507297027543\nLog minimum file id is       450\nLog maximum file id is       479\n10577282 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   4193932\nFree buffers       34260\nDatabase pages     4159672\nOld database pages 1535195\nModified db pages  835677\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 22091515, not young 149919562\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 69544307, created 414768, written 51975606\n0.00 reads/s, 0.00 creates/s, 7211.51 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: 4159672, unzip_LRU len: 0\nI/O sum[26056000]:cur[20000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262124\nFree buffers       2166\nDatabase pages     259958\nOld database pages 95956\nModified db pages  53139\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1339565, not young 9341124\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4336733, created 25056, written 3242201\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259958, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262117\nFree buffers       2216\nDatabase pages     259901\nOld database pages 95920\nModified db pages  52507\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1396250, not young 9331994\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4362038, created 26039, written 3255972\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259901, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262120\nFree buffers       2278\nDatabase pages     259842\nOld database pages 95898\nModified db pages  52490\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1344599, not young 9305510\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4357557, created 26493, written 3256372\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259842, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262118\nFree buffers       2251\nDatabase pages     259867\nOld database pages 95907\nModified db pages  51916\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1399498, not young 9337971\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4351437, created 25976, written 3247440\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259867, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262120\nFree buffers       2211\nDatabase pages     259909\nOld database pages 95922\nModified db pages  52143\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1358105, not young 9373518\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4336865, created 25796, written 3237081\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259909, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262121\nFree buffers       2209\nDatabase pages     259912\nOld database pages 95924\nModified db pages  52779\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1450778, not young 9830382\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4333421, created 26333, written 3251777\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259912, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262120\nFree buffers       2229\nDatabase pages     259891\nOld database pages 95916\nModified db pages  51912\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1386511, not young 9379263\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4365074, created 26886, written 3260188\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259891, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262126\nFree buffers       2170\nDatabase pages     259956\nOld database pages 95943\nModified db pages  52206\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1386189, not young 9311763\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4356042, created 26188, written 3252819\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259956, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  53303\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1373713, not young 9317092\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4358691, created 25689, written 3276328\n0.00 reads/s, 0.00 creates/s, 450.72 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: 260075, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262119\nFree buffers       2098\nDatabase pages     260021\nOld database pages 95964\nModified db pages  52834\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1365662, not young 9350983\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4337217, created 25219, written 3244906\n0.00 reads/s, 0.00 creates/s, 450.72 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: 260021, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262118\nFree buffers       2144\nDatabase pages     259974\nOld database pages 95946\nModified db pages  51773\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1346245, not young 9273767\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4326121, created 25784, written 3230570\n0.00 reads/s, 0.00 creates/s, 450.72 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: 259974, unzip_LRU len: 0\nI/O sum[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262122\nFree buffers       2048\nDatabase pages     260074\nOld database pages 95983\nModified db pages  51838\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1382408, not young 9340830\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4332731, created 25569, written 3240688\n0.00 reads/s, 0.00 creates/s, 450.72 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[1628500]:cur[1250], 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  52047\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1401219, not young 9393815\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4363027, created 26221, written 3255946\n0.00 reads/s, 0.00 creates/s, 450.72 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[1628500]:cur[1250], 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  52396\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1356105, not young 9287727\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4324982, created 25919, written 3241802\n0.00 reads/s, 0.00 creates/s, 450.72 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[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  51327\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1411787, not young 9392583\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4354227, created 25747, written 3245336\n0.00 reads/s, 0.00 creates/s, 450.72 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[1628500]:cur[1250], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262122\nFree buffers       2048\nDatabase pages     260074\nOld database pages 95983\nModified db pages  51067\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1392881, not young 9351240\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4348144, created 25853, written 3236180\n0.00 reads/s, 0.00 creates/s, 450.72 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[1628500]:cur[1250], 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=3675418, Main thread ID=140707101771456 , state=sleeping\nNumber of rows inserted 51470389, updated 99122644, deleted 3964958, read 485798540\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
