pmdamysql(1) - Linux man page

Name

pmdamysql - MySQL database PMDA

pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.

pmdamysql uses a configuration file from (in this order):

• /etc/pcpdbi.conf • $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:
• database name (see DBI (3) for details) • database user name • 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.

/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