status 또는 \s

mysql> \s 

또는

mysql> status

 

하면 아래와 같은 mysql 의 상태정보가 출력된다. 

 

mysql> \s
--------------
./mysql  Ver 8.0.18 for Linux on x86_64 (Source distribution)

Connection id:          8
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         8.0.18 Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 17 min 40 sec

Threads: 3  Questions: 40  Slow queries: 0  Opens: 150  Flush tables: 3  Open tables: 70  Queries per second avg: 0.037
--------------