How can I check the status of MySQL Server?


With the help of ‘mysqladmin’ along with ‘status’ option program we would be able to check the status of MySQL server. It can be used as follows on command line −

C:\mysql\bin>mysqladmin -u root status
Uptime: 3865 Threads: 1 Questions: 50 Slow queries: 0 Opens: 113
Flush tables: 1 Open tables: 102 Queries per second avg: 0.012

Updated on: 10-Feb-2020

803 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements