Introduction to MySQL Real-time Monitoring Tool orztop, mysqlorztop

Introduction to MySQL Real-time Monitoring Tool orztop, mysqlorztop

Preface

Orztop is a real-time show full processlist tool. We can see in real time which threads and statements are executed in the database. The tool is easy to use. Solved the pain point of manually refreshing show full processlist.

This tool is a tool developed by Zhu Xu to view the SQL status of mysql database in real time, those who used to crawl SQL through show processlist/show full processlist can now just stare at the screen. The usage is also very simple, as shown below:

Orztop result Graph

Here I am using the tpcc-mysql tool for stress testing on mysql. The result of orztop is as follows:

Orztop command line

Orztop command lines are relatively simple in English. These English reading skills are essential for an IT staff ..

[root@wing orztop]# ./orztop --help==========================================================================================Info :    Created By zhuxu@taobao.comUsage :Command line options :  -help  Print Help Info.   -h,--host Hostname/Ip to use for mysql connection.  -u,--user User  to use for mysql connection.  -p,--pwd Password to use for mysql connection.  -P,--port Port  to use for mysql connection(default 3306).   -S,--socket Socket  to use for mysql connection.  -t   Time(second) Interval. ==========================================================================================

Summary

The above is all about this article. I hope this article will help you in your study or work. If you have any questions, please leave a message.