pmdamysql(1) [centos man page]
PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1) NAME
pmdamysql - MySQL database PMDA DESCRIPTION
pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database. INSTALLATION
pmdamysql uses a configuration file from (in this order): o /etc/pcpdbi.conf o $PCP_PMDAS_DIR/mysql/mysql.conf This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely: o database name (see DBI(3) for details) o database user name o database pass word Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root: # cd $PCP_PMDAS_DIR/mysql # ./Install If you want to undo the installation, do the following as root: # cd $PCP_PMDAS_DIR/mysql # ./Remove pmdamysql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is installed or removed. Binary Status values in text Some of the status values are in the form of YES/NO or ON/OFF. Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0 (NO/OFF). Eg: o mysql.slave_status.slave_io_running o mysql.slave_status.slave_io_running_num FILES
/etc/pcpdbi.conf configuration file for all PCP database monitors $PCP_PMDAS_DIR/mysql/mysql.conf configuration file for pmdamysql $PCP_PMDAS_DIR/mysql/Install installation script for the pmdamysql agent $PCP_PMDAS_DIR/mysql/Remove undo installation script for the pmdamysql agent $PCP_LOG_DIR/pmcd/mysql.log default log file for error messages from pmdamysql SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3). # vi: sw=4 ts=4 et: 3.8.10 Performance Co-Pilot PMDAMYSQL(1)
Check Out this Related Man Page
PMDAMEMCACHE(1) Performance Co-Pilot PMDAMEMCACHE(1) NAME
pmdamemcache - memcache performance metrics domain agent (PMDA) DESCRIPTION
This PMDA extracts performance data from memcached, a distributed memory caching daemon commonly used to improve web serving performance. A farm of memcached processes over multiple servers can be utilised by a single web application, increasing the total available object cache size, and decreasing the database load associated with smaller cache sizes. This system is described in detail at http://www.danga.com/memcached. INSTALLATION
Configure pmdamemcache to extract the values from set of hosts used in the memcache farm. These hosts can be listed in the $PCP_PMDAS_DIR/memcache/memcache.conf file, in the format (i.e. Perl array) described at the top of pmdamemcache.pl. A custom refresh rate can also be configured using this mechanism. # cd $PCP_PMDAS_DIR/memcache # [ edit memcache.conf ] Once this is setup, you can access the names and values for the memcache performance metrics by doing the following as root: # cd $PCP_PMDAS_DIR/memcache # ./Install If you want to undo the installation, do the following as root: # cd $PCP_PMDAS_DIR/memcache # ./Remove pmdamemcache is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is installed or removed. FILES
$PCP_PMDAS_DIR/memcache/memcache.conf configuration file listing monitored memcache instances $PCP_PMDAS_DIR/memcache/Install installation script for the pmdamemcache agent $PCP_PMDAS_DIR/memcache/Remove undo installation script for the pmdamemcache agent $PCP_LOG_DIR/pmcd/memcache.log default log file for error messages from pmdamemcache SEE ALSO
pmcd(1) and memcached(1). 3.8.10 Performance Co-Pilot PMDAMEMCACHE(1)