Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4.13, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
Linux, Ubuntu 18.04, n.a.
Description
User Statistics does not correctly reflect concurrent_connections:
SQL> SET GLOBAL userstat=1;
|
SQL> SELECT @@userstat, @@performance_schema;
|
+------------+----------------------+
|
| @@userstat | @@performance_schema |
|
+------------+----------------------+
|
| 1 | 1 |
|
+------------+----------------------+
|
|
|
SQL> SHOW PROCESSLIST;
|
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
|
| 10 | root | localhost | NULL | Query | 0 | Init | SHOW PROCESSLIST | 0.000 |
|
| 16 | app | localhost | test | Sleep | 38 | | NULL | 0.000 |
|
| 17 | app | localhost | test | Sleep | 36 | | NULL | 0.000 |
|
| 18 | root | localhost | NULL | Sleep | 34 | | NULL | 0.000 |
|
| 19 | root | localhost | NULL | Sleep | 31 | | NULL | 0.000 |
|
+----+-------------+-----------+------+---------+------+--------------------------+------------------+----------+
|
|
|
SQL> SELECT user, total_connections, concurrent_connections FROM information_schema.USER_STATISTICS;
|
+-------------+-------------------+------------------------+
|
| user | total_connections | concurrent_connections |
|
+-------------+-------------------+------------------------+
|
| app | 2 | 0 |
|
| root | 3 | 0 |
|
+-------------+-------------------+------------------------+
|