MySQL monitoring tool-ORZDBA

Source code address: http://code.taobao.org/p/orzdba/src/trunk/

[Email protected] servers]# chmod +x orzdba

Configure your MySQL authentication information in about 160 lines of code: username, password, socket, host, port
[Email protected] servers]# grep-n ' My $MYSQL ' orzdba
160:my $MYSQL = Qq{mysql-s--skip-column-names-uroot-pyoon-h127.0.0.1-p$port};

Install Tcprstat First
[Email protected] servers]# Ln-sf/export/servers/tcprstat-static.v0.3.1.x86_64/usr/bin/tcprstat
[[email protected] servers] #chmod U+s/usr/bin/tcprstat

Perl dependency packages that need to be installed:
Yum Install perl-test-simple.x86_64
Yum Install Perl-time-hires
Yum Install Perl-extutils-cbuilder
Yum Install Perl-extutils-makemaker
Yum Install Perl-dbd-mysql
Yum Install PERL-DBI

Error in Installation: (due to lack of "yum install perl-test-simple.x86_64")
T/02derived.t ..... Can ' t locate test/more.pm in @INC (@INC contains:/export/servers/perl_module/version-0.99/blib/lib/export/servers/ Perl_module/version-0.99/blib/arch/usr/local/lib64/perl5/usr/local/share/perl5/usr/lib64/perl5/vendor_perl/usr /share/perl5/vendor_perl/usr/lib64/perl5/usr/share/perl5.) At T/02DERIVED.T Line 7.
BEGIN failed--compilation aborted at t/02derived.t Line 7.
T/02derived.t ..... Dubious, Test returned 2 (Wstat, 0x200)
No subtests Run


installing Perl's File:lockffile module
Installing the Version module
wget http://search.cpan.org/CPAN/authors/id/J/JP/JPEACOCK/version-0.99.tar.gz
TAR-ZXVF version-0.99.tar.gz
CD version-0.99
Perl makefile.pl
Make
Make Test
Make install

Install and install the File::lockfile module:
wget http://search.cpan.org/CPAN/authors/id/G/GL/GLORYBOX/File-Lockfile-v1.0.5.tar.gz
TAR-ZXVF file-lockfile-v1.0.5.tar.gz
CD file-lockfile-v1.0.5
Perl build.pl
Perl./build
Perl./build Test
Perl./build Install

To Install the Class-data-inheritable module:
wget http://search.cpan.org/CPAN/authors/id/T/TM/TMTM/Class-Data-Inheritable-0.08.tar.gz TAR-ZXVF class-data-inheritable-0.08.tar.gz
CD class-data-inheritable-0.08
Perl makefile.pl
Make
Make Test
Make install

To Install the Module-build module:
wget http://search.cpan.org/CPAN/authors/id/K/KW/KWILLIAMS/Module-Build-0.31.tar.gz
TAR-ZXVF module-build-0.31.tar.gz
CD module-build-0.31
Perl build.pl
./build
./build Test
./build Install


after installing the prompt: Usage:socket::inet_ntoa (IP_ADDRESS_SV) at./orz Line 477
The IP and hostname are written to the/etc/hosts file because the host name cannot be resolved
[Email protected] servers]# vi/etc/hosts
172.16.9.242 hank-yoon.com

[Email protected] servers]#/orzdba-lazy-rt-s/export/data/mysql/tmp/mysql.sock

Count: Number of requests completed within this interval
Avg: The average time of the response for all completed requests within this interval
95_AVG: The average response time for 95% of requests in this interval, in microseconds, which is more than the average response time for MySQL server queries


[Email protected] servers]#/orzdba-innodb-s/export/data/mysql/tmp/mysql.sock

MySQL monitoring tool-ORZDBA