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

            Ascending order - Click to sort in descending order
            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.6 [ 29515 ]
            Fix Version/s 11.6.1 [ 29847 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.6.1 [ 29847 ]
            Fix Version/s 11.6 [ 29515 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            Roel Roel Van de Paar made changes -
            marko Marko Mäkelä made changes -
            nikitamalyavin Nikita Malyavin made changes -

            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.