Unix and Linux Discussions Tagged with amp |
|
Thread / Thread Starter |
Last Post |
Replies |
Views |
Forum |
|
|
|
1 |
10,123 |
UNIX for Beginners Questions & Answers |
|
|
|
1 |
3,773 |
UNIX for Beginners Questions & Answers |
|
|
|
6 |
3,754 |
UNIX for Beginners Questions & Answers |
|
|
|
2 |
10,890 |
UNIX for Beginners Questions & Answers |
|
|
|
1 |
2,926 |
UNIX for Beginners Questions & Answers |
|
|
|
2 |
2,961 |
UNIX for Beginners Questions & Answers |
|
|
|
8 |
41,567 |
Solaris |
|
|
|
5 |
2,826 |
UNIX for Beginners Questions & Answers |
|
|
|
0 |
1,256 |
What is on Your Mind? |
|
|
|
33 |
34,912 |
Solaris |
|
|
|
2 |
3,649 |
Solaris |
|
|
|
2 |
3,544 |
IP Networking |
|
|
|
2 |
3,112 |
AIX |
|
|
|
0 |
1,890 |
Software Releases - RSS News |
|
|
|
2 |
7,538 |
Solaris |
|
|
|
2 |
2,171 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
3,034 |
Programming |
|
|
|
0 |
2,350 |
OS X Support RSS |
|
|
|
1 |
29,302 |
Shell Programming and Scripting |
|
|
|
0 |
1,977 |
Solaris BigAdmin RSS |
|
|
|
7 |
12,326 |
Ubuntu |
|
|
|
0 |
1,341 |
Complex Event Processing RSS News |
|
|
|
0 |
1,884 |
Cartoons for Geeks |
|
|
|
0 |
1,271 |
Software Releases - RSS News |
|
|
|
6 |
4,732 |
UNIX for Dummies Questions & Answers |
|
|
|
1 |
1,497 |
UNIX for Dummies Questions & Answers |
|
|
|
0 |
2,430 |
Cartoons for Geeks |
|
|
|
0 |
1,759 |
Complex Event Processing RSS News |
|
|
|
0 |
2,381 |
Cartoons for Geeks |
|
|
|
0 |
3,085 |
HP Server News and Podcasts RSS |
|
|
|
0 |
1,669 |
MySQL DevZone RSS |
|
|
|
5 |
6,426 |
UNIX for Advanced & Expert Users |
|
|
|
0 |
1,698 |
Complex Event Processing RSS News |
|
|
|
3 |
5,804 |
UNIX and Linux Applications |
|
|
|
6 |
10,006 |
Solaris |
|
|
|
0 |
2,307 |
Cartoons for Geeks |
|
|
|
0 |
1,790 |
Cartoons for Geeks |
|
|
|
2 |
5,075 |
OS X (Apple) |
|
|
|
3 |
2,210 |
Shell Programming and Scripting |
|
|
|
0 |
1,045 |
Software Releases - RSS News |
PMDAMYSQL(1) Performance Co-Pilot PMDAMYSQL(1)
NAME
pmdamysql - MySQL database PMDA
DESCRIPTION
pmdamysql is a Performance Co-Pilot PMDA which extracts live performance data from a running MySQL database.
INSTALLATION
pmdamysql uses a configuration file from (in this order):
o /etc/pcpdbi.conf
o $PCP_PMDAS_DIR/mysql/mysql.conf
This file can contain overridden values (Perl code) for the settings listed at the start of pmdamysql.pl, namely:
o database name (see DBI(3) for details)
o database user name
o database pass word
Once this is setup, you can access the names and values for the mysql performance metrics by doing the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Install
If you want to undo the installation, do the following as root:
# cd $PCP_PMDAS_DIR/mysql
# ./Remove
pmdamysql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is
installed or removed.
Binary Status values in text
Some of the status values are in the form of YES/NO or ON/OFF.
Since these cannot be intepreted by tools like PMIE, they have been duplicated with a _num extension and the values of 1 (YES/ON) or 0
(NO/OFF).
Eg:
o mysql.slave_status.slave_io_running
o mysql.slave_status.slave_io_running_num
FILES
/etc/pcpdbi.conf
configuration file for all PCP database monitors
$PCP_PMDAS_DIR/mysql/mysql.conf
configuration file for pmdamysql
$PCP_PMDAS_DIR/mysql/Install
installation script for the pmdamysql agent
$PCP_PMDAS_DIR/mysql/Remove
undo installation script for the pmdamysql agent
$PCP_LOG_DIR/pmcd/mysql.log
default log file for error messages from pmdamysql
SEE ALSO
pmcd(1), pmdadbping.pl(1) and DBI(3). # vi: sw=4 ts=4 et:
3.8.10 Performance Co-Pilot PMDAMYSQL(1)