[ https://issues.apache.org/jira/browse/HBASE-24742?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17157791#comment-17157791 ]
Andrew Kyle Purtell edited comment on HBASE-24742 at 7/15/20, 1:35 AM: ----------------------------------------------------------------------- There is a regression in SKIP hint handling in branch-2, see HBASE-24637. Is this related? In the HBASE-24637 case the difference is not so much more comparisons on a hot path, which would be good to fix of course, no question, but a regression with wider scope with respect to reseeking (I/O) that causes, proportional to number of cells/columns, more work in the whole stack from file or blockcache to hfile reader up to SQM. I went out on vacation (and am still out) before tracking this down. I was/am planning a review of any commit that touches SQM and friends. This was a bit daunting because (I am guessing) the number of commits from circa 1.3 to 2.2 is more than a handful. Maybe not, that would be nice. Perhaps this issue finds it but I suspect more changes in this area were committed after HBASE-17958 and HBASE-19863. was (Author: apurtell): There is a regression in SKIP hint handling in branch-2, see HBASE-24637. Is this related? In the HBASE-24637 case the difference is not so much more comparisons on a hot path, which would be good to fix, but a regression with wider scope with respect to reseeking (I/O) that causes, proportional to number of cells/columns, more work in the whole stack from file or blockcache to hfile reader up to SQM. I went out on vacation (and am still out) before tracking this down. I was/am planning a review of any commit that touches SQM and friends. This was a bit daunting because (I am guessing) the number of commits from circa 1.3 to 2.2 is more than a handful. Maybe not, that would be nice. Perhaps this issue finds it but I suspect more changes in this area were committed after HBASE-17958 and HBASE-19863. > Improve performance of SKIP vs SEEK logic > ----------------------------------------- > > Key: HBASE-24742 > URL: https://issues.apache.org/jira/browse/HBASE-24742 > Project: HBase > Issue Type: Bug > Components: Performance, regionserver > Affects Versions: 3.0.0-alpha-1, 1.7.0, 2.4.0 > Reporter: Lars Hofhansl > Assignee: Lars Hofhansl > Priority: Major > Attachments: hbase-24742-branch-1.txt > > > In our testing of HBase 1.3 against the current tip of branch-1 we saw a 30% > slowdown in scanning scenarios. > We tracked it back to HBASE-17958 and HBASE-19863. > Both add comparisons to one of the tightest HBase has. > [~bharathv] -- This message was sent by Atlassian Jira (v8.3.4#803005)