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.hod...@continuent.com> 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@lists.launchpad.net > 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. _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
