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

    XMLWordPrintable

    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;

       

        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