Home >Database >Mysql Tutorial >mysql使用status命令测试/判断数据库是否连接

mysql使用status命令测试/判断数据库是否连接

WBOY
WBOYOriginal
2016-06-01 09:56:471428browse

眼熟如下所示:

<code class="language-sql">mysql>
mysql>
mysql> STATUS;
--------------
mysql  Ver 14.12 Distrib 5.0.41, for Win32 (ia32)

Connection id:          55
Current database:       test
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.0.41-community-nt MySQL Community Edition (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 10 days 23 hours 17 min 22 sec

Threads: 1  Questions: 34588  Slow queries: 0  Opens: 4294  Flush tables: 1  Open tables: 18  Queries per second avg: 0.036
--------------

mysql></code>

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn