Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

CentOS 7.0 - man page for pmdadbping (centos section 1)

PMDADBPING(1)						       Performance Co-Pilot						     PMDADBPING(1)

NAME
pmdadbping - database response time and availability PMDA
DESCRIPTION
Simple database response time measurement PMDA. dbprobe.pl(1) should be configured to use the type of DBI appropriate for your database, which includes: RDBMS flavour, user/password, delay between "ping" requests, and the SQL statement to use. pmdadbping runs dbprobe.pl(1), and exports the performance measurements it makes available as PCP metrics.
INSTALLATION
Configure dbprobe.pl(1) - it uses a configuration file from (in this order): o /etc/pcpdbi.conf o $PCP_PMDAS_DIR/dbping/dbprobe.conf This file can contain overridden values (Perl code) for the settings listed at the start of dbprobe.pl, namely: o database name (see DBI(3) for details) o database user name o database pass word o SQL statement to measure (probe) o delay between probes Once this is setup, you can access the names and values for the dbping performance metrics by doing the following as root: # cd $PCP_PMDAS_DIR/dbping # ./Install If you want to undo the installation, do the following as root: # cd $PCP_PMDAS_DIR/dbping # ./Remove pmdadbping 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/dbping/probes.stp probe configuration file for stap(1), run by pmdadbping $PCP_PMDAS_DIR/dbping/Install installation script for the pmdadbping agent $PCP_PMDAS_DIR/dbping/Remove undo installation script for the pmdadbping agent $PCP_LOG_DIR/pmcd/dbping.log default log file for error messages from pmdadbping
SEE ALSO
pmcd(1), dbprobe.pl(1) and DBI(3). 3.8.10 Performance Co-Pilot PMDADBPING(1)