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@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.