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

Archived Projects Percona Monitoring Plugins
1

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?

thanks
Wolf

2

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

So you would first need to get pt-deadlock-logger up and running, at which point the table will be created ([url]pt-deadlock-logger — Percona Toolkit Documentation) and then you should be able to get pmp-check-mysql-deadlocks working at that point.