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

This article introduces the relevant knowledge of "how to query the status of mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

In mysql, you can query the mysql status using the "show status" command, which is used to view the status information of the server, which displays the name and value of each server variable, which is read-only and whose syntax is "show status".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to query mysql status

At work, sometimes we need to know the status information of the MySQL server, at this time, we can use the SHOW STATUS command to view the status information of the server.

The SHOW STATUS command displays the name and value of each server variable, and the status variable is read-only. We can run SHOW STATUS under the MySQL client or use mysqladmin extended-status on the command line to view these variables. If you use the SQL command, you can use LIKE or WHERE to restrict the results. LIKE can do standard pattern matching on variable names.

SHOW STATUS is a mix of global and session variables, many of which have double fields: both global and session variables with the same name. If you only need to look at the global variables, you need to SHOW GLOBAL STATUS instead.

Show databases shows all databases

Then use selects the database to operate on

Then show status checks the status.

Finally, all the attributes of the database are listed, which are very complete, as shown in the following figure.

This is the end of "how to query mysql status". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.