MySQL’s Status Command

The status allows you to see various stats on the MySQL daemon. To get to your MySQL shell, type the following command at your shell:

(where icezip is your user name for MySQL)

A prompt will come up and ask you for your password, so go right in and enter it. This will bring up a MySQL shell.

Welcome to the MySQL monitor.  Commands end with; or g.
Your MySQL connection id is 18724 to server version: 3.22.32
Type ‘help’ for help.

mysql>

To check how the daemon is doing, just type in ‘status;’ and take a look at the info on the screen.

————–
MySQL  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

Connection id:          18724
Current database:
Current user:           icezip@localhost
Server version          3.22.32
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 17 days 10 hours 24 min 48 sec

Threads: 21  Questions: 5425596  Slow queries: 35  Opens: 1006  Flush tables: 1  Open tables: 62
————–
You can tell exactly how busy MySQLd is by keeping an eye on these stats.