Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 08:01:52 140707627079360 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 38 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1803 srv_active, 0 srv_shutdown, 4 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 350463\nOS WAIT ARRAY INFO: signal count 363389\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 6457655\nPurge done for trx's n:o < 6457655 undo n:o < 0 state: running but idle\nHistory list length 70\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\n21731077 OS file reads, 23099988 OS file writes, 740872 OS fsyncs\n9060.15 reads/s, 16384 avg bytes/read, 12750.67 writes/s, 420.41 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 11, seg size 13, 39420 merges\nmerged operations:\n insert 39510, 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, 68314.97 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          485405837373\nLog buffer assigned up to    485405837373\nLog buffer completed up to   485405837373\nLog written up to            485405837373\nLog flushed up to            485405837373\nAdded dirty pages up to      485405837373\nPages flushed up to          485262761287\nLast checkpoint at           485262761287\nLog minimum file id is       450\nLog maximum file id is       459\n4620275 log i/o's done, 2105.85 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       32768\nDatabase pages     4161164\nOld database pages 1535728\nModified db pages  281090\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 6110552, not young 42142375\n2955.43 youngs/s, 21014.61 non-youngs/s\nPages read 21731705, created 188783, written 18298677\n9060.43 reads/s, 40.73 creates/s, 10537.96 writes/s\nBuffer pool hit rate 974 / 1000, young-making rate 8 / 1000 not 61 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 4161164, unzip_LRU len: 0\nI/O sum[16239648]:cur[0], 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  18327\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 372983, not young 2595328\n180.61 youngs/s, 1307.23 non-youngs/s\nPages read 1360537, created 11646, written 1143867\n569.79 reads/s, 2.43 creates/s, 656.78 writes/s\nBuffer pool hit rate 968 / 1000, young-making rate 10 / 1000 not 73 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 1\nBuffer pool size   262115\nFree buffers       2048\nDatabase pages     260067\nOld database pages 95981\nModified db pages  16514\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 380528, not young 2595059\n177.56 youngs/s, 1297.03 non-youngs/s\nPages read 1361953, created 11534, written 1143667\n563.65 reads/s, 2.30 creates/s, 657.45 writes/s\nBuffer pool hit rate 960 / 1000, young-making rate 12 / 1000 not 93 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262125\nFree buffers       2048\nDatabase pages     260077\nOld database pages 95984\nModified db pages  17629\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 371609, not young 2596137\n181.25 youngs/s, 1296.44 non-youngs/s\nPages read 1361789, created 11844, written 1143636\n557.94 reads/s, 3.64 creates/s, 654.43 writes/s\nBuffer pool hit rate 964 / 1000, young-making rate 11 / 1000 not 85 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262128\nFree buffers       2048\nDatabase pages     260080\nOld database pages 95986\nModified db pages  16212\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 378497, not young 2589372\n178.52 youngs/s, 1298.48 non-youngs/s\nPages read 1355151, created 11552, written 1143533\n561.63 reads/s, 3.54 creates/s, 654.43 writes/s\nBuffer pool hit rate 962 / 1000, young-making rate 12 / 1000 not 88 / 1000\nPages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s\nLRU len: 260080, unzip_LRU len: 0\nI/O sum[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 4\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  17569\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 377239, not young 2607342\n181.38 youngs/s, 1323.92 non-youngs/s\nPages read 1358373, created 11940, written 1143717\n564.01 reads/s, 2.38 creates/s, 656.55 writes/s\nBuffer pool hit rate 953 / 1000, young-making rate 15 / 1000 not 110 / 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[1014978]:cur[0], 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  17045\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 428656, not young 3118163\n186.19 youngs/s, 1318.31 non-youngs/s\nPages read 1337352, created 11301, written 1142902\n562.20 reads/s, 3.25 creates/s, 654.45 writes/s\nBuffer pool hit rate 967 / 1000, young-making rate 11 / 1000 not 78 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262126\nFree buffers       2048\nDatabase pages     260078\nOld database pages 95985\nModified db pages  17973\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 376706, not young 2589111\n191.40 youngs/s, 1334.48 non-youngs/s\nPages read 1355639, created 12389, written 1143571\n571.09 reads/s, 2.43 creates/s, 653.14 writes/s\nBuffer pool hit rate 987 / 1000, young-making rate 4 / 1000 not 32 / 1000\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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 7\nBuffer pool size   262118\nFree buffers       2048\nDatabase pages     260070\nOld database pages 95982\nModified db pages  18320\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 378186, not young 2613995\n184.59 youngs/s, 1309.76 non-youngs/s\nPages read 1360398, created 11956, written 1143834\n562.15 reads/s, 2.45 creates/s, 650.63 writes/s\nBuffer pool hit rate 982 / 1000, young-making rate 6 / 1000 not 42 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  18243\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 371323, not young 2592433\n171.67 youngs/s, 1282.67 non-youngs/s\nPages read 1356387, created 11634, written 1143717\n556.21 reads/s, 2.30 creates/s, 662.51 writes/s\nBuffer pool hit rate 974 / 1000, young-making rate 8 / 1000 not 61 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  17867\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 378309, not young 2600699\n191.56 youngs/s, 1333.52 non-youngs/s\nPages read 1361191, created 11519, written 1143736\n577.31 reads/s, 2.27 creates/s, 662.51 writes/s\nBuffer pool hit rate 972 / 1000, young-making rate 9 / 1000 not 66 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262119\nFree buffers       2048\nDatabase pages     260071\nOld database pages 95982\nModified db pages  18353\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 371598, not young 2594169\n179.39 youngs/s, 1317.43 non-youngs/s\nPages read 1357915, created 11806, written 1143695\n574.08 reads/s, 2.14 creates/s, 662.51 writes/s\nBuffer pool hit rate 982 / 1000, young-making rate 5 / 1000 not 41 / 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[1014978]:cur[0], 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  17112\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 382168, not young 2589907\n183.66 youngs/s, 1299.20 non-youngs/s\nPages read 1357097, created 11609, written 1143720\n558.43 reads/s, 2.87 creates/s, 662.51 writes/s\nBuffer pool hit rate 970 / 1000, young-making rate 9 / 1000 not 70 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  17162\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 385267, not young 2620030\n190.50 youngs/s, 1335.05 non-youngs/s\nPages read 1363068, created 11788, written 1143763\n575.35 reads/s, 3.49 creates/s, 662.51 writes/s\nBuffer pool hit rate 971 / 1000, young-making rate 9 / 1000 not 67 / 1000\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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  17541\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 379188, not young 2588624\n194.94 youngs/s, 1326.81 non-youngs/s\nPages read 1355719, created 12018, written 1143732\n575.11 reads/s, 2.40 creates/s, 662.51 writes/s\nBuffer pool hit rate 984 / 1000, young-making rate 5 / 1000 not 37 / 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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262123\nFree buffers       2048\nDatabase pages     260075\nOld database pages 95984\nModified db pages  17355\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 391129, not young 2628320\n201.84 youngs/s, 1304.73 non-youngs/s\nPages read 1363981, created 12023, written 1143835\n557.71 reads/s, 2.22 creates/s, 662.51 writes/s\nBuffer pool hit rate 968 / 1000, young-making rate 11 / 1000 not 75 / 1000\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[1014978]:cur[0], unzip sum[0]:cur[0]\n---BUFFER POOL 15\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  17868\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 387166, not young 2623686\n180.38 youngs/s, 1329.57 non-youngs/s\nPages read 1365155, created 12224, written 1143752\n573.77 reads/s, 0.62 creates/s, 662.51 writes/s\nBuffer pool hit rate 966 / 1000, young-making rate 10 / 1000 not 79 / 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[1014978]: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=3416890, Main thread ID=140707110164160 , state=sleeping\nNumber of rows inserted 14604250, updated 28077480, deleted 1121080, read 137414874\n7077.97 inserts/s, 13771.48 updates/s, 555.51 deletes/s, 68461.88 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
