Introduction to MySQL Real-time Monitoring Tool orztop, mysqlorztop

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.