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

USER_STATISTICS.BUSY_TIME is in microseconds

Details

    Description

      in 10.11.11 and 11.4.5 USER_STATISTICS.BUSY_TIME and USER_STATISTICS.CPU_TIME are shown in microseconds, not seconds

      caused by

      commit 95975b921e9 (HEAD)
      		 
      Author: Michael Widenius <monty@mariadb.com>
      		 
      Date:   Fri Dec 27 19:26:55 2024 +0200
      		 
       
      		 
          MDEV-35720 Add query_time to statistics
      		 
          
          Added Query_time (total time spent running queries) to status_variables.
      		 
          
          Other things:
      		 
          - Added SHOW_MICROSECOND_STATUS type that shows an ulonglong variable
      		 
            in microseconds converted to a double (in seconds).
      		 
          - Changed Busy_time and Cpu_time to use SHOW_MICROSECOND_STATUS, which
      		 
            simplified the code and avoids some double divisions for each query.
      		 
          
          Reviewed-by: Sergei Golubchik <serg@mariadb.org>

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-35720 Add query_time to statistics

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Sergei Golubchik made transition -
            Open In Progress
            		2m 35s 1
            Sergei Golubchik made transition -
            In Progress Stalled
            		11s 1
            Sergei Golubchik made transition -
            Stalled In Testing
            		8m 34s 1
            Sergei Golubchik made transition -
            In Testing Closed
            		29m 16s 1

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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