maria-developers team mailing list archive

[Daniel Black <daniel.black@xxxxxxxxxxxxx>]

Perhaps slightly more useful would be a SET SESSION inherit_transaction=<process_id>

Use cases:

* Multi threaded backup on mysqldump --single-transaction with each thread fetching a table
* An application that wants do a number of read/write queries in parallel all isolation level.

A commit or rollback will apply to all transactions.


----- Original Message -----
> Robert Hodges <robert.hodges@xxxxxxxxxxxxxx> writes:
> 
> > Thanks Kristian. That's a nice optimization that is difficult to do outside
> > the DBMS engine.
> 
> Indeed. We might be able to expose it to you, though. Like SET SESSION
> wait_for_other_commit=<processid>, or something.
> 
>  - Kristian.
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-developers
> Post to     : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help   : https://help.launchpad.net/ListHelp
> 

-- 
-- 
Daniel Black, Engineer @ Open Query (http://openquery.com.au)
Remote expertise & maintenance for MySQL/MariaDB server environments.