orzdba安装与使用
转载地址来源:http://blog.51cto.com/arthur376/1888931
orzdba是淘宝DBA团队开发出来的一个perl监控脚本,主要功能是监控mysql数据库,也有一些磁盘和cpu的监控选项,好不好用就见仁见智,毕竟各公司需求不尽相同.
安装:
既然是perl脚本,那当然是先装各种perl相关的依赖包和控件:
|
1
2
|
yum install -y perl-Test-Simple.x86_64 perl-Time-HiRes perl-ExtUtils-CBuilder yum install -y perl-ExtUtils-MakeMaker perl-DBD-MySQL perl-DBI perl-Module-Build |
还有一个依赖命令:
|
1
2
3
4
5
6
|
#先下载下来wget http://github.com/downloads/Lowercases/tcprstat/tcprstat-static.v0.3.1.x86_64#移动到/usr/binmv tcprstat-static.v0.3.1.x86_64 /usr/bin/#做个连接ln -sf /usr/bin/tcprstat-static.v0.3.1.x86_64 /usr/bin/tcprstat |
然后来下载脚本和依赖包,
http://code.taobao.org/svn/orzdba/trunk
或者这样也可以
|
1
2
3
4
5
6
7
8
9
10
|
#先安装svn客户端yum install -y subversion#或apt-get install -y subversion#然后下载svn co http://code.taobao.org/svn/orzdba/trunkA trunk/orzdba_rt_depend_perl_module.tar.gzA trunk/orzdbaA trunk/orzdba工具使用说明.pdf取出版本 4。 |
----------------------------------------------------------------------------------
这个我已经上传到51cto了,大家可以直接去下载,全部在里面
http://down.51cto.com/data/2277755
然后这个也是修改过的脚本,直接修改26-29行的变量就行,不用跳到160行修改,
|
1
2
3
4
5
|
cat orzdbamy $used = 'root'; #用户名my $pswd = '****'; #密码my $ipdz = '127.0.0.1'; #ip地址my $port = 3306; # -P 端口号 |
-----------------------------------------------------------------------------------
下载回来的包会有个压缩包,要安装里面的控件,
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
#先解压tar xf orzdba_rt_depend_perl_module.tar.gz#进去解压后的文件夹cd Perl_Module#里面有几个压缩包,一个个来安装tar xf version-0.99.tar.gzcd version-0.99perl Makefile.PLmake make installcd ..tar xf File-Lockfile-v1.0.5.tar.gz cd File-Lockfile-v1.0.5 perl Build.PLperl ./Buildperl ./Build installcd ..tar xf Class-Data-Inheritable-0.08.tar.gzcd Class-Data-Inheritable-0.08 perl Makefile.PL make make installcd ..tar xf Module-Build-0.31.tar.gz cd Module-Build-0.31 perl Build.PL ./Build ./Build install |
当然了,还要改下配置,不然你怎么确认他连的是哪里呢?
|
1
2
3
4
5
6
7
8
9
|
#需要在代码160行左右配置MySQL的相关验证信息,如username,password,host，port，sock等,改成类似下面这样#如果你是用我上传到51cto的包，那就改26-29行就行了grep -n 'my $MYSQL' orzdba160:my $MYSQL = qq{mysql -s --skip-column-names -uroot -p123123 -h127.0.0.1 -P$port };#然后改一下host信息,不然会报错(不要在意我的计算机名)cat /etc/hosts172.17.0.2 32044b19ae8c#最后,加个执行权限吧chmod +x orzdba |
这个时候就可以用了.
使用参数说明
Command line options :
-h,--help Print Help Info.
-i,--interval Time(second) Interval.
-C,--count Times.
-t,--time Print The Current Time.
-nocolor Print NO Color.
-l,--load Print Load Info.
-c,--cpu Print Cpu Info.
-s,--swap Print Swap Info.
-d,--disk Print Disk Info.
-n,--net Print Net Info.
-P,--port Port number to use for mysql connection(default 3306).
-S,--socket Socket file to use for mysql connection.
-com Print MySQL Status(Com_select,Com_insert,Com_update,Com_delete).
-hit Print Innodb Hit%.
-innodb_rows Print Innodb Rows Status(Innodb_rows_inserted/updated/deleted/read).
-innodb_pages Print Innodb Buffer Pool Pages Status(Innodb_buffer_pool_pages_data/free/dirty/flushed)
-innodb_data Print Innodb Data Status(Innodb_data_reads/writes/read/written)
-innodb_log Print Innodb Log Status(Innodb_os_log_fsyncs/written)
-innodb_status Print Innodb Status from Command: 'Show Engine Innodb Status'
(history list/ log unflushed/uncheckpointed bytes/ read views/ queries inside/queued)
-T,--threads Print Threads Status(Threads_running,Threads_connected,Threads_created,Threads_cached).
-rt Print MySQL DB RT(us).
-B,--bytes Print Bytes received from/send to MySQL(Bytes_received,Bytes_sent).
-mysql Print MySQLInfo (include -t,-com,-hit,-T,-B).
-innodb Print InnodbInfo(include -t,-innodb_pages,-innodb_data,-innodb_log,-innodb_status)
-sys Print SysInfo (include -t,-l,-c,-s).
-lazy Print Info (include -t,-l,-c,-s,-com,-hit).
-L,--logfile Print to Logfile.
-logfile_by_day One day a logfile,the suffix of logfile is 'yyyy-mm-dd';
and is valid with -L.
Sample :
shell> nohup ./orzdba -lazy -d sda -C 5 -i 2 -L /tmp/orzdba.log > /dev/null 2>&1 &
监控InnoDB的各项指标: ./orzdba -innodb 2>/dev/null
监控MySQL Server性能: ./orzdba -mysql 2>/dev/null
展示内容:load-avg、cpu-usage、swap、QPS、TPS、Hit%、threads、bytes:
./orzdba -mysql -lazy
