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

Port MyRocks fix of Index Condition Pushdown (ICP)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.19-10, Not 5.6.x, Not 5.7.x
    • Fix Version/s: 8.0.20-11
    • Component/s: MyRocks
    • Labels:
      None

      Description

      Fix Index Condition Pushdown (ICP) issues in MyRocks with Percona Server 8.0 that were introduced when porting MyRocks to Percona Server 8.0.
      End range needs to be set for bloom filter to take effect.

      Facebook already has fixes for this that need ported to MyRocks with Percona Server 8.0:
      https://github.com/facebook/mysql-5.6/commit/5dfbcb248c7cdc6c2eaa7c53254befc7d29695d4
      https://github.com/facebook/mysql-5.6/commit/d0a87930124e2fb00949bec570892ab92f5d79c6 (should be skipped)
      https://github.com/facebook/mysql-5.6/commit/52585179a20a00fc9033a7d4f88be6e89517eef0
      https://github.com/facebook/mysql-5.6/commit/d59836c6f53da14085e45d6ae772e90429a5d04b (no need to port)

        Attachments

          Activity

            People

            Assignee:
            przemyslaw.skibinski Przemyslaw Skibinski
            Reporter:
            przemyslaw.skibinski Przemyslaw Skibinski
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 6 hours
                6h

                  Smart Checklist