[MDEV-773] LP:611878 - user_statistics.busy_time is unreliable - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 5.2.14
Fix Version/s: None
Component/s: None
Labels:
- Launchpad
- user_statistics

Description

I was testing MariaDB 5.2.1-beta (on Debian 5.0), and bumped into the following weird behavior of user_statistics.busy_time: the value of this column seems completely unreliable and randomly increases at some points in time:

MariaDB [(none)]> SELECT CONNECTED_TIME,BUSY_TIME,CPU_TIME FROM information_schema.user_statistics WHERE USER='core_d7';

+----------------+------------------+------------------+

| CONNECTED_TIME | BUSY_TIME        | CPU_TIME         |

+----------------+------------------+------------------+

|           2887 | 36893488147880.9 | 237.741877899973 |

later...

|           2919 | 36893488147887.3 | 241.586389299972 |

later...

|           2921 | 36893488147888.2 | 242.004482199972 |

and now:

|           3144 | 55340232221635 | 268.829147599973 |

I don't have any additional information information at this point, just wanted to report the behavior in case it rings a bell for someone.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

LPexportBug611878.xml
9 kB
2012-10-03 11:32

Issue Links

relates to

MDEV-775 LP:1018694 - CPU_TIME counter from USER_STATISTICS gets wrong after some uptime

Open

MDEV-673 LP:706991 - incorrect Bytes_received in user_statistics table

Open

MDEV-4578 information_schema.processlist reports incorrect value for Time (2147483647)

Closed

Activity

People

Assignee:: Unassigned

Reporter:: Damien Tournoud (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2010-07-30 22:03

Updated:: 2020-05-28 11:01

Git Integration

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