首页 / MYSQL / mysql database 性能监控工具：orzdba

mysql database 性能监控工具：orzdba

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了mysql database 性能监控工具：orzdba，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含7203字，纯文字阅读大概需要11分钟。

内容图文

[root@amb01 ~]# yum install -y perl-ExtUtils-MakeMaker perl-DBD-MySQL perl-DBI \
perl-Module-Build perl-Test-Simple perl-Time-HiRes perl-ExtUtils-CBuilder

[root@amb01 ~]# yum install -y subversion
[root@amb01 ~]# svn co http://code.taobao.org/svn/orzdba/trunk

[root@amb01 ~]# cd trunk
[root@amb01 trunk]# tar zxvf orzdba_rt_depend_perl_module.tar.gz
[root@amb01 trunk]# cd Perl_Module

[root@amb01 Perl_Module]# tar zxvf version-0.99.tar.gz
[root@amb01 Perl_Module]# cd version-0.99
[root@amb01 version-0.99]# perl Makefile.PL
[root@amb01 version-0.99]# make
[root@amb01 version-0.99]# make install

[root@amb01 Perl_Module]# tar zxvf File-Lockfile-v1.0.5.tar.gz
[root@amb01 Perl_Module]# cd File-Lockfile-v1.0.5
[root@amb01 File-Lockfile-v1.0.5]# perl Build.PL
[root@amb01 File-Lockfile-v1.0.5]# ./Build
[root@amb01 File-Lockfile-v1.0.5]# ./Build install

[root@amb01 Perl_Module]# tar zxvf Module-Build-0.31.tar.gz
[root@amb01 Perl_Module]# cd Module-Build-0.31
[root@amb01 Module-Build-0.31]# perl Build.PL
[root@amb01 Module-Build-0.31]# ./Build
[root@amb01 Module-Build-0.31]# ./Build install

[root@amb01 Perl_Module]# tar zxvf Class-Data-Inheritable-0.08.tar.gz
[root@amb01 Perl_Module]# cd Class-Data-Inheritable-0.08
[root@amb01 Class-Data-Inheritable-0.08]# perl Makefile.PL
[root@amb01 Class-Data-Inheritable-0.08]# make
[root@amb01 Class-Data-Inheritable-0.08]# make install

[root@amb01 ~]# cd trunk
[root@amb01 trunk]# chmod a+x orzdba
[root@amb01 trunk]# cp orzdba /usr/bin

[root@amb01 ~]# vi .my.cnf 
[client]
user=root
password=abcd.1234
socket=/tmp/mysql.sock

[root@amb01 ~]# orzdba -help

==========================================================================================
Info  :
        Created By zhuxu@taobao.com
Usage :
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 &
==========================================================================================

[root@amb01 ~]# orzdba -lazy

.=================================================.
|       Welcome to use the orzdba tool !          | 
|          Yep...Chinese English~                 |
'=============== Date : 2018-10-26 ==============='

HOST: amb01   IP: 192.168.40.35
DB  : gswalletdb|performance_schema
Var : binlog_format[ROW] max_binlog_cache_size[32M] max_binlog_size[512M] 
      max_connect_errors[10000] max_connections[500] max_user_connections[0] 
      open_files_limit[65535] sync_binlog[1] table_definition_cache[656] 
      table_open_cache[512] thread_cache_size[64] 

      innodb_adaptive_flushing[ON] innodb_adaptive_hash_index[ON] innodb_buffer_pool_size[2G] 
      innodb_file_per_table[ON] innodb_flush_log_at_trx_commit[1] innodb_flush_method[] 
      innodb_io_capacity[200] innodb_lock_wait_timeout[50] innodb_log_buffer_size[16M] 
      innodb_log_file_size[512M] innodb_log_files_in_group[3] innodb_max_dirty_pages_pct[75] 
      innodb_open_files[512] innodb_read_io_threads[4] innodb_thread_concurrency[0] 
      innodb_write_io_threads[4] 

-------- -----load-avg---- ---cpu-usage--- ---swap---                     -QPS- -TPS-         -Hit%- 
  time  |  1m    5m   15m |usr sys idl iow|   si   so|  ins   upd   del    sel   iud|     lor    hit|
10:30:36| 1.04  0.84  0.79|  3   0  92   5|    0    0|    0     0     0      0     0|       0 100.00|
10:30:37| 1.04  0.84  0.79| 11   0  86   2|    0    0|    2     1     0      2     3|      66 100.00|
10:30:38| 1.04  0.84  0.79| 13   2  82   3|    0    0|    1     1     0      5     2|      69 100.00|
10:30:39| 1.04  0.84  0.79|  1   0  92   7|    0    0|    2     1     0      2     3|      60 100.00|
10:30:40| 1.04  0.84  0.79| 19   0  70  11|    0    0|    2     1     0      2     3|      55 100.00|
10:30:41| 0.96  0.83  0.79|  7   0  77  16|    0    0|    1     2     0      7     3|     107 100.00|
10:30:42| 0.96  0.83  0.79| 10   0  78  11|    0    0|    3     1     0      5     4|     143 100.00|
10:30:43| 0.96  0.83  0.79|  6   0  88   5|    0    0|    0     1     0      2     1|      16 100.00|
10:30:44| 0.96  0.83  0.79|  0   0  95   4|    0    0|    2     2     0      5     4|      77 100.00|
10:30:45| 0.96  0.83  0.79| 18   0  77   5|    0    0|    1     1     0      4     2|     199 100.00|
10:30:46| 0.96  0.83  0.79|  7   0  86   7|    8    0|    5     2     0     25     7|    1406 100.00|
10:30:47| 0.96  0.83  0.79|  9   2  83   7|    0    0|    3     1     0      3     4|      69 100.00|
10:30:48| 0.96  0.83  0.79| 15   1  73  11|    0    0|    1     4     0     32     5|    1048 100.00|
10:30:49| 0.96  0.83  0.79|  6   0  92   2|    0    0|    3     1     0      2     4|     370 100.00|
10:30:50| 0.96  0.83  0.79|  8   0  91   1|    0    0|    1     1     0      2     2|      53 100.00|
-------- -----load-avg---- ---cpu-usage--- ---swap---                     -QPS- -TPS-         -Hit%- 
  time  |  1m    5m   15m |usr sys idl iow|   si   so|  ins   upd   del    sel   iud|     lor    hit|
10:30:51| 0.96  0.83  0.79|  6   0  80  14|    0    0|    1     1     0      7     2|     106 100.00|
10:30:52| 0.96  0.83  0.79|  1   0  94   5|    0    0|    2     1     0      3     3|      59 100.00|
10:30:53| 0.96  0.83  0.79| 19   0  77   4|    0    0|    2     1     0      3     3|      58 100.00|


内容总结

以上是互联网集市为您收集整理的mysql database 性能监控工具：orzdba全部内容，希望文章能够帮你解决mysql database 性能监控工具：orzdba所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/919025.html

来源：【匿名】