-
Thirunarayanan Balathandayuthapani authored
READ THE INDEX APPLIED BY UNCOMMITTED ROWS. Problem: ======= row_search_mvcc() does whole table traversal for range query even though the end range is passed. Whole table traversal happens when the record is not with in transaction read view. Solution: ======== Convert the innodb last record of page to mysql format and compare with end range if the traversal of row_search_mvcc() exceeds 100, no ICP involved. If it is out of range then InnoDB can avoid the whole table traversal. Reviewed-by:
Jimmy <Yang<jimmy.yang@oracle.com> Reviewed-by:
Knut <Hatlen<knut.hatlen@oracle.com> RB: 14634
Thirunarayanan Balathandayuthapani authoredREAD THE INDEX APPLIED BY UNCOMMITTED ROWS. Problem: ======= row_search_mvcc() does whole table traversal for range query even though the end range is passed. Whole table traversal happens when the record is not with in transaction read view. Solution: ======== Convert the innodb last record of page to mysql format and compare with end range if the traversal of row_search_mvcc() exceeds 100, no ICP involved. If it is out of range then InnoDB can avoid the whole table traversal. Reviewed-by:
Jimmy <Yang<jimmy.yang@oracle.com> Reviewed-by:
Knut <Hatlen<knut.hatlen@oracle.com> RB: 14634
Loading