Shulou(Shulou.com)06/01 Report--

Installation of orzdba

Can only be run on the local server because tcprstat is used to collect information

Source code address

Http://code.taobao.org/svn/orzdba/trunk/

# chmod + x orzdba

Installation and use of tcprstat tools

How to use it:

Tcprstat is installed on the server side to analyze the response time of local Nic address requests. It can be used for temporary analysis or scheduled tasks to collect information.

download

# wget-c https://github.com/Lowercases/tcprstat/archive/v0.3.1.tar.gz

# cp tcprstat-static.v0.3.1.x86_64 tcprstat

# chmod axix tcprstat

# mv tcprstat / usr/bin/

Perl dependency packages that need to be installed:

Yum install perl-Test-Simple

Yum install perl-Time-HiRes

Yum install perl-ExtUtils-CBuilder

Yum install perl-ExtUtils-MakeMaker

Yum install perl-DBD-MySQL

Yum install perl-DBI

Yum install perl-Module-Build-XSUtil

Yum install perl-Class-Data-Inheritable.noarch

Yum install perl-Module-Signature

Yum install perl-Archive-Tar

Yum install perl-Pod-Readme

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.gz

Tar-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

#. / orzdba-lazy-rt-S / u01/my3306/run/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.

. / orzdba-innodb-S / u01/my3306/run/mysql.sock

Remote orzdba:. / orzdba_remote-- host=xxx.xxx.xxx.xxx-- user=xx-- port=3306-mysql-sys

Download address: http://down.51cto.com/data/2366812

Parameters:

-mysql checks the number of threads in run. Exceeding the number of cpu indicates that the system is busy. Several times my server passed 1000 and the server did not respond. In the final check, many queries take up cpu, resulting in a large number of insert waits and blocking other operations such as delete/update. When the solution is to migrate these query services to read-only libraries, you only need to focus on the delay.

-innodb

-lazy

-under the remote command of sys, it seems that sys is not allowed.

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.