Monitoring MySQL...

[Vanyuan]

Hi,

I need to monitor MySQL. What I've done thus far is to enable the UserParameter(s) in the agent config file. (zabbix_agentd -t ... tested, and working.) I have also created items for these: "mysql[ping]" as well as "mysql[uptime]".

Triggers created for two mysql hosts as well to test. The problem is that no data is being sent back to the zabbix server for these triggers.

Am I going in the right direction, or is something being missed. I had a look at the cookbook, and there is no mention of creating items or triggers in there.

The standard PDF document (p131) contains the same info as the cookbook.

V.

[Macsimus]

Try changing your items to "mysql.ping" and "mysql.uptime" (e.g., no brackets and add a period in between).

I had a similar problem, and it appears to be a mismatch between the items and their entries in the agent config file. When I look at my agents' supported metrics with "zabbix_agentd -p", the MySQL items are delimited by periods, not brackets.

Hope that helps.

[Vanyuan]

mysql.ping "information type"?

Hi there,

Thanks for the reply Macsimus. I gave it a try, but no luck. What "Type of Information" (Item configuration) is a mysql.ping check?

Numeric (float) ?

V.

[Vanyuan]

mysql.ping working now ...

Macsimus, thank you, it was indeed the item brackets that stuffed me around.

Server now sending back data. On another server Zabbix could not find the "mysqladmin" binary as the mysql-client package(rpm) was not installed.

Therefor, in addition to Macsimus' comment on brackets, ensure that the mysql-client package is installed on your server, then...

Uncomment the UserParameter=mysql.ping... in the zabbix agent config file.

Create an item for mysql.ping (and other if more.)

Create a trigger for item mysql.ping.

(P.S - My item type is Numeric (integer 64bit). Is there a quick way in which one can determine what "Type of Information" is the correct one to choose when creating a new item?.)

V.

[Macsimus]

If you do a "zabbix_agentd -p" on your monitored server(s), you should get a list of all the metrics and their current states. If what you want to monitor has a number with a decimal point, use the float. Otherwise, use integer.

I'm sure you can get away with using integer with items that are normally float. They'd probably just round off or something similar. It really depends on how picky you are.

[AdrianW]

Issue still in 1.4 - fixed with this information.

Macsimus and Vanyuan, thank you. This thread helped me to resolve problems with the 1.4 release.

For documentation purposes and future reference for others, I changed the following items within the Template_App_MySQL included with the 1.4 release:

"MySQL is alive"	mysql[ping]
"MySQL number of slow queries"	mysql[slowqueries]
"MySQL number of threads"	mysql[threads]
"MySQL queries per second"	mysql[qps]
"MySQL uptime"	mysql[uptime]
"MySQL version"	version[mysql]

To these settings:

"MySQL is alive"	mysql.ping
"MySQL number of slow queries"	mysql.slowqueries
"MySQL number of threads"	mysql.threads
"MySQL queries per second"	mysql.qps
"MySQL uptime"	mysql.uptime
"MySQL version"	mysql.version

With these changes, the 1.4 release properly works with the provided sample misc/conf/zabbix_agentd.conf file (included with 1.4). Of course the MySQL part of this file must be uncommented, the mysql-client package installed (as Vanyuan noted), a valid user account must be setup with MySQL and the password (if used) must added/update in the MySQL lines of the zabbix_agentd.conf file.

This thread has been added to the 1.4 reported bugs page on the Zabbix wiki http://www.zabbix.com/wiki/doku.php?id=bugs:1.4.x. (Hopefully it is OK to do this. )

-Adrian