Install ORZDBA First, Link:
http://blog.itpub.net/28939273/viewspace-1875895/
To install a dependent package:
[email protected] servers]# Yum install perl-termreadkey.x86_64
Otherwise the error is as follows:
[Email protected] servers]#/orztop-u=root-p= ' Yoon '-s=/export/data/mysql/tmp/mysql.sock
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./orztop Line 14.
BEGIN failed--compilation aborted at./orztop Line 14.
[email protected] servers]# Yum search ReadKey
Yum Install perl-termreadkey.x86_64
[Email protected] servers]#./orztop-help
==========================================================================================
Info:
Created by [email protected]
Usage:
Command Line Options:
-help Print help Info.
-H,--host HOSTNAME/IP to use for MySQL connection.
-u,--user user to use for MySQL connection.
-P,--pwd Password to use for MySQL connection.
-P,--Port port to use for MySQL connection (default 3306).
-s,--socket socket to use for MySQL connection.
-T Time (second) Interval.
==========================================================================================
[Email protected] servers]#/orztop-u=root-p= ' Yoon '-s=/export/data/mysql/tmp/mysql.sock
Information also includes the database of Insert/update/delete/select per second, logical reading, hit rate, the current active thread, and so on, you can see the current pressure of the database;
When your instance has a performance bottleneck, you might want to take a look at it and crawl the slow SQL that is currently running
MySQL monitoring tool-orztop