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

Make ANALYZE FORMAT=JSON print innodb stats

    XMLWordPrintable

Details

    Description

      MDEV-31558 adds InnoDB engine stats into the slow query log.

      It would be nice to include it into ANALYZE FORMAT=JSON output, too.

      User interface: Extra info is printed in ANALYZE FORMAT=JSON output.

      It is printed on per-table basis. table.r_engine_stats will is an object with member counters.

      In current patch, it looks like this:

              "table": {
      		 
                "table_name": "t1",
      		 
                ...
      		 
                "r_engine_stats": {
      		 
                  "pages_accessed": integer,
      		 
                  "pages_updated" : integer,
      		 
                  "pages_read_count" : integer,
      		 
                  "pages_read_time_ms" : double_val,
      		 
                  "old_rows_read" : integer,
      		 
                },
      		 
                ...

      Only non-zero members are printed.

      mysql-test/include/analyze-format.inc is adjusted to mask the entire contents of r_engine_stats.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31764 ASAN use-after-poison in trace_engine_stats upon ANALYZE FORMAT=JSON

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32286 ANALYZE displays a huge number of InnoDB secondary index pages_accessed

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Task - A task that needs to be done. MDEV-31558 Add InnoDB engine information to the slow query log

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34190 ANALYZE: r_engine_stats shows unrealistically low pages_read_count

          • Major - Major loss of function.
          • Closed

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.