データベースのステータスを確認する #status; #\s

status;、または\sでデータベースのステータスを確認することができます。

mysql> use db_name
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.5.38, for osx10.9 (i386) using readline 5.1

Connection id:      24
Current database: db_name
Current user:       root@localhost
SSL:            Not in use
Current pager:      /usr/local/bin/vimpager
Using outfile:      ''
Using delimiter:  ;
Server version:     5.5.38 Source distribution
Protocol version:   10
Connection:     Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:        /opt/local/var/run/mysql55/mysqld.sock
Uptime:         1 hour 40 min 29 sec

Threads: 7  Questions: 97  Slow queries: 0  Opens: 38  Flush tables: 1  Open tables: 31  Queries per second avg: 0.016
--------------