Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
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";