LP #608027: CPU_TIME is UserStats is broken
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
Aaditya DubeySeptember 6, 2024 at 2:42 PM
Hi
Thank you for the report.
Verified as described.
Please note our latest PSMDB operator is 1.16.2 at the moment and 1.17.0 is expected to be released soon.
Done
Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Labels
Needs QA
NoneFix versions
Affects versions
Priority
High
Details
Details
Assignee
Unassigned
UnassignedReporter
lpjirasync
lpjirasync(Deactivated)Labels
Needs QA
None
Fix versions
Affects versions
Priority
HighSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created January 21, 2018 at 10:36 AM
Updated April 17, 2018 at 8:36 AM
Resolved January 21, 2018 at 10:36 AM
**Reported in Launchpad by Peter Zaitsev last update 04-09-2012 10:57:44
Just noticed this:
mysql> select * from information_schema.user_statistics where user="#mysql_system#" \G
*************************** 1. row ***************************
USER: #mysql_system#
TOTAL_CONNECTIONS: 1
CONCURRENT_CONNECTIONS: 0
CONNECTED_TIME: 446
BUSY_TIME: 74
CPU_TIME: 0
BYTES_RECEIVED: 0
BYTES_SENT: 63
BINLOG_BYTES_WRITTEN: 0
ROWS_FETCHED: 0
ROWS_UPDATED: 127576
TABLE_ROWS_READ: 4085689
SELECT_COMMANDS: 0
UPDATE_COMMANDS: 119127
OTHER_COMMANDS: 89557
COMMIT_TRANSACTIONS: 90259
ROLLBACK_TRANSACTIONS: 0
DENIED_CONNECTIONS: 1
LOST_CONNECTIONS: 0
ACCESS_DENIED: 0
EMPTY_QUERIES: 0
1 row in set (0.00 sec)
/sql
The CPU time is 0 which does not sounds right. This is from Percona Server RPM on RHEL 5 64bit. Is it compiled with
proper support ?