Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 14:25:32 140667923809984 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 9819144\nOS WAIT ARRAY INFO: signal count 4192773\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 18117183\nPurge done for trx's n:o < 18117183 undo n:o < 0 state: running but idle\nHistory list length 167\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\n68449368 OS file reads, 69669771 OS file writes, 8605458 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 5364.21 writes/s, 158.72 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 86, seg size 88, 45796 merges\nmerged operations:\n insert 49827, 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          507286131345\nLog buffer assigned up to    507286131345\nLog buffer completed up to   507286131345\nLog written up to            507286131345\nLog flushed up to            507286131345\nAdded dirty pages up to      507286131345\nPages flushed up to          506754553303\nLast checkpoint at           506754553303\nLog minimum file id is       450\nLog maximum file id is       479\n10618432 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       33577\nDatabase pages     4160351\nOld database pages 1535497\nModified db pages  891821\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 21156603, not young 148757552\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 68467898, created 407715, written 51394993\n0.00 reads/s, 0.00 creates/s, 5320.70 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: 4160351, unzip_LRU len: 0\nI/O sum[29903808]:cur[64000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  56018\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1295927, not young 9262779\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4274132, created 25378, written 3216593\n0.00 reads/s, 0.00 creates/s, 332.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: 260071, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  55180\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1335468, not young 9245174\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4289291, created 25224, written 3209922\n0.00 reads/s, 0.00 creates/s, 332.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: 260069, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  56527\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1292285, not young 9246673\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4289008, created 25686, written 3219833\n0.00 reads/s, 0.00 creates/s, 332.54 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[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  56658\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1330185, not young 9255607\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4276694, created 26224, written 3210260\n0.00 reads/s, 0.00 creates/s, 332.54 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[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262126\nFree buffers       2048\nDatabase pages     260078\nOld database pages 95985\nModified db pages  56546\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1311529, not young 9313791\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4282644, created 25685, written 3203938\n0.00 reads/s, 0.00 creates/s, 332.54 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[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  56103\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1380737, not young 9757000\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4262469, created 25098, written 3213800\n0.00 reads/s, 0.00 creates/s, 332.54 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[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  56317\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1319317, not young 9278043\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4289454, created 25751, written 3212751\n0.00 reads/s, 0.00 creates/s, 332.54 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[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262127\nFree buffers       2048\nDatabase pages     260079\nOld database pages 95985\nModified db pages  56443\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1326274, not young 9228598\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4285764, created 25913, written 3217949\n0.00 reads/s, 0.00 creates/s, 332.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: 260079, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262116\nFree buffers       2123\nDatabase pages     259993\nOld database pages 95966\nModified db pages  55597\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1314123, not young 9227661\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4278406, created 25372, written 3233930\n0.00 reads/s, 0.00 creates/s, 332.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: 259993, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262119\nFree buffers       2148\nDatabase pages     259971\nOld database pages 95956\nModified db pages  55252\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1315870, not young 9293456\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4269419, created 25064, written 3208975\n0.00 reads/s, 0.00 creates/s, 332.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: 259971, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262126\nFree buffers       2206\nDatabase pages     259920\nOld database pages 95944\nModified db pages  55003\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1279922, not young 9233296\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4262687, created 24634, written 3197692\n0.00 reads/s, 0.00 creates/s, 332.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: 259920, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262121\nFree buffers       2055\nDatabase pages     260066\nOld database pages 95991\nModified db pages  55551\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1327424, not young 9274202\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4277822, created 25611, written 3214273\n0.00 reads/s, 0.00 creates/s, 332.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: 260066, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262119\nFree buffers       2183\nDatabase pages     259936\nOld database pages 95935\nModified db pages  55554\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1339434, not young 9336975\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4292375, created 25818, written 3219444\n0.00 reads/s, 0.00 creates/s, 332.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: 259936, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262121\nFree buffers       2197\nDatabase pages     259924\nOld database pages 95935\nModified db pages  55418\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1306578, not young 9215006\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4260500, created 25416, written 3202889\n0.00 reads/s, 0.00 creates/s, 332.54 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: 259924, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262122\nFree buffers       2197\nDatabase pages     259925\nOld database pages 95931\nModified db pages  54666\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1339090, not young 9314190\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4286227, created 25453, written 3211182\n0.00 reads/s, 0.00 creates/s, 332.54 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: 259925, unzip_LRU len: 0\nI/O sum[1868988]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262119\nFree buffers       2084\nDatabase pages     260035\nOld database pages 95977\nModified db pages  54988\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1342440, not young 9275101\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4291006, created 25388, written 3201562\n0.00 reads/s, 0.00 creates/s, 332.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: 260035, unzip_LRU len: 0\nI/O sum[1868988]: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=4137480, Main thread ID=140677066225344 , state=sleeping\nNumber of rows inserted 50638389, updated 97538150, deleted 3904421, read 476732908\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
