Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

USER_STATISTITCS NOT populated

Description

Hi There,

Our environment is composed by two nodes running Xtdadb cluster ( third mode node is used as arbiter).

When enabling the userstat ( set global userstat=1 ), it seems that the user_statistics remains empt, only  TOTAL_CONNECTIONS and TOTAL_SSL_CONNECTIONS are modified when a user connects and do some queries. All the rest of columns remains whith 0 value.

Table_statistics and index_statistics are normally populated.

We are running our database  on a system :

CentOS Linux release 7.6.1810 (Core)

Kernel : 3.10.0-957.12.2.el7.x86_64

 

Thanks.

 

 

 

Environment

None

Smart Checklist

Activity

Show:

Stofa Kenida June 3, 2019 at 12:14 PM

Hi,

Yes, i  confirm. Used version is : 5.7.25-28-57-log Percona XtraDB Cluster (GPL)

Thanks.

Stofa.

Jericho Rivera June 1, 2019 at 5:32 AM

As mentioned, this is a duplicate of https://perconadev.atlassian.net/browse/PXC-2432#icft=PXC-2432 and marked as such. I will update the other bug report.

Jericho Rivera June 1, 2019 at 5:28 AM

This is a duplicate of https://perconadev.atlassian.net/browse/PXC-2432#icft=PXC-2432. I've checked and this is reproducible. Will update the other ticket.

Can you confirm you are using PXC version 5.7.25?

Duplicate

Details

Assignee

Reporter

Priority

Smart Checklist

Created May 31, 2019 at 8:06 AM
Updated March 6, 2024 at 10:09 PM
Resolved June 1, 2019 at 5:32 AM
Configure