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

Implementation of user statements for handling the xtradb changed page bitmaps

Details

    • 10.1.6-1

    Description

      There are user statements available at Percona server for maintenance the bitmap files that keep the changed pages.
      These statements are not available in MariaDB.
      reference:
      http://www.percona.com/doc/percona-server/5.6/management/changed_page_tracking.html#changed-page-tracking-statements

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-10798 Implement ALL user statements for handling xtradb changed page bitmaps (xdb files)

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14177 Document comand FLUSH CHANGED_PAGE_BITMAPS

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 5 older comments
            serg Sergei Golubchik added a comment -

            See https://mariadb.com/kb/en/mariadb/information-schema-plugins-show-and-flush-statements/

            For I_S table to support FLUSH, it must implement a reset_table callback.

            serg Sergei Golubchik added a comment - See https://mariadb.com/kb/en/mariadb/information-schema-plugins-show-and-flush-statements/ For I_S table to support FLUSH, it must implement a reset_table callback.
            jplindst Jan Lindström (Inactive) added a comment -

            commit b7ff2f1b59c42171ff50fc682e8f723f0713d688
            Author: Jan Lindström <jan.lindstrom@mariadb.com>
            Date: Tue Jun 23 14:36:24 2015 +0300

            MDEV-7472: Implementation of user statements for handling the xtradb changed page bitmaps

            Introduce a new dummy INFORMATION_SCHEMA.CHANGED_PAGE_BITMAPS table to XtraDB
            with reset_table callback to allow FLUSH NO_WRITE_TO_BINLOG CHANGED_PAGE_BITMAPS
            to be called from innobackupex.

            jplindst Jan Lindström (Inactive) added a comment - commit b7ff2f1b59c42171ff50fc682e8f723f0713d688 Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Tue Jun 23 14:36:24 2015 +0300 MDEV-7472 : Implementation of user statements for handling the xtradb changed page bitmaps Introduce a new dummy INFORMATION_SCHEMA.CHANGED_PAGE_BITMAPS table to XtraDB with reset_table callback to allow FLUSH NO_WRITE_TO_BINLOG CHANGED_PAGE_BITMAPS to be called from innobackupex.
            joffrey92 Joffrey MICHAIE added a comment -

            Hi,

            Sorry to re-open this, I see that the following feature has been implemented:

            • FLUSH CHANGED_PAGE_BITMAPS
              But what about the 2 following:
            • RESET CHANGED_PAGE_BITMAPS
            • PURGE CHANGED_PAGE_BITMAPS BEFORE <lsn>
              ?
              I am especially interested in the last one, as it is used generally in post backup scripts to safely remove unneeded xdb files.

            Regards,
            Joffrey

            joffrey92 Joffrey MICHAIE added a comment - Hi, Sorry to re-open this, I see that the following feature has been implemented: FLUSH CHANGED_PAGE_BITMAPS But what about the 2 following: RESET CHANGED_PAGE_BITMAPS PURGE CHANGED_PAGE_BITMAPS BEFORE <lsn> ? I am especially interested in the last one, as it is used generally in post backup scripts to safely remove unneeded xdb files. Regards, Joffrey
            hydrapolic Tomáš Mózes added a comment - - edited

            As Joffrey, I'd also like ask what about RESET CHANGED_PAGE_BITMAPS and PURGE
            CHANGED_PAGE_BITMAPS BEFORE. It would really help us with the incremental backups in MariaDB.

            hydrapolic Tomáš Mózes added a comment - - edited As Joffrey, I'd also like ask what about RESET CHANGED_PAGE_BITMAPS and PURGE CHANGED_PAGE_BITMAPS BEFORE. It would really help us with the incremental backups in MariaDB.
            joffrey92 Joffrey MICHAIE added a comment -

            Hi,

            to avoid polluting this task, I have created https://jira.mariadb.org/browse/MDEV-10798
            You are welcome to follow/vote on it.

            Regards,
            Joffrey

            joffrey92 Joffrey MICHAIE added a comment - Hi, to avoid polluting this task, I have created https://jira.mariadb.org/browse/MDEV-10798 You are welcome to follow/vote on it. Regards, Joffrey

            People

              jplindst Jan Lindström (Inactive)
              ivan.stoykov@skysql.com Stoykov (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              9 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.