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

Reference documentation for mysql Automation Operation and maintenance tool

Taobao open source tool: Orztop

View current processlist and full processlist in real time

A tool that can check the status of sql running in mysql database in real time. Comrades who used to suffer from crawling sql through show processlist/show full processlist now only need to stare at the screen, which is very convenient.

Installation and deployment:

1. Download: wget http://hidba.org/wp-content/uploads/2013/06/orztop.rar

Upload the downloaded files to the server

Chmod axix orztop

two。 Log in to the database to authorize orztop to detect users

Grant all on browser.* toorztopuser@'127.0.0.1' identified by 'oriTOpusertesT'

Flush privileges

3. Operation command:

. / orztop-hobbies 127.0.0.1-Pumb3306-upright orztopuserMustUsMustPay2

4. Missing DBI component error

[root@4 opt] #. / orztop-hobbies 127.0.0.1-Plut3306-ubiquitous rootMurray pageoriTOpusertesT'-tasking 2

Can't locate DBI.pm in @ INC (@ INC contains:/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. / orztopline 13.

BEGIN failed--compilation aborted at. / orztop line 13.

Cause of error: the system did not install DBI components by press.

DBI (Database Interface) is the interface for perl to connect to the database. It is the best way for perl to connect to databases, and it supports most databases, including Orcal,Sybase,mysql,db2.

Solution:

Install the DBI component. Can't locate DBI.pm in @ INC-mysql interface

Yum-y install perl-DBD-MySQL

5. Missing ReadKey component error

[root@4 opt] #. / orztop-hobbies 127.0.0.1-Plut3306-ubiquitous rootMurray pageoriTOpusertesT'-tasking 2

Can't locate Term/ReadKey.pm in @ INC (@ INC contains:/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. / orztopline 14.

BEGIN failed--compilation aborted at. / orztop line 14.

Solution:

Yum search ReadKey

Yum install perl-TermReadKey.x86_64-y

The test is normal:

. / orztop-hobbies 127.0.0.1-Pumb3306-upright orztopuserMustUsMustPay2

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.