MySQL Status through mysqldump

You can easily run the following line at command prompt to retrieve the MySQL server uptime statistics along with the number of connected threads, the information regarding expensive queries, Queries per second on average, etc. In other words, it’s a quick and simple approach to determine the mysql instance’s state.

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqladmin -u root -p status
Enter password: **********
Uptime: 662530 Threads: 2 Questions: 2 Slow queries: 0 Opens: 117 Flush tables: 3 Open tables: 36 Queries per second avg: 0.000


Happy learning!!!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s