站内搜索

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

眼熟如下所示:

mysql>mysql>mysql> STATUS;--------------mysql  Ver 14.12 Distrib 5.0.41, for Win32 (ia32)Connection id:          55Current database:       testCurrent user:           root@localhostSSL:                    Not in useUsing delimiter:        ;Server version:         5.0.41-community-nt MySQL Community Edition (GPL)Protocol version:       10Connection:             localhost via TCP/IPServer characterset:    latin1Db     characterset:    latin1Client characterset:    latin1Conn.  characterset:    latin1TCP port:               3306Uptime:                 10 days 23 hours 17 min 22 secThreads: 1  Questions: 34588  Slow queries: 0  Opens: 4294  Flush tables: 1  Open tables: 18  Queries per second avg: 0.036--------------mysql>
  • 上一篇:mysql join 三个表联接查询实例详解
  • 下一篇:mysql select语句中使用函数