MySQL monitoring tool-orzdba

MySQL monitoring tool-orzdba

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

[Root @ bkjia servers] # chmod + x orzdba

Configure your MySQL verification information in line 1 of the Code: username, password, socket, host, port
[Root @ bkjia 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
[Root @ bkjia servers] # ln-sf/export/servers/tcprstat-static.v0.3.1.x86_64/usr/bin/tcprstat
[Root @ bkjia servers] # chmod u + s/usr/bin/tcprstat

Perl dependency package 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

Installation Error: (because the "yum install perl-Test-Simple.x86_64" is missing ")
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 512, 0x200)
No subtests run


Install the File: LockFfile module of Perl
Install 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 versions-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

Install the Class-Data-Inheritable module:
Wget http://search.cpan.org/CPAN/authors/id/T/TM/TMTM/Class-Data-Inheritable-0.08.tar.gztar-zxvf Class-Data-Inheritable-0.08.tar.gz.
Cd Class-Data-Inheritable-0.08
Perl Makefile. PL
Make
Make test
Make install

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


Prompt after installation: Usage: Socket: inet_ntoa (ip_address_sv) at./orz line 477
Because the host name cannot be resolved, write the IP address and host name to the/etc/hosts file.
[Root @ bkjia servers] # vi/etc/hosts
172.16.9.242 bkjia.com

[Root @ bkjia servers] #./orzdba-lazy-rt-S/export/data/mysql/tmp/mysql. sock

Count: Number of requests completed during this interval
Avg: average response time for all completed requests within this interval
95_avg: average response time of 95% of requests within this interval, in microseconds. This value can reflect the average response time of MySQL Server queries.


[Root @ bkjia servers] #./orzdba-innodb-S/export/data/mysql/tmp/mysql. sock

This article permanently updates the link address: