打开的数据库连接数

Question

有没有办法在MYSQL 5.0中获取正在使用的DB连接数量？

- brindha

Answer 1

SHOW STATUS WHERE variable_name = 'Threads_connected'

- Quassnoi

Answer 2

12.5.5.31. SHOW PROCESSLIST 语法

该命令会显示当前连接到服务器的人数。

- user83632

---

实际上，我需要知道迄今为止已经打开了多少个数据库连接。 - brindha

在这种情况下，您可以使用： SHOW STATUS WHERE variable_name = 'Threads_created';要查看任何时候打开的最大连接数，请使用 SHOW STATUS WHERE variable_name = 'Max_used_connections'; - user83632

Answer 3

Number of open connections can be found out by using below query:
   mysql -e 'SHOW STATUS WHERE variable_name LIKE "Threads_%" OR variable_name = "Connections"'

   +-------------------+-------+
   | Variable_name     | Value |
   +-------------------+-------+
   | Connections       | 862   |
   | Threads_cached    | 0     |
   | Threads_connected | 10    |
   | Threads_created   | 26    |
   | Threads_running   | 1     |
   +-------------------+-------+

- Appy