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)

PMDASYSTEMTAP(1)					       Performance Co-Pilot						  PMDASYSTEMTAP(1)

NAME

       pmdasystemtap - Systemtap performance metrics domain agent (PMDA)

DESCRIPTION

       pmdasystemtap is a Performance Metrics Domain Agent (PMDA) which exports metric values from the Linux Systemtap dynamic tracing toolkit.

       This implementation uses the stap(1) tool, which is a front-end to the Systemtap toolkit.

INSTALLATION

       In order to access performance data exported by Systemtap from with PCP, it is necessary to perform two configuration steps:

       1.  Configure Systemtap probes, and verify them with stap(1).  These should be produced in a format that is easily parsed, and then stored
	   in the $PCP_PMDAS_DIR/systemtap/probes.stp file.

       2.  Configure pmdasystemtap to extract the values from the text produced by stap.  Two example probes are implemented in the default
	   systemtap PMDA script - readdir and sync traces (see $PCP_PMDAS_DIR/systemtap/pmdasystemtap.pl for details).

	       # cd $PCP_PMDAS_DIR/systemtap
	       # [ edit probes.stp, test /usr/bin/stap probes.stp ]
	       # [ edit pmdasystemtap.pl ]

       Once this is setup, you can access the names and values for the systemtap performance metrics by doing the following as root:

	       # cd $PCP_PMDAS_DIR/systemtap
	       # ./Install

       If you want to undo the installation, do the following as root:

	       # cd $PCP_PMDAS_DIR/systemtap
	       # ./Remove

       pmdasystemtap 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/systemtap/probes.stp
	   probe configuration file for stap(1), run by pmdasystemtap

       $PCP_PMDAS_DIR/systemtap/Install
	   installation script for the pmdasystemtap agent

       $PCP_PMDAS_DIR/systemtap/Remove
	   undo installation script for the pmdasystemtap agent

       $PCP_LOG_DIR/pmcd/systemtap.log
	   default log file for error messages from pmdasystemtap

SEE ALSO

       pmcd(1) and stap(1).

3.8.10							       Performance Co-Pilot						  PMDASYSTEMTAP(1)