[MDEV-25281] Switch to use non-atomic (vs atomic) distributed counter to track page-access counter Created: 2021-03-29  Updated: 2021-03-29  Resolved: 2021-03-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: 10.6.0

Type: Task Priority: Major
Reporter: Krunal Bauskar Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Attachments: PNG File result.png    
Issue Links:
Relates
relates to MDEV-21212 buf_page_get_gen -> buf_pool->stat.n_... Closed

 Description   
  • As part of MDEV-21212 we switched to use distributed counter (default to atomic) for tracking page access (n_page_get).
  • Originally the counter was non-atomic and so represented an approximate value of the page access. Using the same analogy we could continue to use a non-atomic distributed counter that helps get an approximate count.
  • this change helps improve performance slightly in the range of 3-8% especially in more contention cases.

 Comments   
Comment by Krunal Bauskar [ 2021-03-29 ]

Benchmarking using the current baseline 10.6 (#e1a514d5) and patched version

Comment by Marko Mäkelä [ 2021-03-29 ]

Thank you for the contribution!

Generated at Thu Feb 08 09:36:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.