pcp
[Top] [All Lists]

PCP 3.6.9 and the mysql pmda

To: pcp@xxxxxxxxxxx
Subject: PCP 3.6.9 and the mysql pmda
From: Chandana De Silva <chandana@xxxxxxxxxxxxx>
Date: Thu, 01 Nov 2012 20:20:52 +1100
Reply-to: chandana@xxxxxxxxxxxxx
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20121011 Thunderbird/16.0.1
I have started installing PCP 3.6.9 on a set of CentOS 5.5 x86_64 servers. One issue I have found is that PCP does not get listed in chkconfig. Is this intentional (systemd related ?). If so how can we get that back into the older versions of RHEL/CentOS ?

The second issue is that I seem to have made an error in the mysql pmda. PCP now thinks this is a Gigabyte value.
pminfo -d -t mysql.slave_status.seconds_behind_master

mysql.slave_status.seconds_behind_master []
    Data Type: 32-bit unsigned int  InDom: PM_INDOM_NULL 0xffffffff
    Semantics: instant  Units: Gbyte

This came from:

$pmda->add_metric(pmda_pmid(3,3), PM_TYPE_U32, PM_INDOM_NULL,
                  PM_SEM_INSTANT, pmda_units(1,0,0,PM_TIME_SEC,0,0),
                  'mysql.slave_status.seconds_behind_master', '', '');

I think the above should be:

$pmda->add_metric(pmda_pmid(3,3), PM_TYPE_U32, PM_INDOM_NULL,
                  PM_SEM_INSTANT, pmda_units(0, 1, 0, 0, PM_TIME_SEC, 0),
                  'mysql.slave_status.seconds_behind_master', '', '');

Is this clearly explained somewhere ?. I am not sure if I am reading the correct document at http://techpubs.sgi.com/library/tpl/cgi-bin/getdoc.cgi?coll=0650&db=bks&srch=&fname=/SGI_Developer/PCP_PG/sgi_html/ch02.html#id5189820

Chandana

<Prev in Thread] Current Thread [Next in Thread>