在mysql里面或操作系统看mysql的

在mysql交互式会话中查看当前连接情况。(root

localhost)[(none)]showprocesslist;+-------+------+-----------------------+-------+---------+------+-------+------------------+

Id

User

Host

db

Command

Time

State

Info

+-------+------+-----------------------+-------+---------+------+-------+------------------+

4

root

localhost:

mysql

Sleep

2

NULL

root

...1:

world

Sleep

NULL

root

...:

world

Sleep

NULL

root

localhost

NULL

Query

0

init

showprocesslist

root

localhost:

mysql

Sleep

50

NULL

root

localhost:

mem

Sleep

2

NULL

+-------+------+-----------------------+-------+---------+------+-------+------------------+6rowsinset(0.00sec)(root

localhost)[(none)]通过查表方式：(root

localhost)[(none)]select*fromINFORMATION_SCHEMA.PROCESSLIST-;+-------+------+-----------------------+-------+---------+------+-----------+---------------------------------------------+

ID

USER

HOST

DB

COMMAND

TIME

STATE

INFO

+-------+------+-----------------------+-------+---------+------+-----------+---------------------------------------------+

4

root

localhost:

mysql

Sleep

11

NULL

root

...1:

world

Sleep

NULL

root

localhost

NULL

Query

0

executing

select*fromINFORMATION_SCHEMA.PROCESSLIST

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

11

NULL

root

localhost:

mem

Sleep

8

NULL

root

localhost:

mysql

Sleep

29

NULL

root

...:

world

Sleep

NULL

+-------+------+-----------------------+-------+---------+------+-----------+---------------------------------------------+8rowsinset(0.00sec)(root

localhost)[(none)]当前自己的会话信息：(root

...)[world]selectconnection_id()-;+-----------------+

connection_id()

+-----------------+

+-----------------+1rowinset(0.02sec)(root

...)[world]然后杀死这个会话。mysqlkill则这个会话出错。(root

...)[world]selectconnection_id()-;ERROR(HY):LostconnectiontoMySQLserverduringquery(root

...)[world]显示当前所有的连接会话（包括系统的）(root

...)[world]SHOWFULLPROCESSLIST-;ERROR(HY):MySQLserverhasgoneawayNoconnection.Tryingtoreconnect...Connectionid:Currentdatabase:world+-------+------+-----------------------+-------+---------+------+-------+-----------------------+

Id

User

Host

db

Command

Time

State

Info

+-------+------+-----------------------+-------+---------+------+-------+-----------------------+

4

root

localhost:

mysql

Sleep

9

NULL

root

...1:

world

Sleep

NULL

root

localhost

NULL

Sleep

71

NULL

root

localhost:

mysql

Sleep

11

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

11

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

localhost:39

mem

Sleep

10

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

9

NULL

root

localhost:

mem

Sleep

10

NULL

root

...:

world

Query

0

init

SHOWFULLPROCESSLIST

+-------+------+-----------------------+-------+---------+------+-------+-----------------------+40rowsinset(0.04sec)

转载请注明：http://www.aierlanlan.com/tzrz/9098.html