LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   How to monitor database IO and available database threads? (https://www.linuxquestions.org/questions/linux-general-1/how-to-monitor-database-io-and-available-database-threads-866903/)

burak 03-07-2011 03:11 AM
How to monitor database IO and available database threads?
 
1 Attachment(s)
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 (Post 4281263)
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


All times are GMT -5. The time now is 05:02 AM.