Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 11:30:15 140676095301312 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 42 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1803 srv_active, 0 srv_shutdown, 41 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 53904976\nOS WAIT ARRAY INFO: signal count 7315283\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 17920897\nPurge done for trx's n:o < 17920897 undo n:o < 0 state: running but idle\nHistory list length 25\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: doing file i/o (write thread) ev set\nI/O thread 28 state: doing file i/o (write thread) ev set\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, 25, 29, 0, 0, 0, 0] ,\n ibuf aio reads:\nPending flushes (fsync) log: 0; buffer pool: 0\n66700109 OS file reads, 62081673 OS file writes, 2849831 OS fsyncs\n0 pending preads, 2 pending pwrites\n0.00 reads/s, 0 avg bytes/read, 5221.01 writes/s, 161.32 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 17, seg size 19, 50505 merges\nmerged operations:\n insert 51894, 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.12 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          507093987937\nLog buffer assigned up to    507093987937\nLog buffer completed up to   507093987937\nLog written up to            507093987937\nLog flushed up to            507093987937\nAdded dirty pages up to      507093987937\nPages flushed up to          506595557653\nLast checkpoint at           506595557653\nLog minimum file id is       450\nLog maximum file id is       479\n10231337 log i/o's done, 0.12 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 899999\nBuffer pool size   4193927\nFree buffers       33800\nDatabase pages     4160127\nOld database pages 1535374\nModified db pages  801243\nPending reads      0\nPending writes: LRU 0, flush list 172, single page 0\nPages made young 22577142, not young 141151445\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 66717434, created 408559, written 50275492\n0.00 reads/s, 0.00 creates/s, 5178.84 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: 4160127, unzip_LRU len: 0\nI/O sum[10451392]:cur[52000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262124\nFree buffers       2213\nDatabase pages     259911\nOld database pages 95923\nModified db pages  50244\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1375498, not young 8761958\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4164892, created 24525, written 3139609\n0.00 reads/s, 0.00 creates/s, 323.94 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: 259911, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262115\nFree buffers       2237\nDatabase pages     259878\nOld database pages 95911\nModified db pages  50405\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1424231, not young 8798778\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4185903, created 25688, written 3152578\n0.00 reads/s, 0.00 creates/s, 322.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: 259878, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262120\nFree buffers       2200\nDatabase pages     259920\nOld database pages 95927\nModified db pages  50668\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1372929, not young 8726489\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4160669, created 25428, written 3136912\n0.00 reads/s, 0.00 creates/s, 324.32 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: 259920, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262120\nFree buffers       2241\nDatabase pages     259879\nOld database pages 95911\nModified db pages  50760\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1430236, not young 8821851\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4180119, created 26204, written 3148291\n0.00 reads/s, 0.00 creates/s, 322.63 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: 259879, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262122\nFree buffers       2055\nDatabase pages     260067\nOld database pages 95981\nModified db pages  50488\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1411698, not young 8853903\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4177876, created 25790, written 3139034\n0.00 reads/s, 0.00 creates/s, 323.85 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: 260067, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262129\nFree buffers       2212\nDatabase pages     259917\nOld database pages 95925\nModified db pages  50446\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1506070, not young 9406119\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4164810, created 26005, written 3149145\n0.00 reads/s, 0.00 creates/s, 324.18 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: 259917, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262115\nFree buffers       2048\nDatabase pages     260067\nOld database pages 95981\nModified db pages  49954\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1407356, not young 8809547\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4182463, created 26381, written 3150198\n0.00 reads/s, 0.00 creates/s, 322.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: 260067, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  49220\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1415841, not young 8758194\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4174192, created 26121, written 3154711\n0.00 reads/s, 0.00 creates/s, 321.61 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[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  49629\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1396312, not young 8751371\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4174249, created 25486, written 3167235\n0.00 reads/s, 0.00 creates/s, 326.89 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: 260073, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], 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  49683\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1397331, not young 8787307\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4159903, created 24274, written 3135487\n0.00 reads/s, 0.00 creates/s, 326.89 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: 260070, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], 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  50491\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1369430, not young 8721669\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4150517, created 25264, written 3123219\n0.00 reads/s, 0.00 creates/s, 326.89 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: 260073, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  50093\nPending reads      0\nPending writes: LRU 0, flush list 25, single page 0\nPages made young 1404130, not young 8752783\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4151876, created 25200, written 3130317\n0.00 reads/s, 0.00 creates/s, 326.30 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[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262118\nFree buffers       2106\nDatabase pages     260012\nOld database pages 95983\nModified db pages  49423\nPending reads      0\nPending writes: LRU 0, flush list 147, single page 0\nPages made young 1420268, not young 8829592\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4178032, created 25948, written 3134990\n0.00 reads/s, 0.00 creates/s, 323.40 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: 260012, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262115\nFree buffers       2048\nDatabase pages     260067\nOld database pages 95981\nModified db pages  50589\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1394795, not young 8727256\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4151828, created 25905, written 3137464\n0.00 reads/s, 0.00 creates/s, 320.95 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[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262121\nFree buffers       2152\nDatabase pages     259969\nOld database pages 95952\nModified db pages  49519\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1426985, not young 8839176\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4177797, created 25111, written 3140156\n0.00 reads/s, 0.00 creates/s, 320.95 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: 259969, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262129\nFree buffers       2048\nDatabase pages     260081\nOld database pages 95986\nModified db pages  49631\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1424032, not young 8805452\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4182308, created 25229, written 3136146\n0.00 reads/s, 0.00 creates/s, 320.95 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: 260081, unzip_LRU len: 0\nI/O sum[653212]:cur[3250], 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=3805342, Main thread ID=140691531552448 , state=sleeping\nNumber of rows inserted 50016325, updated 96278514, deleted 3840982, read 479694898\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
