Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you how to install GitHub orzdba, an open source tool for real-time monitoring of mysql. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

Preface

The daily work of database operation and maintenance is very tedious, open source github has a lot of software to improve the efficiency of the database. Among them, orzdba is a very easy to use one. It integrates the functions of the operating system vmstat and iostat, and has the effect of quickly viewing some performance indicators of mysql. And the consumption of resources is very small.

Install orzdba

1, operating system version

[root@primarygtid ~] # more / etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago)

2. Download and upload the orzdba tool

[root@primarygtid] # mkdir-p / monitor_tool

3, must be python 2.7 or above

[root@three57 bin] # pythonPython 2.7.17 (default, Oct 22 2019, 13:24:01) [GCC 4.4.7 20120313 (Red Hat 4.4.7-17)] on linux2Type "help", "copyright", "credits" or "license" for more information. > [root@three57 bin] #

4. Install the gl python package

[root@three57 monitor_dir] # python. / gl.py

5, showing the specific usage of orzdba

[root@three57 monitor_dir] # ll Total usage 64 root root 3254 October 22 13:38 gl.py-rw-r--r-- 1 root root 57590 October 22 13:36 orzdba.py [root@three57 monitor_dir] # python. / orzdba.py usage: orzdba.py [- h] [- I INTERVAL] [- t] [- sys] [- l] [- c] [- d DISK] [- n NET] [- s] [- com] [- innodb_rows] [- innodb_pages] [- innodb_data] [- innodb_log] [- innodb_status] [- innodb] [- T] [- B] [- rt] [- hit] [- mysql] [- P PORT] [- S SOCKET] [- p PWD] [- C COUNT] [- L LOGFILE] [- logfile_by_day] [- lazy] [--nocolor] Created By lubo 454331202@qq.comoptional 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-ljinghe cmllim). -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-tmam comm lim lim liit lim limel 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 people talk about people, etc.) -- nocolor Print NO color.

6. Display real-time average load and CPU and swap partition information

[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 | 00 99 0 | 00 | 13:27:49 | 0.04 0.16 0.17 | 00 100 0 | 00 | 13:27:52 | 0.04 0.16 0.17 | 00 100 0 | 00 | 13:27:55 | 0.04 0.16 0.17 | 00 100 0 | 00 |

7, showing the read, write, service time and response time of the disk

[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 color- -io-usage--- time | rash s wamp 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.000 .00.0 0.0 0.0 0.0 |

8, display information about 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.1Ver: 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server-Advanced Edition (Commercial) DB: performance_schema | zxydbVar: 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 000 | 0 000 | 0 0 | 00.0b 0.0b 000 | 13:30:36 | 429 196178 0 0 | 0 000 | 0 0 | 351 0.0b 0.0b 000 | 13:30:37 | 429 196178 00 | 0 0 | 351 0.0b 0.0b 0 0 0 | 13:30:38 | 429 196178 00 | 0 000 | 0 | 351 0.0b 0.0b 0 0 | 13:30:39 | 429 196178 00 | 0 000 | 0 | 351 0.0b 0.0b 0 000 | 13:30:40 | 429 196178 0 | 0 0 0 | 0 0 | 351 0.0b 0.0b 000 |

9, displays information about mysql QPS and TPS, and displays all relevant system variable configurations

[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.1Ver: 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server-Advanced Edition (Commercial) ) DB: performance_schema | zxydbVar: binlog_ formatting [row] max_connect_errors [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 000 0 | 0 000 20 | 0 000 20 | 0 000 20 |

10, showing mysql QPS and TPS and HIT and THREAD and BYTE related information

[root@primarygtid monitor_tool] # python orzdba.py-mysql-C 10-I 3.thanks. | Welcome to use the orzdba tool | | Yep...Chinese English~ | | Created by lubo qq:454331202~ |'= Date: 2019-10-22 = 'HOST: primarygtid IP: 127.0.0.1Ver: 5.6.25-enterprise-commercial-advanced-log MySQL Enterprise Server-Advanced Edition (Commercial) ) DB: performance_schema | zxydbVar: binlog_ formatting [row] max_connect_errors [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 | 00 | 0 100.00 | 100.00 | 00 | 13:34:47 | 00 20 | 0 100.00 | 3 501 | 391b 522b | the above is the operation method shared by Xiaobian to install the open source tool GitHub orzdba for real-time monitoring mysql. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.