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

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

    XMLWordPrintable

Details

    Description

      Hi there

      We collect user statistics and run "SELECT * FROM INFORMATION_SCHEMA.USER_STATISTICS; FLUSH USER_STATISTICS" every 5 minutes and then put received values to rrd databases. We noticed that after some uptime CPU_TIME counter goes mad and starts to show incredibly high usage values. After restarting MariaDB process it goes back to normal for some time. Please see attached graphs as examples. One can notice a huge drop down of CPU_TIME counter on both graphs. These are graphs for a random customer from two different MariaDB servers.

      Platform used: Debian Squeeze amd64, MariaDB 5.2.12-MariaDB-mariadb115~squeeze-log from official package.

      Attachments

        1. LPexportBug1018694_dbstdusercpu.png
          23 kB
          Rasmus Johansson
        2. LPexportBug1018694_dbstdusercpu2.png
          19 kB
          Rasmus Johansson
        3. LPexportBug1018694.xml
          9 kB
          Rasmus Johansson

        Issue Links

          Activity

            People

              Unassigned Unassigned
              antonkhalikov Anton Khalikov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.