Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2432

userstat / I_S.{client,user}_statistics missing most of data

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.6.42-28.30, 5.6.44-28.34, 5.7.26-31.37
    • Fix Version/s: 5.6.45-28.36, 5.7.27-31.39
    • Component/s: None
    • Labels:
      None
    • Environment:

      EL7

      Description

      Userstat feature, or tables INFORMATION_SCHEMA.CLIENT_STATISTICS and INFORMATION_SCHEMA.USER_STATISTICS are missing most of the data.

       

      Server version:

      Percona-XtraDB-Cluster-server-56-5.6.42-28.30.1.el6.x86_64

       

      The configuration "userstat" is enabled:

      # grep userstat /etc/my.cnf
      userstat=1

       

      But still the tables show almost nothing (note that I have redacted the IP address, the field "CLIENT" does show a correct IP address but ~all other fields are zero):

      mysql> select * from client_statistics;
      --------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      | CLIENT | TOTAL_CONNECTIONS | CONCURRENT_CONNECTIONS | CONNECTED_TIME | BUSY_TIME | CPU_TIME | BYTES_RECEIVED | BYTES_SENT | BINLOG_BYTES_WRITTEN | ROWS_FETCHED | ROWS_UPDATED | TABLE_ROWS_READ | SELECT_COMMANDS | UPDATE_COMMANDS | OTHER_COMMANDS | COMMIT_TRANSACTIONS | ROLLBACK_TRANSACTIONS | DENIED_CONNECTIONS | LOST_CONNECTIONS | ACCESS_DENIED | EMPTY_QUERIES | TOTAL_SSL_CONNECTIONS |
      --------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      | 00.00.0.0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
      | | 1 | 1 | 29940137 | 484 | 548 | 0 | 0 | 0 | 0 | 29149934 | 28300922 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
      | 00.00.0.1 | 21328 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
      | 00.00.0.2 | 1595541 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
      | 000.000.000.1 | 26186 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
      | 000.000.000.2 | 167 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
      | 00.00.0.3 | 51582 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |

      Is it a bug? If it is a limitation in PXC, would be nice to have it documented somewhere.

        Attachments

        1. sgs.txt
          53 kB
        2. sgv.txt
          591 kB

          Issue Links

            Activity

              People

              Assignee:
              kenn.takara Kenn Takara
              Reporter:
              v__o Ville Ojamo
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 day, 7 hours, 10 minutes
                  1d 7h 10m

                    Smart Checklist