Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23283

User Statistics does not correctly reflect concurrent_connections

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.1, 10.4.13, 10.2, 10.3, 10.4, 10.5
    • 10.4, 10.5
    • Plugin - userstat
    • 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 |
      +-------------+-------------------+------------------------+
      

      Attachments

        Activity

          People

            Gosselin Dave Gosselin
            oli Oli Sennhauser
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.