mysqlにおいてデータベースサーバの状態を確認する

statusコマンドを使用します。

mysql> status;     
--------------
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

Connection id:          3103062
Current database:       
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.1.73-log Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    ujis
Db     characterset:    ujis
Client characterset:    ujis
Conn.  characterset:    ujis
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 189 days 5 hours 36 min 42 sec

Threads: 1  Questions: 14517674  Slow queries: 0  Opens: 32  Flush tables: 1  Open tables: 25  Queries per second avg: 0.887
--------------

mysql>

mysql> status;

--------------

mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

Connection id: 3103062

Current database:

Current user: root@localhost

SSL: Not in use

Current pager: stdout

Using outfile: ''

Using delimiter: ;

Server version: 5.1.73-log Source distribution

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: ujis

Db characterset: ujis

Client characterset: ujis

Conn. characterset: ujis

UNIX socket: /var/lib/mysql/mysql.sock

Uptime: 189 days 5 hours 36 min 42 sec

Threads: 1 Questions: 14517674 Slow queries: 0 Opens: 32 Flush tables: 1 Open tables: 25 Queries per second avg: 0.887

--------------

mysql>