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

NAME

6       pmdamysql - MySQL and MariaDB database PMDA
7

DESCRIPTION

9       pmdamysql  is  a  Performance Co-Pilot PMDA which extracts live perfor‐
10       mance data from a running MySQL or MariaDB 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,   default   is
23           "DBI:mysql:mysql")
24
25       •   database username (default is "dbmonitor")
26
27       •   database password (default is "dbmonitor")
28
29       •   login account (default is "pcp")
30
31       On some versions of MariaDB (10+) the performance schema is disabled by
32       default,  and  must  be  enabled  for  the  PMDA  to function.  This is
33       achieved by adding the string "performance_schema" into the  "[mysqld]"
34       section  of  the  MariaDB configuration file (either my.cnf or my.ini).
35       The "SHOW ENGINES" SQL statement  shows  support  for  the  performance
36       schema.
37
38       Once these initial setup actions are complete, you can access the names
39       and values for the mysql performance metrics by doing the following  as
40       root:
41
42           # cd $PCP_PMDAS_DIR/mysql
43           # ./Install
44
45       To uninstall, the following must be done as root:
46
47           # cd $PCP_PMDAS_DIR/mysql
48           # ./Remove
49
50       pmdamysql is launched by pmcd(1) and should never be executed directly.
51       The Install and Remove scripts notify pmcd(1) when  the  agent  is  in‐
52       stalled or removed.
53

Binary Status values in text

55       Some of the status values are in the form of YES/NO or ON/OFF.
56
57       Since these cannot be interpreted by tools like pmie(1), they have been
58       duplicated with a _num extension and the values  of  1  (YES/ON)  or  0
59       (NO/OFF).
60
61   Eg:
62       •   mysql.slave_status.slave_io_running
63
64       •   mysql.slave_status.slave_io_running_num
65

FILES

67       /etc/pcpdbi.conf
68           configuration file for all PCP database monitors
69
70       $PCP_PMDAS_DIR/mysql/mysql.conf
71           configuration file for pmdamysql
72
73       $PCP_PMDAS_DIR/mysql/Install
74           installation script for the pmdamysql agent
75
76       $PCP_PMDAS_DIR/mysql/Remove
77           undo installation script for the pmdamysql agent
78
79       $PCP_LOG_DIR/pmcd/mysql.log
80           default log file for error messages from pmdamysql
81

PCP ENVIRONMENT

83       Environment variables with the prefix PCP_ are used to parameterize the
84       file and directory names used by PCP. On each  installation,  the  file
85       /etc/pcp.conf  contains  the  local  values  for  these variables.  The
86       $PCP_CONF variable may be used to specify an alternative  configuration
87       file, as described in pcp.conf(5).
88

SEE ALSO

90       PCPIntro(1), pmcd(1), pmdadbping(1), pmie(1) and DBI(3).
91
92
93
94Performance Co-Pilot                  PCP                         PMDAMYSQL(1)
Impressum