1PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1)
2
3
4
6 pmdamysql - MySQL database PMDA
7
9 pmdamysql is a Performance Co-Pilot PMDA which extracts live
10 performance 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 user name
25
26 · database pass word
27
28 Once this is setup, you can access the names and values for the mysql
29 performance metrics by doing the following as root:
30
31 # cd $PCP_PMDAS_DIR/mysql
32 # ./Install
33
34 If you want to undo the installation, do the following as root:
35
36 # cd $PCP_PMDAS_DIR/mysql
37 # ./Remove
38
39 pmdamysql is launched by pmcd(1) and should never be executed directly.
40 The Install and Remove scripts notify pmcd(1) when the agent is
41 installed or removed.
42
44 /etc/pcpdbi.conf
45 configuration file for all PCP database monitors
46
47 $PCP_PMDAS_DIR/mysql/mysql.conf
48 configuration file for pmdamysql
49
50 $PCP_PMDAS_DIR/mysql/Install
51 installation script for the pmdamysql agent
52
53 $PCP_PMDAS_DIR/mysql/Remove
54 undo installation script for the pmdamysql agent
55
56 $PCP_LOG_DIR/pmcd/mysql.log
57 default log file for error messages from pmdamysql
58
60 pmcd(1), pmdadbping.pl(1) and DBI(3).
61
62
63
643.3.3 Performance Co-Pilot PMDAMYSQL(1)