How can I check the status of MySQL Server?

MySQLMySQLi Database

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
raja
Published on 20-Feb-2018 12:40:39
Advertisements