CPU_TIME is UserStats is broken
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Medium
|
Ignacio Nin | ||
5.1 |
Invalid
|
Medium
|
Ignacio Nin | ||
5.5 |
Invalid
|
Medium
|
Ignacio Nin |
Bug Description
Just noticed this:
mysql> select * from information_
*******
USER: #mysql_system#
TOTAL_CONNECTIONS: 1
CONCURRENT_
CONNECTED_TIME: 446
BUSY_TIME: 74
CPU_TIME: 0
BYTES_RECEIVED: 0
BYTES_SENT: 63
BINLOG_
ROWS_FETCHED: 0
ROWS_UPDATED: 127576
TABLE_ROWS_READ: 4085689
SELECT_COMMANDS: 0
UPDATE_COMMANDS: 119127
OTHER_COMMANDS: 89557
COMMIT_
ROLLBACK_
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 ?
Changed in percona-server: | |
importance: | Undecided → Medium |
status: | Confirmed → Triaged |
assignee: | Valentine Gostev (longbow) → nobody |
Changed in percona-server: | |
assignee: | nobody → Oleg Tsarev (tsarev) |
tags: | added: userstats |
Changed in percona-server: | |
status: | Triaged → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
Did you see warning at building?
"export LIBS=-lrt" is needed for linux.
> if (opt_userstat_ running) { CLOCK_THREAD_ CPUTIME_ ID, &tp))) 1000000000. 0+tp.tv_ nsec;
>#ifdef HAVE_CLOCK_GETTIME
> /* get start cputime */
> if (!(cputime_error = clock_gettime(
> start_cpu_nsecs = tp.tv_sec*
>#else
>#warning : HAVE_CLOCK_GETTIME is disabled.
>#warning : Most systems require librt library to use the function clock_gettime().
>#warning : Did you set environment when ./configure ? (e.g. "export LIBS=-lrt" for sh)
>#endif