Подскажите пожалуйста MariaDB [(none)]> SHOW ENGINE INNODB STATUS; .... ------------ TRANSACTIONS ------------ Trx id counter 928462 Purge

Question

Подскажите пожалуйста MariaDB [(none)]> SHOW ENGINE INNODB STATUS; .... ------------ TRANSACTIONS ------------ Trx id counter 928462 Purge

done for trx's n:o < 917263 undo n:o < 0 state: running but idle
History list length 5592
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 917260, ACTIVE 22564 sec
2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1
MySQL thread id 284576, OS thread handle 139886623622912, query id 6163691 localhost 127.0.0.1 snapshot
Trx read view will not see trx with id >= 917260, sees < 917260

получатся эта блокировка висит уже 22564 секунд?

#mysql #programming #russian

0

15.01.2021