Learn how to find current status of MySQL server

By admin|Computer, MySQL

To find current status of mysql you can use mysqladmin status with username and password.

# mysqladmin -u root -ptestpassword status
Uptime: 93516  
Threads: 2  Questions: 49  Slow queries: 0  Opens: 54  
Flush tables: 1  Open tables: 47  Queries per second avg: 0.0

The status command displays the following information:

Uptime: Uptime of the mysql server in seconds
Threads: Total number of clients connected to the server.
Questions: Total number of queries the server has executed since the startup.
Slow queries: Total number of queries whose execution time waas more than long_query_time variable’s value.
Opens: Total number of tables opened by the server.
Flush tables: How many times the tables were flushed.
Open tables: Total number of open tables in the database.