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

Query stats for compression based on TRIM size

Details

    Description

      Need support for query stats to provide statistics on the various TRIM operations performed for the page-compression/NVM Compression workload.

      For the 2K format block-size it shows none
      =======
      Innodb_page_compression_saved 364564353024
      Innodb_page_compression_trim_sect512 0
      Innodb_page_compression_trim_sect4096 0
      ========

      For the 512B and 4K format block-size it shows the following
      =======
      Innodb_page_compression_saved 284889649152
      Innodb_page_compression_trim_sect512 0
      Innodb_page_compression_trim_sect4096 13063475
      =======

      It should support block-size 512B, 1K, 2K, 4K at this time.

      Attachments

        Activity

          revno: 4002
          committer: Jan Lindström <jplindst@mariadb.org>
          branch nick: 10.0-FusionIO-release
          timestamp: Wed 2014-11-12 10:06:39 +0200
          message:
          MDEV-7088: Query stats for compression based on TRIM size

          Analysis: Status variables were missing from innodb_status_variables
          array.

          Fix: Add missing status variables to the array.

          jplindst Jan Lindström (Inactive) added a comment - revno: 4002 committer: Jan Lindström <jplindst@mariadb.org> branch nick: 10.0-FusionIO-release timestamp: Wed 2014-11-12 10:06:39 +0200 message: MDEV-7088 : Query stats for compression based on TRIM size Analysis: Status variables were missing from innodb_status_variables array. Fix: Add missing status variables to the array.

          commit ea8322687254fad00143ff7850a67ea8c7f0027e
          Author: Jan Lindström <jan.lindstrom@skysql.com>
          Date: Wed Nov 12 15:37:52 2014 +0200

          MDEV-7088: Query stats for compression based on TRIM size

          Analysis: Status variables were missing from innodb_status_variables
          array.

          Fix: Add missing status variables to the array.

          jplindst Jan Lindström (Inactive) added a comment - commit ea8322687254fad00143ff7850a67ea8c7f0027e Author: Jan Lindström <jan.lindstrom@skysql.com> Date: Wed Nov 12 15:37:52 2014 +0200 MDEV-7088 : Query stats for compression based on TRIM size Analysis: Status variables were missing from innodb_status_variables array. Fix: Add missing status variables to the array.

          People

            jplindst Jan Lindström (Inactive)
            Dhananjoy.Das Dhananjoy
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.