这期内容当中小编将会给大家带来有关安装实时监控关系型数据库开源工具GitHub orzdba的操作方法,文章内容丰富且以专业的角度为大家分析和叙述,阅读完这篇文章希望大家可以有所收获。
前言
数据库运维日常工作是非常繁琐的,开源开源代码库上面有好多提升数据库工作效率的软件。其中orzdba就是非常好用的一款。它集成了操作系统vmstat及iostat的功能,兼有快速查看关系型数据库一些性能指标的功效。而且消耗资源也非常少。
安装orzdba
1,操作系统版本
[root @ primarygtid ~]# more/etc/red hat-release
redhatenterprise linuxserverelese 6.8(圣地亚哥)2,下载并上传orzdba工具
[root @ primarygtid ~]# mkdir-p/monitor _ tool 3,必须是python 2.7以上
[root@three57bin]#python
Python2.7.17(默认,2019年10月22日,13:24:01)
[GCC 4。4 .720120313(红帽4。4 .7-17)]在线x2
键入"帮助"、"版权"、"学分"或"许可证"以获取更多信息。
[root@three57bin]#4,安装gl python软件包
[root @三个57 monitor _ dir]# python ./gl.py5,显示orzdba的具体用法
[root@three57monitor_dir]#ll
总用量64
-rw-r-r-1 rootrout 325410月2213:38gl.py
-rw-r-r-1 rootrout 5759010月2213:36orzdba.py
[root @三个57 monitor _ dir]# python ./orzdba.py
用法: orzdba。py[-h][-iINTERVAL][-t][-sys][-l][-c][-Ddisk][-Nnet]
[-s][-com][-innodb _ rows][-innodb _ pages][-innodb _ data]
[-innodb _ log][-innodb _ status][-innodb][-T][-B][-rt]
[-hit][-MySQL][-PPORT][-SSOCKET][-pPWD][-CCOUNT]
[-LLOGFILE][-log file _ by _ day][-lazy][-无颜色]
CreatedBylub
o 454331202@qq.com
optional arguments:
-h, --help show this help message and exit
-i INTERVAL, --interval INTERVAL
Time(second) Interval.
-t, --time Print The Current Time.
-sys print SysInfo (include -l,-c,-s).
-l, --load Print Load Info.
-c, --cpu Print Cpu Info.
-d DISK, --disk DISK Print Disk Info.
-n NET, --net NET Print Net Info.Time.
-s, --swap Print The Swap Info.
-com print mysql status.
-innodb_rows Print Innodb Rows Status.
-innodb_pages Print Innodb Buffer Pool Pages Status.
-innodb_data Print Innodb Data Status.
-innodb_log Print Innodb Log Status.
-innodb_status Print Innodb Status from Command: "Show Engine Innodb
Status".
-innodb Print Innodb Info.
-T, --threads Print Threads Status.
-B, --bytes Print Bytes Status.
-rt Print MySQL DB RT.
-hit Print Innodb Hit%
-mysql print SysInfo (Print MySQLInfo (include
-t,-com,-hit,-T,-B).
-P PORT, --port PORT Port number to use for mysql connection(default 3306).
-S SOCKET, --socket SOCKET
Socket file to use for mysql connection.
-p PWD, --pwd PWD root user password.
-C COUNT, --count COUNT
Times.
-L LOGFILE, --logfile LOGFILE
ath of logfile.
-logfile_by_day one day a logfile.
-lazy Print Info (include -t,-l,-c,-s,-m,-hit).
--nocolor Print NO color.
6,显示实时性的平均负载及CPU和交换分区的信息
[root@primarygtid monitor_tool]# python orzdba.py -i 3 -sys .=================================================. | Welcome to use the orzdba tool ! | | Yep...Chinese English~ | | Created by lubo qq:454331202~ | '=============== Date: 2019-10-22 ================' HOST: primarygtid IP: 127.0.0.1 -------- -----load-avg---- ---cpu-usage--- ---swap--- time | 1m 5m 15m |usr sys idl iow| si so| 13:27:46| 0.05 0.16 0.17| 0 0 99 0| 0 0| 13:27:49| 0.04 0.16 0.17| 0 0 100 0| 0 0| 13:27:52| 0.04 0.16 0.17| 0 0 100 0| 0 0| 13:27:55| 0.04 0.16 0.17| 0 0 100 0| 0 0|
7,显示磁盘的读写及服务时间及响应时间
[root@primarygtid monitor_tool]# python orzdba.py -i 3 -t -d sda1 .=================================================. | Welcome to use the orzdba tool ! | | Yep...Chinese English~ | | Created by lubo qq:454331202~ | '=============== Date: 2019-10-22 ================' HOST: primarygtid IP: 127.0.0.1 ---------------------------------io-usage----------------------- time | r/s w/s rkB/s wkB/s queue await svctm \%util| 13:29:42| 1.4 0.6 34.2 28.0 0.0 1.7 0.8 0.2| 13:29:45| 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0|
8,显示 mysql INNODB相关信息
[root@primarygtid monitor_tool]# python orzdba.py -innodb | Welcome to use the orzdba tool ! | | Yep...Chinese English~ | | Created by lubo qq:454331202~ | '=============== Date: 2019-10-22 ================' HOST: primarygtid IP: 127.0.0.1 Ver : 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) DB : performance_schema|zxydb Var : binlog_format[ROW]max_connect_errors[100]max_connections[4000] max_user_connections[2500]open_files_limit[65535]sync_binlog[1] table_definition_cache[1424]table_open_cache[2048]thread_cache_size[1024] innodb_adaptive_flushing[ON]innodb_adaptive_hash_index[ON]innodb_buffer_pool_size[3G] innodb_file_per_table[ON]innodb_flush_log_at_trx_commit[1]innodb_flush_log_at_trx_commit[1] innodb_io_capacity[200]innodb_lock_wait_timeout[50]innodb_log_buffer_size[16M] innodb_log_file_size[2G]innodb_log_files_in_group[2]innodb_max_dirty_pages_pct[75] innodb_open_files[2048]innodb_read_io_threads[24]innodb_thread_concurrency[24] innodb_write_io_threads[24] -----------innodb bp pages status-- -----innodb data status---- --innodb log-- his --log(byte)-- read ---query--- time | data free dirty flush| reads writes read written|fsyncs written| list uflush uckpt view inside que| 13:30:35| 0 0 0 0| 0 0 0 0| 0 0| 0 0.0b 0.0b 0 0 0| 13:30:36| 429 196178 0 0| 0 0 0 0| 0 0| 351 0.0b 0.0b 0 0 0| 13:30:37| 429 196178 0 0| 0 0 0 0| 0 0| 351 0.0b 0.0b 0 0 0| 13:30:38| 429 196178 0 0| 0 0 0 0| 0 0| 351 0.0b 0.0b 0 0 0| 13:30:39| 429 196178 0 0| 0 0 0 0| 0 0| 351 0.0b 0.0b 0 0 0| 13:30:40| 429 196178 0 0| 0 0 0 0| 0 0| 351 0.0b 0.0b 0 0 0|
9,显示mysql QPS及TPS相关信息,并且显示所有相关的系统变量配置
[root@primarygtid monitor_tool]# python orzdba.py -C 10 -i 3 -com .=================================================. | Welcome to use the orzdba tool ! | | Yep...Chinese English~ | | Created by lubo qq:454331202~ | '=============== Date: 2019-10-22 ================' HOST: primarygtid IP: 127.0.0.1 Ver : 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) DB : performance_schema|zxydb Var : binlog_format[ROW]max_connect_errors[100]max_connections[4000] max_user_connections[2500]open_files_limit[65535]sync_binlog[1] table_definition_cache[1424]table_open_cache[2048]thread_cache_size[1024] innodb_adaptive_flushing[ON]innodb_adaptive_hash_index[ON]innodb_buffer_pool_size[3G] innodb_file_per_table[ON]innodb_flush_log_at_trx_commit[1]innodb_flush_log_at_trx_commit[1] innodb_io_capacity[200]innodb_lock_wait_timeout[50]innodb_log_buffer_size[16M] innodb_log_file_size[2G]innodb_log_files_in_group[2]innodb_max_dirty_pages_pct[75] innodb_open_files[2048]innodb_read_io_threads[24]innodb_thread_concurrency[24] innodb_write_io_threads[24] -----------QPS--TPS----------- ins upd del sel iud| 0 0 0 0 0| 0 0 0 2 0| 0 0 0 2 0| 0 0 0 2 0|
10,示mysql QPS及TPS及HIT及THREAD和BYTE相关信息
[root@primarygtid monitor_tool]# python orzdba.py -mysql -C 10 -i 3 .=================================================. | Welcome to use the orzdba tool ! | | Yep...Chinese English~ | | Created by lubo qq:454331202~ | '=============== Date: 2019-10-22 ================' HOST: primarygtid IP: 127.0.0.1 Ver : 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) DB : performance_schema|zxydb Var : binlog_format[ROW]max_connect_errors[100]max_connections[4000] max_user_connections[2500]open_files_limit[65535]sync_binlog[1] table_definition_cache[1424]table_open_cache[2048]thread_cache_size[1024] innodb_adaptive_flushing[ON]innodb_adaptive_hash_index[ON]innodb_buffer_pool_size[3G] innodb_file_per_table[ON]innodb_flush_log_at_trx_commit[1]innodb_flush_log_at_trx_commit[1] innodb_io_capacity[200]innodb_lock_wait_timeout[50]innodb_log_buffer_size[16M] innodb_log_file_size[2G]innodb_log_files_in_group[2]innodb_max_dirty_pages_pct[75] innodb_open_files[2048]innodb_read_io_threads[24]innodb_thread_concurrency[24] innodb_write_io_threads[24] -------------------QPS--TPS----------- ------Hit%----- ------threads------ -----bytes---- time | ins upd del sel iud| lor hit| run con cre cac| recv send| 13:34:44| 0 0 0 0 0| 0 100.00| 0 0 0 0| 0 0| 13:34:47| 0 0 0 2 0| 0 100.00| 3 5 0 1| 391b 522b|
上述就是小编为大家分享的安装实时监控mysql开源工具GitHub orzdba的操作方法了,如果刚好有类似的疑惑,不妨参照上述分析进行理解。如果想知道更多相关知识,欢迎关注行业资讯频道。
内容来源网络,如有侵权,联系删除,本文地址:https://www.230890.com/zhan/55810.html