Showing Connection Status of Mysql

Showing Connection Status

The \s command returns the status of the current database connection, including the current database name and the connection parameters.

If you are using several databases at the same time, issuing \s is a handy way to find out which one you are working on at any given time. The following output shows a connection to a MySQL 4.1 server running on a local Windows machine:

mysql> \s
- - - - - - - 
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysql.exe 
Ver 14.7 Distrib 4.1.14, for Win32 (ia32)
Connection id:          94
Current database:       mysqlin10
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         4.1.14-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 35 days 5 hours 34 min 51 sec

Threads: 1  Questions:  542843 Slow queries: 18 Opens: 546
Flush tables: 1 Open tables: 0 Queries per second avg: 0.178
- - - - - - - -