MyRocks - missing server optimizer patch for ICP

Bug #1672871 reported by George Ormond Lorch III on 2017-03-14
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.6
Fix Released
Medium
George Ormond Lorch III
5.7
Fix Released
Medium
George Ormond Lorch III

Bug Description

rocksdb.bloomfilter3 fails due to missing server patch introduced in upstream Facebook MySQL here https://github.com/facebook/mysql-5.6/commit/723bfc97c7f7309c531c410133be3acd073f8129

This patch also impacts TokuDB. Immediately tokudb.bugs.simple_icp and tokudb.bugs.db233 fail. TokuDB can actually make use of this patch to improve ICP descending range scan performance and is the reason tokudb.bugs.simple_icp fails, it is getting a better result out of the descending range scan.

See also MYR-63

tags: added: myrocks tokudb
George Ormond Lorch III (gl-az) wrote :

Introducing this patch invalidates the need for the changes here https://github.com/percona/percona-server/pull/474 to fix https://tokutek.atlassian.net/browse/DB-233 as now end_range is going to be set by the optimizer prior to the descending scan reaching the end key.

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1794

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers