Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-773

LP:611878 - user_statistics.busy_time is unreliable

    XMLWordPrintable

Details

    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

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-775 LP:1018694 - CPU_TIME counter from USER_STATISTICS gets wrong after some uptime

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-673 LP:706991 - incorrect Bytes_received in user_statistics table

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4578 information_schema.processlist reports incorrect value for Time (2147483647)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              Unassigned Unassigned
              damientournoud Damien Tournoud (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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