dataroaring opened a new issue, #53642: URL: https://github.com/apache/doris/issues/53642
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) 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 - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
