MariaDB [demo1]> SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2025-05-08 18:06:12 0x7402b464e6c0 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 48 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1 srv_active, 54189 srv_idle srv_master_thread log flush and writes: 54186 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 29022495 Purge done for trx's n:o < 28317086 undo n:o < 0 state: running History list length 233180 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION (0x7405a41fd080), ACTIVE 25129 sec mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 47297, OS thread handle 127554960967360, query id 1821873 localhost root SELECT /*!40001 SQL_NO_CACHE */ id, parent_id, tree_level, type_id, name, code, accepted, begin_date, end_date, priority, status_id, status_changed_at, procurement_id, procannounce_id, updated_at, origin_id, estimate_hours, in_budget, priority_id, contract_id, procannounce_end_id, is_deleted, assessment_class_id, law_type_id, lawmaking_milestone_id, percent_done, special_field_id, starred, spent_hours_total, estimate_hours_total, public, kpi_type, kpi_target, kpi_real, default_budget_source_id, position, owner_account_id, scheduling_mode, is_manually_scheduled, calendar_id, constraint_type, constraint_date, planned_amount, import_id, import_parent_id FROM activities Trx read view will not see trx with id >= 28367313, sees < 28367313 ---TRANSACTION (0x7405a4226f80), ACTIVE 26333 sec mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MariaDB thread id 41801, OS thread handle 127555010918080, query id 1695001 localhost root SELECT /*!40001 SQL_NO_CACHE */ id, parent_id, tree_level, type_id, name, code, accepted, begin_date, end_date, priority, status_id, status_changed_at, procurement_id, procannounce_id, updated_at, origin_id, estimate_hours, in_budget, priority_id, contract_id, procannounce_end_id, is_deleted, assessment_class_id, law_type_id, lawmaking_milestone_id, percent_done, special_field_id, starred, spent_hours_total, estimate_hours_total, public, kpi_type, kpi_target, kpi_real, default_budget_source_id, position, owner_account_id, scheduling_mode, is_manually_scheduled, calendar_id, constraint_type, constraint_date, planned_amount, import_id, import_parent_id FROM activities Trx read view will not see trx with id >= 28317085, sees < 28317085 ---TRANSACTION (0x7405a421ca80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4224e80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4224380), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a421f680), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4222280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4221780), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4220c80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4220180), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a421eb80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a421e080), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a421b480), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a421a980), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a421bf80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a421d580), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4219e80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4219380), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4218880), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4217280), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4216780), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4215c80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4214680), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4223880), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4222d80), not started mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4213080), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4215180), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4213b80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4210f80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4212580), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420cd80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420f980), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420c280), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4211a80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420ee80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420ac80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420a180), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4208b80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4217d80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4209680), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420d880), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420e380), not started mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4208080), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a420b780), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4205f80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4204980), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4203380), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4202880), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4207580), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4201280), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4200780), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4206a80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4210480), not started mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4201d80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ffc80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4203e80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ff180), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41fc580), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41fba80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41faf80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41fa480), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a4205480), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f8380), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f7880), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f6d80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f6280), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f5780), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f4c80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f2080), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41fe680), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f8e80), not started mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f1580), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f0a80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41eb280), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ea780), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e9c80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f2b80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e9180), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f9980), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41eff80), not started mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ee980), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ec880), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f3680), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e8680), not started mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e7080), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ed380), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e5a80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e2e80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e7b80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e6580), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ef480), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41f4180), not started mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e4f80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e2380), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e1880), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e0280), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e0d80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41df780), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e3980), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41dcb80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41dec80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41de180), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41daa80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d9f80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41db580), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41e4480), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d9480), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d8980), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d7e80), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d7380), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d6880), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d5280), not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d4780), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d1b80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41c7680), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41dc080), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41cfa80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41cc380), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41cad80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41c8c80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41c6b80), not started mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41dd680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d5d80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d3c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d1080), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d0580), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41cef80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d3180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41d2680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41cd980), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41cce80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41cb880), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41ca280), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41c9780), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7405a41c8180), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync): 0 303809 OS file reads, 27849 OS file writes, 432535 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 2.90 fsyncs/s --- LOG --- Log sequence number 54112034517 Log flushed up to 54112034517 Pages flushed up to 54077586495 Last checkpoint at 54077586495 ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 11844714496 Dictionary memory allocated 4227408 Buffer pool size 713856 Free buffers 406318 Database pages 307538 Old database pages 113504 Modified db pages 8046 Percent of dirty pages(LRU & free pages): 1.127 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 64582, not young 5610006 0.00 youngs/s, 0.00 non-youngs/s Pages read 298931, created 31110, written 27694 0.00 reads/s, 0.12 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: 307538, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 2 read views open inside InnoDB state: sleeping ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.001 sec)