1PMDAMYSQL(1) General Commands Manual PMDAMYSQL(1)
2
3
4
6 pmdamysql - MySQL database PMDA
7
9 pmdamysql is a Performance Co-Pilot PMDA which extracts live perfor‐
10 mance data from a running MySQL database.
11
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
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
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
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
77 PCPIntro(1), pmcd(1), pmdadbping(1), pmie(1) and DBI(3).
78
79
80
81Performance Co-Pilot PCP PMDAMYSQL(1)