pt-heartbeat super privilege
# rpm -q mysql-server percona-toolkit
Starting with an user that lacks necessary privileges brings me this.
Starting pt-heartbeat: DBD::mysql::db selectrow_hashref failed: Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation [for Statement "SHOW MASTER STATUS"] at /usr/bin/
This error message is could easily trick an admin to think that both privileges are necessary. The mysql docu at
The REPLICATION CLIENT privilege enables the use of SHOW MASTER STATUS and SHOW SLAVE STATUS.
so super is not needed.
mysqld actually permits max_connections+1 clients to connect. etc...
Therefore I think it's important not to give SUPER privilege unnecessary. pt-heartbeat could eat up your extra connection slot (Imagine a full log partition for example)
I think the error message should read
you need the REPLICATION CLIENT privilege
you need the SUPER,REPLICATION CLIENT privilege