How to monitor database IO and available database threads?

burak · 03-07-2011, 03:11 AM

Hello,
I am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as
"My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached. Any idea"

I got the following reply,

"database performance?

are you monitoring database IO and available database threads? "

So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.

centosboy · 03-08-2011, 03:20 AM

Quote:

Originally Posted by burak

Hello,
I am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as
"My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached. Any idea"

I got the following reply,

"database performance?

are you monitoring database IO and available database threads? "

So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.

Hmmmm...there is something on the zabbix wiki that explains how to do this??

Code:

http://www.zabbix.com/wiki/howto/monitor/db/mysql/extensive_mysql_monitoring_including_replication