How to Check MySQL Status Quickly and Easily

To check the status of your MySQL server, use the SHOW STATUS; command inside the MySQL client to see server statistics. Alternatively, run mysqladmin status from the command line to get a quick summary of server uptime and activity.

Syntax

The main ways to check MySQL status are:

• SHOW STATUS; - Run inside the MySQL client to display detailed server status variables.
• mysqladmin status - Run from the system command line to get a brief server status summary.

sql

SHOW STATUS;

mysqladmin status

Example

This example shows how to check MySQL status using both methods. First, log into MySQL and run SHOW STATUS;. Then, exit and run mysqladmin status from your terminal.

bash

mysql -u root -p
SHOW STATUS;
exit

mysqladmin -u root -p status

Output

mysql> SHOW STATUS;
+-----------------------------------+------------+
| Variable_name                     | Value      |
+-----------------------------------+------------+
| Aborted_clients                   | 5          |
| Aborted_connects                 | 0          |
| Connections                     | 100        |
| Uptime                         | 3600       |
| Threads_connected              | 2          |
+-----------------------------------+------------+

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

# (If password is correct, output will be similar to:)
Uptime: 3600  Threads: 2  Questions: 150  Slow queries: 0  Opens: 50  Flush tables: 1  Open tables: 45  Queries per second avg: 0.041

Common Pitfalls

Common mistakes when checking MySQL status include:

• Running mysqladmin status without proper user permissions or password, causing access denied errors.
• Expecting SHOW STATUS; to give a simple summary; it returns many variables that can be overwhelming.
• Not connecting to the MySQL server before running SHOW STATUS;.

Always ensure you have the right user credentials and understand the output format.

bash

mysqladmin status
# Wrong: No user or password specified, may cause error

mysqladmin -u root -p status
# Right: Prompts for password and shows status

Quick Reference

Command	Description
SHOW STATUS;	Displays detailed server status variables inside MySQL client
mysqladmin status	Shows brief server status from system command line
mysqladmin processlist	Lists current active MySQL connections
SHOW VARIABLES;	Shows server configuration variables

Key Takeaways

Use SHOW STATUS; inside MySQL client for detailed server stats.

Use mysqladmin status from command line for quick server summary.

Always provide correct user credentials to avoid access errors.

Understand that SHOW STATUS; returns many variables, not a simple summary.

Check permissions if you get connection or access denied errors.