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

This article is about how to monitor MySQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Show global status

Mysqladmin extended-status-I 1

Every second, but the values are cumulative.

Mysqladmin extended-status-I 1-r

Relative value within 1 second

Mysqladmin extended-status-I 1-r | grep Com_

Com_ indicates what actions are currently in place.

Question

Innodb_ about the innodb engine

Of course, show global status these monitoring is not a system to monitor the starting point, more from the system io cpu memory and other monitoring.

IOSTAT IOTOP free

Most join sorting is CPU-intensive.

SQL of slow log

Show engine innodb status

Thank you for reading! This is the end of this article on "how to monitor MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.