swrd / check-mysql-all

Automatically exported from code.google.com/p/check-mysql-all
0 stars 0 forks source link

Number of connections always always returns 1. #17

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. One server running nagios and another running mysqld_multi.
2. Run ./check_mysql_all looking for the connections count on mysql server.

What is the expected output? 
The number of Max_used_connectinos:

mysql> show status like 'Max_used_connections';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Max_used_connections | 38    |
+----------------------+-------+
1 row in set (0.00 sec)

What do you see instead?
The result of check_mysql_all is always "1":
[root@pvmonitora1 check-mysql-all]# ./check_mysql_all -K connections -H 
popmysql1 -u nagios -p nagios -w 75 -c 85 --socket=/var/lib/mysql/mysql1.sock
OK: 1/500 (0%) connections are used|connections=1;375;425;0;500

What version of the product are you using? On what operating system?
Downloaded check-mysql-all-0.1.2.tar.gz
Nagios server: CentOS 5.7
Mysql server: CentOS 5.8 + Mysql 5.5.23

Please provide any additional information below.
Right now, I'm running directly from bash and then I'll put in Nagios 
configuration.

Thank you.

Original issue reported on code.google.com by bran...@gmail.com on 4 May 2012 at 6:33