Shulou(Shulou.com)05/31 Report--

This article is about how to use orzdba, a MySQL monitoring tool. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

[root@hank-yoon servers] # chmod + x orzdba

Configure your own MySQL verification information in about 160 lines of code: username, password, socket, host, port

[root@hank-yoon servers] # grep-n'my $MYSQL' orzdba

160:my $MYSQL = qq {mysql-s-- skip-column-names-uroot-pyoon-h227.0.0.1-P$port}

Install tcprstat first

[root@hank-yoon servers] # ln-sf / export/servers/tcprstat-static.v0.3.1.x86_64 / usr/bin/tcprstat

[root@hank-yoon servers] # chmod Utility / 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 reported in installation: (due to missing "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 512, 0x200)

No subtests run

Install the File:LockFfile module for 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 version-0.99

Perl Makefile.PL

Make

Make test

Make install

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

Installation Tip: Usage: Socket::inet_ntoa (ip_address_sv) at. / orz line 477

Write IP and hostname to / etc/hosts file because the hostname cannot be resolved

[root@hank-yoon servers] # vi / etc/hosts

172.16.9.242 hank-yoon.com

[root@hank-yoon servers] #. / orzdba-lazy-rt-S / export/data/mysql/tmp/mysql.sock

Count: the number of requests completed in this interval

Avg: the average response time of all completed requests in this interval

95_avg: the average response time (in microseconds) of 95% of the requests in this interval. This value can better reflect the average response time of MySQL Server queries.

[root@hank-yoon servers] #. / orzdba-innodb-S / export/data/mysql/tmp/mysql.sock

Thank you for reading! This is the end of the article on "how to use orzdba, a MySQL monitoring tool". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.