MySQL監控工具-orzdba
原始碼地址:http://code.taobao.org/p/orzdba/src/trunk/
[root@hank-yoon servers]# chmod +x orzdba
在程式碼的160行左右,配置自己的MySQL驗證資訊: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 -h127.0.0.1 -P$port };
先安裝tcprstat
[root@hank-yoon servers]# ln -sf /export/servers/tcprstat-static.v0.3.1.x86_64 /usr/bin/tcprstat
[root@hank-yoon servers]#chmod u+s /usr/bin/tcprstat
需要安裝的perl依賴包:
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
安裝中報錯:(因缺少了“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
安裝Perl的File:LockFfile模組
安裝version模組
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
安裝安裝File::Lockfile模組:
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
安裝Class-Data-Inheritable模組:
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
安裝Module-Build模組:
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
安裝完提示:Usage: Socket::inet_ntoa(ip_address_sv) at ./orz line 477
因主機名不能解析,將IP和主機名寫到/etc/hosts檔案
[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:此間隔內完成的請求數量
avg:此間隔內所有完成的請求,響應的平均時間
95_avg:此間隔內,95%的請求量的平均響應時間,單位微秒,該值較能體現MySQL Server查詢的平均響應時間
[root@hank-yoon servers]# ./orzdba -innodb -S /export/data/mysql/tmp/mysql.sock
[root@hank-yoon servers]# chmod +x orzdba
在程式碼的160行左右,配置自己的MySQL驗證資訊: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 -h127.0.0.1 -P$port };
先安裝tcprstat
[root@hank-yoon servers]# ln -sf /export/servers/tcprstat-static.v0.3.1.x86_64 /usr/bin/tcprstat
[root@hank-yoon servers]#chmod u+s /usr/bin/tcprstat
需要安裝的perl依賴包:
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
安裝中報錯:(因缺少了“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
安裝Perl的File:LockFfile模組
安裝version模組
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
安裝安裝File::Lockfile模組:
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
安裝Class-Data-Inheritable模組:
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
安裝Module-Build模組:
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
安裝完提示:Usage: Socket::inet_ntoa(ip_address_sv) at ./orz line 477
因主機名不能解析,將IP和主機名寫到/etc/hosts檔案
[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:此間隔內完成的請求數量
avg:此間隔內所有完成的請求,響應的平均時間
95_avg:此間隔內,95%的請求量的平均響應時間,單位微秒,該值較能體現MySQL Server查詢的平均響應時間
[root@hank-yoon servers]# ./orzdba -innodb -S /export/data/mysql/tmp/mysql.sock
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-1875895/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL監控工具之orzdbaMySql
- 監控mysql之orzdba和orztopMySql
- 安裝實時監控mysql開源工具GitHub orzdba操作指南MySql開源工具Github
- MySQL監控工具MySql
- MySQL監控工具-orztopMySql
- MySQL 效能監控工具--mysqlreportMySql
- Mytop工具來監控MySQL資源MySql
- Redis監控工具Redis
- Ganglia監控工具
- MySQL監控--zabbixMySql
- cacti監控mysqlMySql
- mytop 使用介紹 mysql實時監控工具MySql
- Mycat Web監控工具Web
- 效能監控工具YourKit
- JVM 效能監控工具JVM
- CentOS效能監控工具CentOS
- MySQL監控利器-InnotopMySql
- mysql監控指令碼MySql指令碼
- Mysql 監控系統MySql
- Mysql監控快速指南MySql
- mysql 的一個監控指令碼,監控heartbeatMySql指令碼
- MySQL監控-Datadog資料庫監控調研MySql資料庫
- mysql mon 的一個監控指令碼,監控heartbeatMySql指令碼
- 網站監控工具有哪些,8款好用的監控工具推薦網站
- 配置CACTI監控MySQL資料庫狀態(5)增加MySQL監控模板MySql資料庫
- Mac系統監控工具Mac
- tomcat 監控工具probeTomcat
- 【AIX】AIX程式監控工具AI
- OceanBase 監控工具 OBAgent
- linux監控工具auditLinux
- 網路監控工具ntopng
- ? Hyperic HQ 監控工具
- 叢集監控工具ganglia
- windows 下的 監控工具Windows
- 資源監控工具 glances
- 搭建Lepus 天兔 監控MySQLMySql
- mysql效能監控相關MySql
- Prometheus MySQL監控+grafana展示PrometheusMySqlGrafana