MySQL Forums
Forum List  »  InnoDB

Re: Enhancing MVCC ReadView Scalability
Posted by: Abhimanyu Singh
Date: January 15, 2025 07:33AM

The first major improvement is the enhancement of the MVCC ReadView data structure.

Performance comparison tests were conducted to evaluate the effectiveness of the MVCC ReadView optimization. The figure below shows a comparison of TPC-C throughput with varying concurrency levels, before and after modifying the MVCC ReadView data structure.
The second major improvement we made is addressing the double latch problem, where "double latch" refers to the requirement for the global trx-sys latch by both view_open and view_close service.

Options: ReplyQuote


Subject
Views
Written By
Posted
1001
September 03, 2024 08:09AM
403
September 03, 2024 07:19PM
428
September 04, 2024 05:44PM
Re: Enhancing MVCC ReadView Scalability
95
January 15, 2025 07:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.