如何确定正确的连接数

Question

我正在尝试确定我的数据库上的连接数量，我从网络上找到了以下查询和结果，它们的输出非常不同。谁能告诉我哪个数字正确地显示了数据库上的连接数量，以及如何获得有关这些连接的更多详细信息？

mysql> SELECT SUBSTRING_INDEX(host, ':', 1) AS host_short,
    ->        GROUP_CONCAT(DISTINCT USER)   AS users,
    ->        COUNT(*)
    -> FROM   information_schema.processlist
    -> GROUP  BY host_short
    -> ORDER  BY COUNT(*),
    ->           host_short;
+------------+-------------+----------+
| host_short | users       | COUNT(*) |
+------------+-------------+----------+
| localhost  | root,mailer |        7 |
+------------+-------------+----------+
1 row in set (0.01 sec)

mysql> show status like 'Conn%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Connections   | 9885  |
+---------------+-------+
1 row in set (0.00 sec)

Answer 1

我使用如下查询找到了想要的结果-

SELECT 
    db_name(dbid) as DBName, 
    COUNT(dbid) as ConnNo,
    loginame as Login
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame
;