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

ANALYZE FORMAT=JSON INSERT doesn't display innodb statistics

    XMLWordPrintable

Details

    Description

      "r_engine_stats" section is missing in analyze json output ,eventhough statistics present in slow-query-log 

      create table q(a int);
      		 
      analyze format=json insert into q1 values (1) ,(4),(2);
      		 
      -----------------------------------------------------+
      		 
      | ANALYZE                                                                                                                                                        |
      		 
      +----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      | {
      		 
        "query_optimization": {
      		 
          "r_total_time_ms": 0.180694024
      		 
        },
      		 
        "query_block": {
      		 
          "select_id": 1,
      		 
          "table": {
      		 
            "table_name": "q1"
      		 
          }
      		 
        }
      		 
      } |
      		 
      +---------

      slow-query-log:

      1. Pages_accessed: 8 Pages_read: 0 Pages_prefetched: 0 Pages_updated: 9 Old_rows_read: 0
      2. Pages_read_time: 0.0000 Engine_time: 0.0000

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37753 lock_sec_rec_some_has_impl() unnecessarily fetches history and a freed BLOB

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-31577 Make ANALYZE FORMAT=JSON print innodb stats

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              mariadb-pavithrapandith Pavithra Pandith
              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.