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

Add page accessed and pages read from disk to table_stats

Details

    Description

      Add pages access and page read from disk to table stats.

      MDEV-31558 Add InnoDB engine information to the slow query log
      already collects this information from InnoDB.
      Note that for tables with foreign keys, page statistics will also include any
      pages access to foreign key tables. This cannot be easily fixed until foreign key
      handling is moved from inside InnoDB to the upper layer. However this disturbance
      in statistics should not make the statistics unusable.

      To be implemented to add PAGES_ACCESSED and PAGES_READ_FROM_DISK columns to table_stats

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34782 SIGSEGV in handler::update_global_table_stats in close_thread_table()

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34984 Assertion `length <= copy->to_length - 2' failed in void do_varstring2_no_truncation(const Copy_field*)

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34791 Redundant page lookups hurt performance

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

          Activity

            Transition Time In Source Status Execution Times
            Michael Widenius made transition -
            Open In Progress
            		3m 38s 1
            Sergei Golubchik made transition -
            In Progress Closed
            		5d 6h 48m 1

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.