Skip to content

MVCC 与覆盖索引 | 大水怪 #1

@WtMonster

Description

@WtMonster

https://wtmonster.github.io/2022/08/25/MVCC%E4%B8%8E%E8%A6%86%E7%9B%96%E7%B4%A2%E5%BC%95/?#more

近期看到这样一个问题:走覆盖索引不用回表,但是如何用MVCC判断可见性?因为二级索引上没有隐藏列trx_id和roll_ptr。而MVCC是基于trx_id和roll_ptr。那走覆盖索引如何判断是否可见呢?

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions