mySQL monitoring HowTo Zabbix 2.0

[borgo]

Test ok but no data collected

Test on client and server are ok.
I have imported the xml template, and configured the host by gui
But Zabbix server doesn't collect data. I use the 2.0.8 version

For test I use:
zabbix_get -s 192.168.1.225 -p 10050 -k mysql.Connections
and returns a number

Should I edit zabbix_server.conf ?

Any help ?

Thank you in advance

Regards

Andrea

[dayron]

This is a howto for mysql monitoring with zabbix 2.0

To Test
You can do things like
(on agent)
zabbix_agentd -t mysql.Sort_scan

(on server)
zabbix_get -s agentip -k mysql.Sort_scan.

Im a new kid on the zabbix block so forgive me if I've missed something simple.

I have Zabbix server up and running and followed the instrcutions given in this thread. However, when I run the command listed under (on server) section using my agent IP and I get the following:

-bash: zabbix_get: command not found

I've done recursive searches for zabbix_get and also any files\folders that have zabbix in the name and I still cannot find "zabbix_get" anywhere.

Where is zabbix_get typically located?
CENTOS 6.4
Zabbix 2.0.9

[dayron]

All MySQL items "Not Supported"

I installed the MySQL template. For a shor time all the MySQL items were green when I enabled them.

However after a short time they all changed to "Not supported" with the error of:

"Received value [] is not suitable for value type [Numeric (float)]"


Please advise.

[Joby]

Item not working.

This is a howto for mysql monitoring with zabbix 2.0




I've attached a zip file that has:
-php script that goes on the mysql server you want to monitor (it is the latest version ATM - and you can always grab it from the percona mysql monitoring plugin toolkit in the "scripts" folder")

-zabbix user parameters file for use on the agent to grab all the values from the mysql server via the script above


I've also attached an XML file to import to the zabbix server that will create the template. I generated it as per the instructions on the link I provided at the beginning but I needed to add <delay_flex></delay_flex> to each item for zabbix succesfully import the template. I also erased all the triggers due to import problems.

________________________________

Instructions

On the Server
-Import the XML File template

On the Agent
you can refer to the instructions from the link above:



To Test
You can do things like
(on agent)
zabbix_agentd -t mysql.Sort_scan

(on server)
zabbix_get -s agentip -k mysql.Sort_scan

To ensure you get output.

Add the template to a host. I actually cloned the linux template (removed the mysql process counter and LINKED the mysql template to it) .

I hope this helps.

I am using this template for monitoring one of our MySQL server, everything works fine, but Key_reads value is shown as not supported by zabbix. The exact error is "Received value [] is not suitable for value type [Numeric (float)]" . Can any one help to solve this.