[MDEV-24090] Optimize buf_page_optimistic_get() Created: 2020-11-02  Updated: 2021-05-25

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5, 10.6
Fix Version/s: 10.5

Type: Bug Priority: Major
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Unresolved Votes: 1
Labels: performance

Issue Links:
Relates
relates to MDEV-15053 Reduce buf_pool_t::mutex contention Closed
relates to MDEV-21329 InnoDB: Failing assertion: lock->lock... Closed
relates to MDEV-22871 Contention on the buf_pool.page_hash Closed

 Description   

In 10.5, MDEV-21329 patch introduces functor to do get btr_page_optimistic_get().
Basically functor basically checks whether the page is in buffer pool and it is the same page, takes hash lock for the respective page id. But in 10.5 alone, InnoDB does check the page id and page state, takes page hash lock again. The earlier optimizations that were implemented in MDEV-15053 and MDEV-22871 would allow this to be improved further.
Generated at Thu Feb 08 09:27:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.