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

NAME

6       pmdamysql - MySQL database PMDA
7

DESCRIPTION

9       pmdamysql  is  a  Performance Co-Pilot PMDA which extracts live perfor‐
10       mance data from a running MySQL database.
11

INSTALLATION

13       pmdamysql uses a configuration file from (in this order):
14
15       ·   /etc/pcpdbi.conf
16
17       ·   $PCP_PMDAS_DIR/mysql/mysql.conf
18
19       This file can contain overridden values (Perl code)  for  the  settings
20       listed at the start of pmdamysql.pl, namely:
21
22       ·   database name (see DBI(3) for details)
23
24       ·   database username
25
26       Once  this  is setup, you can access the names and values for the mysql
27       performance metrics by doing the following as root:
28
29             # cd $PCP_PMDAS_DIR/mysql
30             # ./Install
31
32       To uninstall, do the following as root:
33
34             # cd $PCP_PMDAS_DIR/mysql
35             # ./Remove
36
37       pmdamysql is launched by pmcd(1) and should never be executed directly.
38       The  Install  and  Remove  scripts  notify  pmcd(1)  when  the agent is
39       installed or removed.
40

Binary Status values in text

42       Some of the status values are in the form of YES/NO or ON/OFF.
43
44       Since these cannot be intepreted by tools like pmie(1), they have  been
45       duplicated  with  a  _num  extension  and the values of 1 (YES/ON) or 0
46       (NO/OFF).
47
48   Eg:
49       ·   mysql.slave_status.slave_io_running
50
51       ·   mysql.slave_status.slave_io_running_num
52

FILES

54       /etc/pcpdbi.conf
55           configuration file for all PCP database monitors
56
57       $PCP_PMDAS_DIR/mysql/mysql.conf
58           configuration file for pmdamysql
59
60       $PCP_PMDAS_DIR/mysql/Install
61           installation script for the pmdamysql agent
62
63       $PCP_PMDAS_DIR/mysql/Remove
64           undo installation script for the pmdamysql agent
65
66       $PCP_LOG_DIR/pmcd/mysql.log
67           default log file for error messages from pmdamysql
68

PCP ENVIRONMENT

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

SEE ALSO

77       PCPIntro(1), pmcd(1), pmdadbping(1), pmie(1) and DBI(3).
78
79
80
81Performance Co-Pilot                  PCP                         PMDAMYSQL(1)
Impressum