Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 10:55:02 140693485250240 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 29 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1799 srv_active, 0 srv_shutdown, 31 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 46033685\nOS WAIT ARRAY INFO: signal count 6049699\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 18275055\nPurge done for trx's n:o < 18275055 undo n:o < 0 state: running but idle\nHistory list length 54\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\n68748150 OS file reads, 66188555 OS file writes, 5336049 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 5106.08 writes/s, 151.25 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 45, seg size 47, 50856 merges\nmerged operations:\n insert 54549, 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.62 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          507604338034\nLog buffer assigned up to    507604338034\nLog buffer completed up to   507604338034\nLog written up to            507604338034\nLog flushed up to            507604338034\nAdded dirty pages up to      507604338034\nPages flushed up to          507099295663\nLast checkpoint at           507099295663\nLog minimum file id is       450\nLog maximum file id is       479\n10468062 log i/o's done, 0.17 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       34559\nDatabase pages     4159373\nOld database pages 1535182\nModified db pages  838362\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 22490337, not young 147951769\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 68769161, created 415746, written 51475655\n0.00 reads/s, 0.00 creates/s, 5064.47 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: 4159373, unzip_LRU len: 0\nI/O sum[20130096]:cur[0], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262117\nFree buffers       2087\nDatabase pages     260030\nOld database pages 95967\nModified db pages  53444\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1383832, not young 9228418\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4303678, created 26162, written 3235914\n0.00 reads/s, 0.00 creates/s, 316.53 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: 260030, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262122\nFree buffers       2100\nDatabase pages     260022\nOld database pages 95994\nModified db pages  52882\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1416691, not young 9216014\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4310264, created 26586, written 3227435\n0.00 reads/s, 0.00 creates/s, 316.53 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[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262122\nFree buffers       2092\nDatabase pages     260030\nOld database pages 96007\nModified db pages  53281\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1376043, not young 9177700\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4307873, created 26546, written 3222750\n0.00 reads/s, 0.00 creates/s, 316.53 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: 260030, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262124\nFree buffers       2059\nDatabase pages     260065\nOld database pages 95993\nModified db pages  53183\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1426974, not young 9250277\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4307211, created 26560, written 3219276\n0.00 reads/s, 0.00 creates/s, 316.53 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: 260065, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  52272\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1393368, not young 9262422\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4295385, created 26139, written 3207518\n0.00 reads/s, 0.00 creates/s, 316.53 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: 260077, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262119\nFree buffers       2143\nDatabase pages     259976\nOld database pages 95952\nModified db pages  53201\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1474206, not young 9749035\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4287313, created 25437, written 3217591\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259976, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], 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  52675\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1406249, not young 9261517\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4318412, created 26578, written 3227173\n0.00 reads/s, 0.00 creates/s, 316.53 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[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262119\nFree buffers       2129\nDatabase pages     259990\nOld database pages 95981\nModified db pages  51788\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1415132, not young 9220618\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4318135, created 26352, written 3232706\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259990, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262123\nFree buffers       2199\nDatabase pages     259924\nOld database pages 95928\nModified db pages  52631\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1393154, not young 9166160\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4298204, created 25527, written 3232518\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259924, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262118\nFree buffers       2203\nDatabase pages     259915\nOld database pages 95925\nModified db pages  52252\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1395693, not young 9198527\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4277902, created 25115, written 3206413\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259915, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262117\nFree buffers       2248\nDatabase pages     259869\nOld database pages 95908\nModified db pages  51763\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1360658, not young 9122439\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4272105, created 25618, written 3200073\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259869, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262117\nFree buffers       2296\nDatabase pages     259821\nOld database pages 95890\nModified db pages  51709\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1401953, not young 9164425\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4277836, created 24776, written 3203139\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259821, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262126\nFree buffers       2257\nDatabase pages     259869\nOld database pages 95908\nModified db pages  51824\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1408998, not young 9248845\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4299235, created 26224, written 3210169\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259869, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262123\nFree buffers       2274\nDatabase pages     259849\nOld database pages 95900\nModified db pages  51784\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1386791, not young 9148676\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4272492, created 26306, written 3208525\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259849, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262113\nFree buffers       2187\nDatabase pages     259926\nOld database pages 95929\nModified db pages  52391\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1434192, not young 9294677\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4314832, created 26597, written 3227052\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259926, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262128\nFree buffers       2189\nDatabase pages     259939\nOld database pages 95934\nModified db pages  51282\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1416403, not young 9242019\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4308284, created 25223, written 3197403\n0.00 reads/s, 0.00 creates/s, 316.53 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: 259939, unzip_LRU len: 0\nI/O sum[1258131]:cur[0], 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=3740131, Main thread ID=140694832027328 , state=sleeping\nNumber of rows inserted 51120282, updated 98401443, deleted 3931428, read 484798476\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
