mysql里每条用户连接分别有一个独立的线程进行处理所以可以用
mysql> show processlist;
+----+------+----------------+------+---------+------+-------+------------------
+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+----------------+------+---------+------+-------+------------------
+
| 5 | ODBC | localhost:4232 | NULL | Query | 0 | NULL | show processlist
|
+----+------+----------------+------+---------+------+-------+------------------
+
1 row in set (0.00 sec)
mysql> show processlist;
+----+------+----------------+------+---------+------+-------+------------------
+
| Id | User | Host | db | Command | Time | State | Info
|
+----+------+----------------+------+---------+------+-------+------------------
+
| 5 | ODBC | localhost:4232 | NULL | Query | 0 | NULL | show processlist
|
+----+------+----------------+------+---------+------+-------+------------------
+
1 row in set (0.00 sec)
show variables;看看Threads_running得只就知道了