With MySQL or MariaDB, we like to log how often and when lock timeouts occur.
We certainly know how to debug lock timeouts with
SHOW ENGINE INNODB STATUS\G or using the table
What we would like to have is something like an option for the slow query log, to log only the lock timeouts. There is even a field like
Lock_time which might be useful. Would be the slow query log an option and how would the slow query log act on lock timeouts?