Logging Deadlocks

Percona Monitoring and Management (PMM) PMM 3.x
1

Hi!

Just wondering if PPM logs deadlocks in a similar manner to pt-deadlock-logger ?

I couldn’t find it anywhere. I do see the section called “InnoDB Locking” under “InnoDB Details”, but there doesn’t seem to be any section with deadlocks history, showing the actual queries and so.

My best choice would still be to run pt-deadlock-logger or enable innodb_print_all_deadlocks, is that correct?

Thank you very much!

2

Hello @nunop,
PMM does not monitor deadlocks. You can continue to use pt-deadlock-logger as before. You can also enable innodb_print_all_deadlocks and integrate Loki into PMM to scrape MySQL’s error log.