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:
1 | [icezip@saturn ~/]$ mysql -u icezip -p |
(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.
1 | mysql> status; |
————–
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.