Add scraping of sys.innodb_lock_waits for additional QAN data
Duplicate
Description fields
General
Escalation
General
Escalation
Description
The QAN currently shows which queries are in lock_wait state, and for how long they are in this state. QAN does not show the query causing the block/wait. This would be extremely nice to have information to make QAN that much better.
Please consider adding sys.innodb_lock_waits to QAN scraping. QAN can then correlate query fingerprints to this table and show potential blocking queries.
The QAN currently shows which queries are in lock_wait state, and for how long they are in this state. QAN does not show the query causing the block/wait. This would be extremely nice to have information to make QAN that much better.
Please consider adding sys.innodb_lock_waits to QAN scraping. QAN can then correlate query fingerprints to this table and show potential blocking queries.