[MDEV-22680] InnoDB trx_sys improvements Created: 2020-05-23  Updated: 2024-01-19

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: None

Type: Epic Priority: Major
Reporter: Sergey Vojtovich Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 2
Labels: performance

Issue Links:
Problem/Incident
is caused by MDEV-14638 Replace trx_sys_t::rw_trx_set with LF... Closed
is caused by MDEV-14756 Remove trx_sys_t::rw_trx_list Closed
is caused by MDEV-15019 InnoDB: store ReadView on trx Closed
is caused by MDEV-15059 Misc small InnoDB scalability fixes Closed
is caused by MDEV-15104 Remove trx_sys_t::rw_trx_ids and trx_... Closed
is caused by MDEV-15246 InnoDB: Unknown error code 20: Requir... Closed
Epic Name: InnoDB trx_sys improvements

 Description   

This issue is created for tracking a few remaining/discovered issues after the big InnoDB trx_sys refactoring.

The following don't yet have corresponding jira task:

  • decouple ReadView::m_low_limit_no - only used by purge, regular views should not have to snapshot it
  • optimise busy waiting in trx_sys_t::snapshot_ids() - it is quite high in profile already
Generated at Thu Feb 08 09:16:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.