1PMDADBPING(1)                Performance Co-Pilot                PMDADBPING(1)
2
3
4

NAME

6       pmdadbping - database response time and availability PMDA
7

DESCRIPTION

9       Simple database response time measurement PMDA.  dbprobe.pl(1) should
10       be configured to use the type of DBI appropriate for your database,
11       which includes: RDBMS flavour, user/password, delay between "ping"
12       requests, and the SQL statement to use.  pmdadbping runs dbprobe.pl(1),
13       and exports the performance measurements it makes available as PCP
14       metrics.
15

INSTALLATION

17       Configure dbprobe.pl(1) - it uses a configuration file from (in this
18       order):
19
20       ·   /etc/pcpdbi.conf
21
22       ·   $PCP_PMDAS_DIR/dbping/dbprobe.conf
23
24       This file can contain overridden values (Perl code) for the settings
25       listed at the start of dbprobe.pl, namely:
26
27       ·   database name (see DBI(3) for details)
28
29       ·   database user name
30
31       ·   database pass word
32
33       ·   SQL statement to measure (probe)
34
35       ·   delay between probes
36
37       Once this is setup, you can access the names and values for the dbping
38       performance metrics by doing the following as root:
39
40               # cd $PCP_PMDAS_DIR/dbping
41               # ./Install
42
43       If you want to undo the installation, do the following as root:
44
45               # cd $PCP_PMDAS_DIR/dbping
46               # ./Remove
47
48       pmdadbping is launched by pmcd(1) and should never be executed
49       directly.  The Install and Remove scripts notify pmcd(1) when the agent
50       is installed or removed.
51

FILES

53       $PCP_PMDAS_DIR/dbping/probes.stp
54           probe configuration file for stap(1), run by pmdadbping
55
56       $PCP_PMDAS_DIR/dbping/Install
57           installation script for the pmdadbping agent
58
59       $PCP_PMDAS_DIR/dbping/Remove
60           undo installation script for the pmdadbping agent
61
62       $PCP_LOG_DIR/pmcd/dbping.log
63           default log file for error messages from pmdadbping
64

SEE ALSO

66       pmcd(1), dbprobe.pl(1) and DBI(3).
67
68
69
703.3.3                        Performance Co-Pilot                PMDADBPING(1)
Impressum