Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

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

PMDATRIVIAL(1)						      General Commands Manual						    PMDATRIVIAL(1)

NAME
pmdatrivial - trivial performance metrics domain agent (PMDA) SYNOPSIS
$PCP_PMDAS_DIR/trivial/pmdatrivial [-d domain] [-l logfile] [-U username] DESCRIPTION
pmdatrivial is the simplest possible Performance Metrics Domain Agent (PMDA) which exports a single performance metric, the time in seconds since the 1st of January, 1970. The trivial PMDA is shipped as source code and is designed to be an aid for PMDA developers. A brief description of the pmdatrivial command line options follows: -d It is absolutely crucial that the performance metrics domain number specified here is unique and consistent. That is, domain should be different for every PMDA on the one host, and the same domain number should be used for the same PMDA on all hosts. -l Location of the log file. By default, a log file named trivial.log is written in the current directory of pmcd(1) when pmdatrivial is started, i.e. $PCP_LOG_DIR/pmcd. If the log file cannot be created or is not writable, output is written to the standard error instead. -U User account under which to run the agent. The default is the unprivileged "pcp" account in current versions of PCP, but in older versions the superuser account ("root") was used by default. INSTALLATION
If you want access to the names, help text and values for the trivial performance metrics, do the following as root: # cd $PCP_PMDAS_DIR/trivial # ./Install If you want to undo the installation, do the following as root: # cd $PCP_PMDAS_DIR/trivial # ./Remove pmdatrivial 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_PMCDCONF_PATH command line options used to launch pmdatrivial $PCP_PMDAS_DIR/trivial/help default help text file for the trivial metrics $PCP_PMDAS_DIR/trivial/Install installation script for the pmdatrivial agent $PCP_PMDAS_DIR/trivial/Remove undo installation script for the pmdatrivial agent $PCP_LOG_DIR/pmcd/trivial.log default log file for error messages and other information from pmdatrivial PCP ENVIRONMENT
Environment variables with the prefix PCP_ are used to parameterize the file and directory names used by PCP. On each installation, the file /etc/pcp.conf contains the local values for these variables. The $PCP_CONF variable may be used to specify an alternative configura- tion file, as described in pcp.conf(5). SEE ALSO
PCPIntro(1), pmcd(1), pmdasample(1), pmdasimple(1), pmdatxmon(1) and PMDA(3). Performance Co-Pilot PCP PMDATRIVIAL(1)
Man Page