mysql显示用户连接数_查看MySQL当前用户占用的连接数

命令： show processlist ; 如果是root帐号，你能看到所有用户的当前连接。如果是其它普通帐号，只能看到自己占用的连接。 show processlist;只列出前100条，如果想全列出请使用show full processlist; mysql> show processlist; +--------+-------+---------------------+--------+---------+-------+-------+----- | Id | User | Host | db | Command | Time | State | Info +--------+-------+---------------------+--------+---------+-------+-------+----- | 90 | nj004 | localhost:33214 | nj004 | Sleep | 2092 | | NULL | 96 | nj018 | localhost:33261 | nj018 | Sleep | 208 | | NULL | 101 | nj017 | localhost:33272 | nj017 | Sleep | 121 | | NULL | 102 | nj017 | localhost:33273 | nj017 | Sleep | 121 | | NULL | 103 | nj017 | localhost:33274 | nj017 | Sleep | 121 | | NULL | 104 | nj017 | localhost:33275 | nj017 | Sleep | 121 | | NULL | 105 | nj017 | localhost:33276 | nj017 | Sleep | 121 | | NULL | 271 | nj039 | localhost:33595 | nj039 | Sleep | 153 | | NULL | 272 | nj039 | localhost:33596 | nj039 | Sleep | 153 | | NULL | 273 | nj039 | localhost:33597 | nj039 | Sleep | 153 | | NULL | 274 | nj039 | localhost:33598 | nj039 | Sleep | 153 | | NULL | 275 | nj039 | localhost:33599 | nj039 | Sleep | 153 | | NULL | 354 | nj038 | localhost:33679 | nj038 | Sleep | 3450 | | NULL | 355 | nj038 | localhost:33680 | nj038 | Sleep | 3450 | | NULL | 356 | nj038 | localhost:33681 | nj038 | Sleep | 3450 | | NULL | 357 | nj038 | localhost:33682 | nj038 | Sleep | 3450 | | NULL | 358 | nj038 | localhost:33683 | nj038 | Sleep | 3450 | | NULL | 35676 | nj017 | localhost:37194 | nj017 | Sleep | 121 | | NULL | 40990 | nj039 | localhost:42566 | nj039 | Sleep | 153 | | NULL | 40989 | nj039 | localhost:42565 | nj039 | Sleep | 153 | | NULL | 40988 | nj039 | localhost:42564 | nj039 | Sleep | 153 | | NULL | 79980 | nj017 | localhost:52832 | nj017 | Sleep | 121 | | NULL | 91595 | nj039 | localhost:64751 | nj039 | Sleep | 153 | | NULL | 91594 | nj039 | localhost:64750 | nj039 | Sleep | 153 | | NULL | 92868 | nj017 | localhost:33338 | nj017 | Sleep | 121 | | NULL | 234190 | nj004 | localhost:49611 | nj004 | Sleep | 2092 | | NULL | 269918 | nj007 | localhost:56663 | nj007 | Sleep | 59 | | NULL | 269919 | nj007 | localhost:56664 | nj007 | Sleep | 59 | | NULL | 269920 | nj007 | localhost:56665 | nj007 | Sleep | 59 | | NULL | 274676 | nj038 | localhost:62384 | nj038 | Sleep | 3450 | | NULL | 274675 | nj038 | localhost:62383 | nj038 | Sleep | 3450 | | NULL | 274677 | nj038 | localhost:62385 | nj038 | Sleep | 3450 | | NULL | 347199 | nj017 | localhost:42376 | nj017 | Sleep | 121 | | NULL | 347200 | nj017 | localhost:42377 | nj017 | Sleep | 121 | | NULL | 347201 | nj017 | localhost:42378 | nj017 | Sleep | 121 | | NULL | 347202 | nj017 | localhost:42382 | nj017 | Sleep | 121 | | NULL | 347203 | nj017 | localhost:42383 | nj017 | Sleep | 121 | | NULL | 351925 | nj035 | localhost:47424 | nj035 | Sleep | 2215 | | NULL | 398594 | nj001 | localhost:33356 | nj001 | Sleep | 3459 | | NULL | 411508 | root | localhost:47144 | 163jsp | Sleep | 2359 | | NULL | 422234 | nj019 | localhost:59986 | nj019 | Sleep | 2327 | | NULL | 426347 | nj040 | localhost:64974 | nj040 | Sleep | 2 | | NULL | 427185 | nj040 | localhost:33096 | nj040 | Sleep | 2 | | NULL | 429553 | nj020 | localhost:35974 | nj020 | Sleep | 8049 | | NULL | 429970 | nj034 | cnc01:36415 | nj034 | Sleep | 4037 | | NULL | 430059 | nj034 | cnc01:36511 | nj034 | Sleep | 23093 | | NULL | 430142 | nj036 | localhost:36598 | nj036 | Sleep | 13483 | | NULL | 432452 | nj006 | localhost:40432 | nj006 | Sleep | 8839 | | NULL | 434032 | nj008 | localhost:42631 | nj008 | Sleep | 3268 | | NULL | 434049 | nj005 | localhost:42650 | nj005 | Sleep | 4166 | | NULL | 434462 | nj018 | localhost:43093 | nj018 | Sleep | 1082 | | NULL | 434680 | nj023 | localhost:43325 | nj023 | Sleep | 795 | | NULL | 434725 | nj022 | localhost:43377 | nj022 | Sleep | 21 | | NULL | 434768 | nj023 | localhost:43427 | nj023 | Sleep | 291 | | NULL | 434837 | root | 60.16.166.248:63593 | NULL | Query | 0 | NULL | show processlist +--------+-------+---------------------+--------+---------+-------+-------+----- 55 rows in set (0.03 sec) mysql>