===================================== 2022-11-07 18:45:49 0x7eff4e911700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 30 seconds ------------------------ LATEST FOREIGN KEY ERROR ------------------------ [empty] ------------------------ LATEST DETECTED DEADLOCK ------------------------ [empty] ------------ TRANSACTIONS ------------ Trx id counter 594417487702 Purge done for trx's n:o < 594417487700 undo n:o < 0 state: running but idle History list length 8 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 594417487701, ACTIVE 2 sec fetching rows mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1136, 6 row lock(s), undo log entries 5 MySQL thread id 1982663, OS thread handle 139635002324736, query id 40820217 10.64.148.238 NovikovM updating DELETE FROM my_table WHERE id BETWEEN 1 AND 5 ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 31660 page no 3 n bits 80 index PRIMARY of table `my_db`.`my_table` trx id 594417487701 lock_mode X locks rec but not gap waiting ------------------ ---TRANSACTION 594417487700, ACTIVE 4 sec 2 lock struct(s), heap size 1136, 5 row lock(s), undo log entries 5 MySQL thread id 1982664, OS thread handle 139639270323968, query id 40820215 10.64.148.238 NovikovM ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- [lots of data that have no relation to the bug] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 2 RW transactions active inside InnoDB Process ID=1249, Main thread ID=139633992128256, state: sleeping Number of rows inserted 3515377841, updated 11543460, deleted 11391349, read 1199999711525 0.33 inserts/s, 0.00 updates/s, 0.33 deletes/s, 0.33 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================