All,
I am trying to monitor a MySQL slave using PCP. I have installed the
MySQL PMDA, and can see some values using pminfo -f mysql
The mysql.status.com_show_slave_statusseems to be a counter of some sort;
mysql.status.com_show_slave_status
Data Type: 32-bit unsigned int InDom: PM_INDOM_NULL 0xffffffff
Semantics: counter Units: count
What I am interested in seeing is this information below some form, as I
need to specifically monitor the 'seconds behind master' value from
pmie. Can someone help, please ?
Thanks
Chandana
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.7.172
Master_User: replicate
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-sol-bin.000001
Read_Master_Log_Pos: 3445937
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 2755529
Relay_Master_Log_File: mysql-sol-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 3445937
Relay_Log_Space: 2755529
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
1 row in set (0.00 sec)
|