Search

MySQLサーバー接続情報表示

unknown

\s
mysql> \s Enter
--------------
mysql  Ver 12.22 Distrib 4.0.26, for Win32 (ia32)

Connection id:          6
Current database:
Current user:           root@localhost
SSL:                    Not in use
Server version:         4.0.26-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    sjis
Server characterset:    sjis
TCP port:               3306
Uptime:                 2 hours 38 min 37 sec

Threads: 2  Questions: 1841  Slow queries: 0  Opens: 6  Flush tables: 1  Open tables: 0  Queries per second avg: 0.193
--------------

接続IDを取得

unknown

SELECT CONNECTION_ID();
mysql> SELECT CONNECTION_ID(); Enter
+-----------------+
| connection_id() |
+-----------------+
|               7 |
+-----------------+
1 row in set (0.00 sec)

現在のセッションの認証に使用されたユーザー名とホスト名を取得

unknown

SELECT CURRENT_USER();
mysql> SELECT CURRENT_USER(); Enter
+----------------+
| CURRENT_USER() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

現在のデータベース名を取得

unknown

SELECT DATABASE();
mysql> USE db_customer Enter
Database changed
mysql> SELECT DATABASE(); Enter
+-------------+
| DATABASE()  |
+-------------+
| db_customer |
+-------------+
1 row in set (0.00 sec)

AUTO_INCREMENT型のカラムに挿入された値のうち、最後に自動生成された値を取得

unknown

SELECT LAST_INSERT_ID();
# 1レコード挿入
mysql> INSERT INTO tbl_Customer (FirstName, LastName, Sex, Age) Enter
    -> VALUES ('光一', '鈴木', 'm', 21); Enter
Query OK, 1 row affected (0.32 sec)

mysql> SELECT LAST_INSERT_ID(); Enter
+------------------+
| last_insert_id() |
+------------------+
|                6 |
+------------------+
1 row in set (0.00 sec)

# またまた、1レコード挿入
mysql> INSERT INTO tbl_Customer (FirstName, LastName, Sex, Age) Enter
    -> VALUES ('花子', '田中', 'f', 35); Enter
Query OK, 1 row affected (0.00 sec)

mysql> SELECT LAST_INSERT_ID(); Enter
+------------------+
| last_insert_id() |
+------------------+
|                7 |
+------------------+
1 row in set (0.00 sec)

現在のユーザー名とホスト名を取得

unknown

SELECT USER();
mysql> SELECT USER(); Enter
+----------------+
| USER()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

MySQLサーバーのバージョン情報を取得

unknown

SELECT VERSION();
mysql> SELECT VERSION(); Enter
+-----------+
| VERSION() |
+-----------+
| 4.0.26-nt |
+-----------+
1 row in set (0.00 sec)

サーバのバージョン番号と現在日時を取得

unknown

SELECT VERSION(), CURRENT_DATE;
mysql> SELECT VERSION(), CURRENT_DATE; Enter
+-----------+--------------+
| VERSION() | CURRENT_DATE |
+-----------+--------------+
| 4.0.26-nt | 2006-11-11   |
+-----------+--------------+
1 row in set (0.00 sec)

サーバーが起動しているかどうか調べる
mysqladmin ping

unknown

mysqladmin ping
C:\mysql\bin> mysqladmin ping Enter
mysqld is alive

実行中のプロセスを調べる
SHOW PROCESSLIST

unknown

SHOW PROCESSLIST;
mysql> SHOW PROCESSLIST; Enter
+----+------+----------------+-------------+---------+------+-------+------------------+
| Id | User | Host           | db          | Command | Time | State | Info             |
+----+------+----------------+-------------+---------+------+-------+------------------+
|  2 | ODBC | localhost:1042 | NULL        | Sleep   | 6    |       | NULL             |
|  8 | root | localhost:2287 | db_customer | Query   | 0    | NULL  | SHOW PROCESSLIST |
+----+------+----------------+-------------+---------+------+-------+------------------+
2 rows in set (0.00 sec)

サーバーのステータス情報を調べる
SHOW STATUS

unknown

SHOW STATUS; または SHOW STATUS LIKE 'ワイルドカード';
mysql> SHOW STATUS; Enter
+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| Aborted_clients          | 0       |
| Aborted_connects         | 3       |
| Bytes_received           | 32480   |

・・・略・・・

| Threads_created          | 8       |
| Threads_running          | 1       |
| Uptime                   | 15176   |
+--------------------------+---------+
133 rows in set (0.00 sec)

# ワールドカード使用
mysql> SHOW STATUS LIKE 't%'; Enter
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| Table_locks_immediate | 6     |
| Table_locks_waited    | 0     |
| Threads_cached        | 0     |
| Threads_connected     | 2     |
| Threads_created       | 4     |
| Threads_running       | 1     |
+-----------------------+-------+
6 rows in set (0.06 sec)

サーバーの変数を調べる
SHOW VARIABLES

unknown

SHOW VARIABLES; または SHOW VARIABLES LIKE 'ワイルドカード';
mysql> SHOW VARIABLES; Enter
+---------------------------------+---------------------------------+
| Variable_name                   | Value                           |
+---------------------------------+---------------------------------+
| back_log                        | 50                              |
| basedir                         | C:\mysql\\                       |
・・・略・・・

| version                         | 4.0.26-nt                       |
| version_comment                 | Official MySQL binary           |
| version_compile_os              | Win32                           |
| wait_timeout                    | 28800                           |
+---------------------------------+---------------------------------+
134 rows in set (0.10 sec)

関連コンテンツ

Q. このサイトの情報はお役に立ちましたでしょうか?

投票する 投票結果を見る

管理人に【web拍手】を送るweb拍手(1行メッセージも送れます♪)

pagetop

polarized women