How to Find the Status of MySQL Server

Find the status of MySQL server

There are several possible ways to check the staus of MySQL server.

You need to execute the below commands from bin directory of MySQL installation.

On Linux / Windows

mysqladmin -u root -p Status

Enter password: *******
Uptime: 154500  Threads: 3  Questions: 205  Slow queries: 0  Opens: 131  Flush tables: 1  Open tables: 118  Queries per second avg: 0.001

mysqladmin -u root -p ping

Enter password: *******
mysqld is alive

On Linux only

service mysqld Status

On Windows only

Check the MySQL service Status.

No comments:

Post a Comment