Type	Name	Status
InnoDB		\n=====================================\n2026-10-09 08:36:04 140718027839168 INNODB MONITOR OUTPUT\n=====================================\nPer second averages calculated from the last 42 seconds\n-----------------\nBACKGROUND THREAD\n-----------------\nsrv_master_thread loops: 1804 srv_active, 0 srv_shutdown, 7 srv_idle\nsrv_master_thread log flush and writes: 0\n----------\nSEMAPHORES\n----------\nOS WAIT ARRAY INFO: reservation count 697653\nOS WAIT ARRAY INFO: signal count 711971\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 10848217\nPurge done for trx's n:o < 10848217 undo n:o < 0 state: running but idle\nHistory list length 0\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\n39363807 OS file reads, 39700731 OS file writes, 1245841 OS fsyncs\n15839.20 reads/s, 16384 avg bytes/read, 19298.02 writes/s, 610.00 fsyncs/s\n-------------------------------------\nINSERT BUFFER AND ADAPTIVE HASH INDEX\n-------------------------------------\nIbuf: size 1, free list len 59, seg size 61, 43592 merges\nmerged operations:\n insert 45153, 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, 118826.05 non-hash searches/s\n---\nLOG\n---\nLog capacity                 34359738368\nLog capacity used            34359738368\nLog sequence number          493706538614\nLog buffer assigned up to    493706538614\nLog buffer completed up to   493706538614\nLog written up to            493706538614\nLog flushed up to            493706538614\nAdded dirty pages up to      493706538614\nPages flushed up to          493412574532\nLast checkpoint at           493412574532\nLog minimum file id is       450\nLog maximum file id is       466\n6795032 log i/o's done, 2942.55 log i/o's/second\n----------------------\nBUFFER POOL AND MEMORY\n----------------------\nTotal large memory allocated 0\nDictionary memory allocated 899999\nBuffer pool size   4193928\nFree buffers       32768\nDatabase pages     4161160\nOld database pages 1535728\nModified db pages  519006\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 11985409, not young 81708905\n5226.44 youngs/s, 36183.11 non-youngs/s\nPages read 39367002, created 273116, written 32615375\n15840.49 reads/s, 76.89 creates/s, 16283.61 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: 4161160, unzip_LRU len: 0\nI/O sum[26683616]:cur[64000], unzip sum[0]:cur[0]\n----------------------\nINDIVIDUAL BUFFER POOL INFO\n----------------------\n---BUFFER POOL 0\nBuffer pool size   262131\nFree buffers       2048\nDatabase pages     260083\nOld database pages 95987\nModified db pages  33416\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 742857, not young 5062589\n319.07 youngs/s, 2256.59 non-youngs/s\nPages read 2461386, created 17047, written 2038755\n978.91 reads/s, 5.94 creates/s, 1007.18 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: 260083, unzip_LRU len: 0\nI/O sum[1667726]:cur[4000], 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  33102\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 753695, not young 5075418\n335.71 youngs/s, 2249.92 non-youngs/s\nPages read 2467256, created 17009, written 2038512\n993.41 reads/s, 5.03 creates/s, 1007.18 writes/s\nBuffer pool hit rate 961 / 1000, young-making rate 13 / 1000 not 89 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 2\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  33261\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 727512, not young 5063965\n327.11 youngs/s, 2276.18 non-youngs/s\nPages read 2469148, created 17247, written 2038567\n1008.57 reads/s, 4.12 creates/s, 1007.18 writes/s\nBuffer pool hit rate 960 / 1000, young-making rate 13 / 1000 not 92 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 3\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  31705\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 750532, not young 5067559\n325.06 youngs/s, 2259.48 non-youngs/s\nPages read 2462016, created 16849, written 2038419\n994.94 reads/s, 3.80 creates/s, 1007.18 writes/s\nBuffer pool hit rate 962 / 1000, young-making rate 12 / 1000 not 86 / 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[1667726]:cur[4000], 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  32154\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 743584, not young 5089124\n323.92 youngs/s, 2267.86 non-youngs/s\nPages read 2454780, created 16859, written 2038363\n981.29 reads/s, 4.36 creates/s, 1007.18 writes/s\nBuffer pool hit rate 951 / 1000, young-making rate 16 / 1000 not 114 / 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[1667726]:cur[4000], 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  32174\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 800846, not young 5579556\n323.62 youngs/s, 2274.46 non-youngs/s\nPages read 2439541, created 16746, written 2036520\n998.39 reads/s, 5.66 creates/s, 1007.18 writes/s\nBuffer pool hit rate 967 / 1000, young-making rate 10 / 1000 not 76 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 6\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  32656\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 748721, not young 5077660\n332.40 youngs/s, 2247.27 non-youngs/s\nPages read 2465265, created 17030, written 2038495\n983.88 reads/s, 5.85 creates/s, 1007.18 writes/s\nBuffer pool hit rate 987 / 1000, young-making rate 4 / 1000 not 31 / 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[1667726]: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  32133\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 747187, not young 5064933\n322.73 youngs/s, 2271.15 non-youngs/s\nPages read 2467000, created 17256, written 2038697\n999.11 reads/s, 5.36 creates/s, 1007.18 writes/s\nBuffer pool hit rate 981 / 1000, young-making rate 6 / 1000 not 43 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 8\nBuffer pool size   262117\nFree buffers       2048\nDatabase pages     260069\nOld database pages 95982\nModified db pages  34693\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 737366, not young 5061132\n320.05 youngs/s, 2266.58 non-youngs/s\nPages read 2460539, created 17312, written 2038718\n996.74 reads/s, 4.36 creates/s, 1017.17 writes/s\nBuffer pool hit rate 976 / 1000, young-making rate 7 / 1000 not 55 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 9\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  32964\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 748845, not young 5075193\n330.33 youngs/s, 2263.39 non-youngs/s\nPages read 2456013, created 17096, written 2038589\n993.31 reads/s, 5.13 creates/s, 1025.63 writes/s\nBuffer pool hit rate 975 / 1000, young-making rate 8 / 1000 not 58 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 10\nBuffer pool size   262127\nFree buffers       2048\nDatabase pages     260079\nOld database pages 95985\nModified db pages  32148\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 727882, not young 5040084\n317.16 youngs/s, 2225.62 non-youngs/s\nPages read 2449674, created 16938, written 2038577\n974.49 reads/s, 4.61 creates/s, 1030.12 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: 260079, unzip_LRU len: 0\nI/O sum[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 11\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  31748\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 758275, not young 5079979\n329.68 youngs/s, 2259.62 non-youngs/s\nPages read 2462570, created 17247, written 2038633\n982.25 reads/s, 5.52 creates/s, 1031.38 writes/s\nBuffer pool hit rate 969 / 1000, young-making rate 10 / 1000 not 71 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 12\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  31683\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 744497, not young 5091508\n323.29 youngs/s, 2243.82 non-youngs/s\nPages read 2463449, created 17308, written 2038669\n975.79 reads/s, 3.12 creates/s, 1031.38 writes/s\nBuffer pool hit rate 971 / 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[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 13\nBuffer pool size   262121\nFree buffers       2048\nDatabase pages     260073\nOld database pages 95983\nModified db pages  31806\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 739057, not young 5061630\n320.50 youngs/s, 2236.60 non-youngs/s\nPages read 2452689, created 16775, written 2038563\n976.26 reads/s, 4.64 creates/s, 1029.08 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: 260073, unzip_LRU len: 0\nI/O sum[1667726]:cur[4000], unzip sum[0]:cur[0]\n---BUFFER POOL 14\nBuffer pool size   262120\nFree buffers       2048\nDatabase pages     260072\nOld database pages 95983\nModified db pages  31499\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 761354, not young 5111369\n346.92 youngs/s, 2292.54 non-youngs/s\nPages read 2467488, created 16872, written 2038628\n999.44 reads/s, 4.29 creates/s, 1030.01 writes/s\nBuffer pool hit rate 964 / 1000, young-making rate 12 / 1000 not 82 / 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[1667726]: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  31864\nPending reads      0\nPending writes: LRU 0, flush list 0, single page 0\nPages made young 753199, not young 5107206\n328.88 youngs/s, 2292.05 non-youngs/s\nPages read 2468188, created 17525, written 2038670\n1003.70 reads/s, 5.10 creates/s, 1031.43 writes/s\nBuffer pool hit rate 962 / 1000, young-making rate 12 / 1000 not 87 / 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[1667726]: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=3481684, Main thread ID=140694490678976 , state=sleeping\nNumber of rows inserted 28181279, updated 54252313, deleted 2170769, read 265133789\n12469.85 inserts/s, 23966.38 updates/s, 956.43 deletes/s, 117791.60 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
