1PMDADBPING(1)               General Commands Manual              PMDADBPING(1)
2
3
4

NAME

6       pmdadbping - database response time and availability PMDA
7

DESCRIPTION

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

INSTALLATION

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

FILES

55       $PCP_PMDAS_DIR/dbping/dbprobe.conf
56           probe   configuration  file  for  dbprobe(1),  used  indirectly  by
57           pmdadbping
58
59       $PCP_PMDAS_DIR/dbping/Install
60           installation script for the pmdadbping agent
61
62       $PCP_PMDAS_DIR/dbping/Remove
63           undo installation script for the pmdadbping agent
64
65       $PCP_LOG_DIR/pmcd/dbping.log
66           default log file for error messages from pmdadbping
67

PCP ENVIRONMENT

69       Environment variables with the prefix PCP_ are used to parameterize the
70       file  and  directory  names used by PCP. On each installation, the file
71       /etc/pcp.conf contains the  local  values  for  these  variables.   The
72       $PCP_CONF  variable may be used to specify an alternative configuration
73       file, as described in pcp.conf(5).
74

SEE ALSO

76       dbprobe(1) pmcd(1), PCPIntro(1) and DBI(3).
77
78
79
80Performance Co-Pilot                  PCP                        PMDADBPING(1)
Impressum