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.