Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 12:05:45 140677206779584 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 13 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1813 srv_active, 0 srv_shutdown, 51 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 57139722\nOS WAIT ARRAY INFO: signal count 6983394\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 18300363\nPurge done for trx's n:o < 18300363 undo n:o < 0 state: running but idle\nHistory list length 1\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\n66315340 OS file reads, 62112066 OS file writes, 2482304 OS fsyncs\n0.00 reads/s, 0 avg bytes/read, 4167.68 writes/s, 118.40 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 0, seg size 2, 44420 merges\nmerged operations:\n insert 45409, 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          507993851216\nLog buffer assigned up to    507993851216\nLog buffer completed up to   507993851216\nLog written up to            507993851216\nLog flushed up to            507993851216\nAdded dirty pages up to      507993851216\nPages flushed up to          507498368728\nLast checkpoint at           507498368728\nLog minimum file id is       450\nLog maximum file id is       480\n10488742 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   4193931\nFree buffers       34150\nDatabase pages     4159781\nOld database pages 1535217\nModified db pages  765008\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 23028069, not young 141267647\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 66332033, created 416856, written 50453590\n0.00 reads/s, 0.00 creates/s, 4133.71 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: 4159781, 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   262118\nFree buffers       2236\nDatabase pages     259882\nOld database pages 95913\nModified db pages  48543\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1410844, not young 8785536\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4144715, created 25388, written 3158874\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259882, 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 95966\nModified db pages  48077\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1442090, not young 8786609\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4154615, created 26182, written 3162009\n0.00 reads/s, 0.00 creates/s, 258.36 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   262126\nFree buffers       2203\nDatabase pages     259923\nOld database pages 95928\nModified db pages  47809\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1394257, not young 8725642\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4141502, created 25742, written 3138367\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259923, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262122\nFree buffers       2205\nDatabase pages     259917\nOld database pages 95925\nModified db pages  48986\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1450711, not young 8807912\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4148235, created 26409, written 3158822\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259917, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262122\nFree buffers       2244\nDatabase pages     259878\nOld database pages 95911\nModified db pages  48079\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1425899, not young 8844687\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4150365, created 26356, written 3147155\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259878, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 5\nBuffer pool size   262121\nFree buffers       2251\nDatabase pages     259870\nOld database pages 95908\nModified db pages  47951\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1569948, not young 9512675\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4152263, created 26139, written 3168063\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259870, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262116\nFree buffers       2132\nDatabase pages     259984\nOld database pages 95950\nModified db pages  47700\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1432795, not young 8792698\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4155102, created 26406, written 3152077\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259984, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262117\nFree buffers       2221\nDatabase pages     259896\nOld database pages 95918\nModified db pages  47492\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1437091, not young 8762556\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4151628, created 26247, written 3159620\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259896, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262120\nFree buffers       2225\nDatabase pages     259895\nOld database pages 95917\nModified db pages  46879\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1425524, not young 8762388\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4148891, created 25678, written 3175283\n0.00 reads/s, 0.00 creates/s, 258.36 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: 259895, 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       2049\nDatabase pages     260074\nOld database pages 95983\nModified db pages  48100\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1425173, not young 8774693\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4132687, created 25937, written 3149493\n0.00 reads/s, 0.00 creates/s, 258.36 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 10\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  47844\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1393566, not young 8708784\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4122194, created 24613, written 3123384\n0.00 reads/s, 0.00 creates/s, 258.36 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 11\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  47126\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1432947, not young 8772985\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4133909, created 26213, written 3148402\n0.00 reads/s, 0.00 creates/s, 258.36 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[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262121\nFree buffers       2049\nDatabase pages     260072\nOld database pages 95983\nModified db pages  48000\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1446600, not young 8813325\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4149533, created 26948, written 3143021\n0.00 reads/s, 0.00 creates/s, 258.36 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 13\nBuffer pool size   262127\nFree buffers       2048\nDatabase pages     260079\nOld database pages 95985\nModified db pages  47966\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1432789, not young 8742387\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4133778, created 26654, written 3157057\n0.00 reads/s, 0.00 creates/s, 258.36 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: 260079, unzip_LRU len: 0\nI/O sum[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  47755\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1462539, not young 8859752\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4159868, created 26125, written 3165411\n0.00 reads/s, 0.00 creates/s, 258.36 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[232030]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  46701\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 1445296, not young 8815018\n0.00 youngs/s, 0.00 non-youngs/s\nPages read 4152748, created 25819, written 3146552\n0.00 reads/s, 0.00 creates/s, 258.36 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--------------\nROW OPERATIONS\n--------------\n0 queries inside InnoDB, 0 queries in queue\n0 read views open inside InnoDB\nProcess ID=3871113, Main thread ID=140694959544000 , state=sleeping\nNumber of rows inserted 51170616, updated 98543623, deleted 3925611, read 501307929\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
