Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-1149

LP #608027: CPU_TIME is UserStats is broken

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **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 ?

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: