well from kb what i understand is: to use unlock with innodb (the engine you use with both tables), you should SET innodb_table_locks=1; SET autocommit=0; after that any LOCK/UNLOCK with innodb tables inside a transaction will commit the transaction
try again using innodb_table_locks, and autocommit variables 2014-09-22 19:51 GMT-03:00 Federico Razzoli <federico_...@yahoo.it>: > No, becuase the first test case I've posted shows that the reality is > different... :) > I'm just asking to explain the exact interaction between trx and UNLOCK, > because I need to know if statements I use are safe. > > Federico > > > -------------------------------------------- > Mar 23/9/14, Roberto Spadim <robe...@spadim.com.br> ha scritto: > > Oggetto: Re: [Maria-discuss] transactions and UNLOCK TABLES > A: "Federico Razzoli" <federico_...@yahoo.it> > Cc: "Maria Discuss" <maria-discuss@lists.launchpad.net>, "maria-docs" < > maria-d...@lists.launchpad.net> > Data: Martedì 23 settembre 2014, 00:14 > > better > explained at mariadb kbhttps:// > mariadb.com/kb/en/mariadb/documentation/sql-commands/transactions/lock-tables-and-unlock-tables/#limitations > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
