有了mysql的管理权限,我如何才能看到我的服务器中到特定数据库的所有打开的连接?
发布于 2009-10-25 21:23:57
该命令为
SHOW PROCESSLIST
不幸的是it has no narrowing parameters。如果您需要它们,可以从命令行执行:
mysqladmin processlist | grep database-name
发布于 2013-07-03 00:07:14
您也可以使用:
mysql> show status like '%onn%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_connects | 0 |
| Connections | 303 |
| Max_used_connections | 127 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 127 |
+--------------------------+-------+
7 rows in set (0.01 sec)
您可以随意使用Mysql-server-status-variables或Too-many-connections-problem
发布于 2014-01-11 16:41:01
对于最新的MySQL版本,这应该可以做到这一点:
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE DB = "elstream_development";
https://stackoverflow.com/questions/1620662
复制相似问题