Show Server Status with "mysqladmin" in MySQL

Q

How To Check Server Status with "mysqladmin" in MySQL?

✍: FYIcenter.com

A

If you want to check the server status by with "mysqladmin", you can following this tutorial example:

>cd \mysql\bin
>mysqladmin -u root status
Uptime: 223  Threads: 1  Questions: 1  Slow queries: 0 
 Opens: 12  Flush tables: 1  Open tables: 6 
 Queries per second avg: 0.004

The returning message indicates that the server is almost doing nothing at this moment. To know about "mysqladmin", read other parts of this FAQ collection.

 

Administrator Tools for Managing MySQL Server

⇒⇒MySQL Database Tutorials

2016-10-17, 220👍, 0💬