Details

    • Task
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Galera
    • None

    Description

      to help fasten batch insertions or cluster initalisation using myloader or multihreaded mariadb-dump , it would be great to have the session based option to allow for out of order committing :

      https://mariadb.com/kb/en/wsrep_provider_options/#replcommit_order

      repl.commit_order
      Description: Whether or not out-of-order committing is permitted, and under what conditions. By default it is not permitted, but setting this can improve parallel performance.
      0 BYPASS: No commit order monitoring is done (useful for measuring the performance penalty).
      1 OOOC: Out-of-order committing is permitted for all transactions.
      2 LOCAL_OOOC: Out-of-order committing is permitted for local transactions only.
      3 NO_OOOC: Out-of-order committing is not permitted at all.
      Dynamic: Yes
      Default: 3

      set wsrep_provider_options="repl.commit_order=2";

      Attachments

        Activity

          No workflow transitions have been executed yet.

          People

            Unassigned Unassigned
            SylvainArbaudie Sylvain ARBAUDIE
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.