Install Percona Monitoring Tools for Nagios – MySQL Plugins
Kedar
Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log…
Browsing Tag
percona monitoring tools for nagios
1 post
7 responses to “Install Percona Monitoring Tools for Nagios – MySQL Plugins”
Hi kedar,
i am getting below error for active threads.
ERROR 1045 (28000): Access denied for user ‘user’@’X.X.X.X’ (using password: NO)
kindly help
Regards,
Balu
“using password: NO” — Are you not providing password? Is that correct?
@Ashish Karpe The url below may help you. You can try:
https://translate.google.com/translate?hl=en&sl=ru&u=https://kamaok.org.ua/%3Fp%3D1470&prev=search
Hi,
Here is sample nrpe.cfg for percona-mysql plugins !
command[check_mysql_service]=/usr/local/nagios/libexec/check_mysqld.pl -H 192.168.1.68 -u root -p xx -a slow_queries -w 44 -c 55
#command[check_mysql_service]=/usr/local/nagios/libexec/check_mysql -H 192.168.168 –extra-opts=client@/etc/nagios/mysql.cnf
command[check_mysql_innodb]=/usr/local/nagios/libexec/pmp-check-mysql-innodb -H 192.168.1.68 -C idle_blocker_duration -w 60 -c 600
command[check_mysql_innodb]=/usr/local/nagios/libexec/pmp-check-mysql-innodb -H 192.168.1.68 -C max_duration -w 86400 -c 172800
command[check_mysql_active_threads]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -H 192.168.1.68 -x Threads_running -w 20 -c 40
command[rdba_mysql_pidfile]=/usr/lib64/nagios/plugins/pmp-check-mysql-pidfile
command[rdba_unix_memory]=/usr/lib64/nagios/plugins/pmp-check-unix-memory -d -w 96 -c 98
command[check_mysql_deadlocks]=/usr/lib64/nagios/plugins/pmp-check-mysql-deadlocks -H 192.168.1.68 -i 5 -w 12 -c 60
command[check_mysql_connections]=/usr/lib64/nagios/plugins/pmp-check-mysql-status -H 192.168.1.68 -x Threads_connected -o / -y max_connections -T pct -w 80 -c 95
command[check_mysql_replication_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay -H 192.168.1.68 -w 650 -c 600
#command[check_mysql_replication_delay]=/usr/lib64/nagios/plugins/pmp-check-mysql-replication-delay -H $HOSTADDRESS$ -w $ARG1$ -c $ARG2$
#command[rdba_mysql_pidfile]=/usr/lib64/nagios/plugins/pmp-check-mysql-pidfile
#command[pmp-check-mysql-processlist]=/usr/lib64/nagios/plugins/pmp-check-mysql-processlist
#command[check_mysql_counters_percona]=/usr/local/nagios/libexec/check_mysql_counters -H 192.168.1.69 -P 3306 -u root -p xxxx
command[check_mysql_processlist]=/usr/local/nagios/libexec/pmp-check-mysql-processlist -H 192.168.1.68 -w 80 -c 100
#command[check_mysql_processlist]=/usr/local/nagios/libexec/pmp-check-mysql-processlist -H 192.168.1.68 -C max_user_conn -w 80 -c 100
#command[check_mysql_processlist]=/usr/local/nagios/libexec/pmp-check-mysql-processlist -H 192.168.1.68 -C 512 -w 80 -c 100
#command[check_mysql_table_checksum]=/usr/local/nagios/libexec/pmp-check-pt-table-checksum -H 192.168.1.69
command[check_mysql_replication_running]=/usr/local/nagios/libexec/pmp-check-mysql-replication-running -H 192.168.1.68
Can i get sample nrpe.cfg for percona plugins ? plz
Hello,
Thanks,
It’s OK for me.
Hello, thank you for this tuto, I tried to install it but I have error messages.
Besides this command (check_mysql_service) does not exist.
my errors :
MySQL InnoDB Long Transaction
CRITICAL 07-23-2015 11:43:46 0d 1h 25m 25s 3/3 (Service check timed out after 60.09 seconds)