Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
erp5 erp5
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Labels
    • Labels
  • Merge requests 143
    • Merge requests 143
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Environments
  • Analytics
    • Analytics
    • CI/CD
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Graph
  • Jobs
  • Commits
Collapse sidebar
  • nexedi
  • erp5erp5
  • Merge requests
  • !1997

Open
Created Oct 07, 2024 by Kazuhiko Shiozaki@kazuhikoOwner
  • Report abuse
Report abuse

WIP: Switching transaction isolation automatically

  • Overview 14
  • Commits 15
  • Changes 10

This branch uses a single connection for catalog and start a transaction with REPEATABLE-READ or READ-COMMITTED isolation level, based on the first query. If the first query contains SELECT, REPEATABLE-READ is used. Otherwise READ-COMMITTED is used. For activity tables, READ-COMMITTED is always used.

Some exceptions:

  • z_get_table_schema: it can be called outside MariaDB transaction and is not couted as 'first SELECT' query.
  • z_getitem_by_path and z_getitem_by_uid: they are used only at the beginning of indexation, thus we force start READ-COMMITTED transaction.

With this branch, the code compatibility should be mostly kept.

duration_conflicts_deadlocks_graphs_7.svg

10.4
  duration: 11077.6
  deadlock: 5329

10.11
  duration: 20205.9
  deadlock: 129649

11.4
  duration: 18263.4
  deadlock: 72108

11.4-bis
  duration: 9774.21
  deadlock: 16775

11.4-unsafe
  duration: 9354.08
  deadlock: 6055

/cc @vpelletier, @jerome

Edited Oct 08, 2024 by Kazuhiko Shiozaki
Assignee
Assign to
Reviewer
Request review from
None
Milestone
None
Assign milestone
Time tracking
Source branch: feat/mariadb-11.4bis
GitLab Nexedi Edition | About GitLab | About Nexedi | 沪ICP备2021021310号-2 | 沪ICP备2021021310号-7