Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-4723

PURGE CHANGED_PAGE_BITMAPS doesn't work when innodb_data_home_dir used

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.5.61-38.13, 5.6.41-84.1, 5.7.23-23
    • Component/s: None
    • Labels:

      Description

      For PS 5.7 PURGE CHANGED_PAGE_BITMAPS doesn't work when innodb_data_home_dir is used to move innodb's data outside of mysqls' data directory.

       

      Steps to reproduce:

      1. Run MySQL with:

      [mysqld]
      innodb_track_changed_pages=1
      innodb_max_bitmap_file_size = 4096
      innodb_data_home_dir = /test01/innodb

      2. Generate some inserts

      3. Execute 

      PURGE CHANGED_PAGE_BITMAPS BEFORE lsn;

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                yura.sorokin Yura Sorokin
                Reporter:
                iwo.panowicz Iwo Panowicz
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 days, 4 hours
                  4d 4h