1PMDADBPING(1) Performance Co-Pilot PMDADBPING(1)
2
3
4
6 pmdadbping - database response time and availability PMDA
7
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
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
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
66 pmcd(1), dbprobe.pl(1) and DBI(3).
67
68
69
703.3.3 Performance Co-Pilot PMDADBPING(1)