MVCC
Multi-Version Concurrency Control is a database concurrency control mechanism that maintains multiple versions of data so that reads do not block writes and writes do not block reads, preserving transaction isolation while maintaining high concurrency performance.
Timeline (last 90 days)
OLTP系统几乎都要求严格ACID,用行级锁或MVCC来管理并发。
多版本并发控制(MVCC)通过生成数据新版本并保留旧版本,使读操作可根据事务开始时间选择一致性快照而无需等待写操作完成。
在 HTAP 场景中,MVCC 的版本链和可见性判断机制使分析查询能够读取最新已提交的数据版本,而无需停止事务写入,从而消除读写冲突并避免 ETL 同步延迟。
MVCC (Multi-Version Concurrency Control) avoids read-write blocking by generating a new version for each write operation and having read operations read a consistent snapshot.
All Facts (4)
OLTP系统几乎都要求严格ACID,用行级锁或MVCC来管理并发。
50%Unverified多版本并发控制(MVCC)通过生成数据新版本并保留旧版本,使读操作可根据事务开始时间选择一致性快照而无需等待写操作完成。
50%Unverified在 HTAP 场景中,MVCC 的版本链和可见性判断机制使分析查询能够读取最新已提交的数据版本,而无需停止事务写入,从而消除读写冲突并避免 ETL 同步延迟。
50%UnverifiedMVCC (Multi-Version Concurrency Control) avoids read-write blocking by generating a new version for each write operation and having read operations read a consistent snapshot.
50%