mysql 環境を確認する方法

mysql の環境を確認する場合、status コマンドを使うと確認することができます。

[mysqluser@centos mysql]$ mysql -u mysqluser -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 237
Server version: 5.0.37-standard MySQL Community Edition - Standard (GPL)

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> status
--------------
mysql  Ver 14.12 Distrib 5.0.37, for pc-linux-gnu (i686) using readline 5.0

Connection id:          237
Current database:
Current user:           mysqluser@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.0.37-standard MySQL Community Edition - Standard (GPL)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /usr/local/mysql/mysql.sock
Uptime:                 12 days 1 hour 14 min 22 sec

Threads: 1  Questions: 2025  Slow queries: 199  Opens: 30  Flush tables: 1  Open tables: 23  Queries per second avg: 0.002
--------------

mysql>