Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 12:41:25 140648581822144 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 29 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1825 srv_active, 0 srv_shutdown, 58 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 65415520\nOS WAIT ARRAY INFO: signal count 7205197\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 18293765\nPurge done for trx's n:o < 18293765 undo n:o < 0 state: running but idle\nHistory list length 113\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\n62140699 OS file reads, 59359919 OS file writes, 1889807 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 4091.34 writes/s, 119.14 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 0, seg size 2, 38391 merges\nmerged operations:\n insert 39913, 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, 0.00 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          508044118225\nLog buffer assigned up to    508044118225\nLog buffer completed up to   508044118225\nLog written up to            508044118225\nLog flushed up to            508044118225\nAdded dirty pages up to      508044118225\nPages flushed up to          507527284832\nLast checkpoint at           507527284832\nLog minimum file id is       450\nLog maximum file id is       480\n10486568 log i/o's done, 0.00 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 899999\nBuffer pool size   4193930\nFree buffers       32876\nDatabase pages     4161054\nOld database pages 1535703\nModified db pages  719376\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 22308209, not young 132983662\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 62158463, created 419221, written 48332023\n0.00 reads/s, 0.00 creates/s, 4057.96 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: 4161054, unzip_LRU len: 0\nI/O sum[3712480]:cur[64000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  46241\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1364613, not young 8246908\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3877936, created 25438, written 3023304\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260073, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262123\nFree buffers       2095\nDatabase pages     260028\nOld database pages 95982\nModified db pages  45300\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1399167, not young 8278896\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3899537, created 25694, written 3031723\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260028, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  45123\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1360913, not young 8221696\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3889413, created 26065, written 3028871\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260075, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  45818\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1396806, not young 8272714\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3886839, created 25959, written 3018094\n0.00 reads/s, 0.00 creates/s, 253.62 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[232030]:cur[4000], 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  45339\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1372905, not young 8261219\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3873733, created 25351, written 3000033\n0.00 reads/s, 0.00 creates/s, 253.62 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[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262114\nFree buffers       2048\nDatabase pages     260066\nOld database pages 95980\nModified db pages  45129\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1549103, not young 9066352\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3888175, created 25770, written 3024229\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260066, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262117\nFree buffers       2109\nDatabase pages     260008\nOld database pages 95961\nModified db pages  45730\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1384768, not young 8236972\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3877931, created 26176, written 3010956\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260008, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  44442\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1392092, not young 8332222\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3900527, created 33310, written 3037813\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260075, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], 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  44786\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1379076, not young 8236307\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3885354, created 25407, written 3044203\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260073, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  44778\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1381747, not young 8257198\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3871173, created 25393, written 3018095\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260075, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  44260\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1363980, not young 8214353\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3878266, created 25813, written 3010093\n0.00 reads/s, 0.00 creates/s, 253.62 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[232030]:cur[4000], 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  45146\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1389734, not young 8233601\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3877877, created 25591, written 3015979\n0.00 reads/s, 0.00 creates/s, 253.62 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[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  43729\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1396749, not young 8320585\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3897642, created 25522, written 3017672\n0.00 reads/s, 0.00 creates/s, 253.62 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[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  44961\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1377786, not young 8196430\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3867822, created 25677, written 3019582\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260075, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  43906\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1408119, not young 8328788\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3897180, created 25981, written 3017768\n0.00 reads/s, 0.00 creates/s, 253.62 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[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262114\nFree buffers       2048\nDatabase pages     260066\nOld database pages 95980\nModified db pages  44688\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1390651, not young 8279421\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 3889058, created 26074, written 3013608\n0.00 reads/s, 0.00 creates/s, 253.62 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: 260066, unzip_LRU len: 0\nI/O sum[232030]: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=3937796, Main thread ID=140691110786752 , state=sleeping\nNumber of rows inserted 51304662, updated 98528807, deleted 3915592, read 521656399\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
