pmp-check-mysql-deadlocks table doesn't exist

I’m testing nagios plugins, when I run pmp-check-mysql-deadlocks -H mytest-db -l nagios -p passwod
ERROR 1146 (42S02) at line 1: Table ‘percona.deadlocks’ doesn’t exist
UNK could not count deadlocks

How does the table get created? which database should the table be created?


The pmp-check-mysql-deadlocks plugin pulls data from a table that pt-deadlock-logger creates and logs to (

So you would first need to get pt-deadlock-logger up and running, at which point the table will be created (–dest) and then you should be able to get pmp-check-mysql-deadlocks working at that point.