*************************** 1. row *************************** InnoDB ===================================== 2023-08-18 10:51:09 0x7f8fd7e88700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 44 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 12749 srv_idle srv_master_thread log flush and writes: 12749 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 922420 Purge done for trx's n:o < 922420 undo n:o < 0 state: running History list length 2037 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7f900c38a680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c383880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37e080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c382d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37d580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c389b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c389080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c388580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c387a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c386f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c386480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c385980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c384e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c384380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c382280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c381780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c380c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c380180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37f680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37eb80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37ca80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37bf80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37b480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c37a980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c379e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c379380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c378880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c377d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c377280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c376780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c375c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c375180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c374680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c373b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c372580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c371a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c370f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c370480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36f980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36ee80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36e380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36d880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36cd80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36c280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36b780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36ac80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c36a180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c369680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c368b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c368080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c367580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c366a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c365f80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c365480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c364980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c363e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c363380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c362880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c361d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c360780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35f180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35e680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35c580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35af80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35a480), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c359980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c358e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c357880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c356d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c356280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c354180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35ba80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c358380), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c361280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35fc80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35db80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c355780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c354c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c373080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c35d080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c353680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7f900c352b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 957 OS file reads, 424542 OS file writes, 391078 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 46.75 writes/s, 46.75 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 973730981 Log flushed up to 973730981 Pages flushed up to 916445439 Last checkpoint at 916445439 0 pending log flushes, 0 pending chkp writes 390372 log i/o's done, 46.75 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 704643072 Dictionary memory allocated 4058952 Buffer pool size 40560 Free buffers 17486 Database pages 23074 Old database pages 8497 Modified db pages 3433 Percent of dirty pages(LRU & free pages): 8.464 Max dirty pages percent: 10.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 1200, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 828, created 25551, written 34090 0.00 reads/s, 2.55 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 23074, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 378323, updated 0, deleted 178953, read 604674 45.59 inserts/s, 0.00 updates/s, 0.00 deletes/s, 44.61 reads/s Number of system rows inserted 378778, updated 0, deleted 378751, read 378753 45.59 inserts/s, 0.00 updates/s, 45.09 deletes/s, 45.09 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================