PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1)NAMEpmdamysql - MySQL database PMDA
DESCRIPTIONpmdamysql is a Performance Co-Pilot PMDA which extracts live
performance data from a running MySQL database.
INSTALLATIONpmdamysql 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.
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 pmdamysqlSEE ALSOpmcd(1), pmdadbping.pl(1) and DBI(3).
3.6.10 Performance Co-Pilot PMDAMYSQL(1)