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  or‐
20       der):
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, the following must be done as root:
46
47           # cd $PCP_PMDAS_DIR/dbping
48           # ./Remove
49
50       pmdadbping  is  launched  by  pmcd(1)  and should never be executed di‐
51       rectly. The Install and Remove scripts notify pmcd(1) when the agent is
52       installed or removed.
53

FILES

55       $PCP_PMDAS_DIR/dbping/dbprobe.conf
56           probe  configuration  file  for  dbprobe(1), used indirectly by pm‐
57           dadbping
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       PCPIntro(1), pmcd(1), dbprobe(1) and DBI(3).
77
78
79
80Performance Co-Pilot                  PCP                        PMDADBPING(1)
Impressum