参考：http://code.taobao.org/p/orzdba/src/
http://code.taobao.org/p/myrelay/wiki/index/
http://www.taobaodba.com/html/937_orzdba.html
下载源代码：
[root@yz-db paul]# svn co http://code.taobao.org/svn/orzdba/trunk
A trunk/orzdba_rt_depend_perl_module.tar.gz
A trunk/orzdba
A trunk/orzdba工具使用说明.pdf
取出版本 4。
[root@yz-db paul]#
工具使用：
[root@yz-db trunk]# ./orzdba -l
.=================================================.
| Welcome to use the orzdba tool ! |
| Yep…Chinese English~ |
‘=============== Date : 2013-07-15 ===============’
HOST: yz-db IP: 127.0.0.1
—–load-avg—-
1m 5m 15m |
0.00 0.00 0.00|
0.00 0.00 0.00|
0.00 0.00 0.00|
[root@yz-db trunk]# ./orzdba -com
.=================================================.
| Welcome to use the orzdba tool ! |
| Yep…Chinese English~ |
‘=============== Date : 2013-07-15 ===============’
HOST: yz-db IP: 127.0.0.1
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
DB :
Var : ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
Can’t close! at ./orzdba line 516.
[root@yz-db trunk]#
解决：
如果mysql设置了密码就无法运行了。160行加上-ppassword
my $MYSQL = qq{mysql -s –skip-column-names -uroot -ppassword -P$port };
参考：
http://www.techsiteanalytics.com/index.php/2014/01/07/7105