[Enhancement] reduce lock contention in DatabaseTransactionMgr #53642
Description
Search before asking
- I had searched in the issues and found no similar issues.
Description
The lock granularity in DatabaseTransactionMgr is coarse, leaving significant room for optimization. By refining the locking mechanism and combining it with batched editlog writes, the write TPS for different tables under the same database can be greatly improved.
Solution
Actually, transactions on same table are serialized by the table lock. The lock in DatabaseTransactionMgr is used to protect containers in DatabaseTransactionMgr. However, we write edit log in the lock.
- move edit log out of the lock.
- avoid deadlock.
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct