maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #01853
Re: transactions and UNLOCK TABLES
I would never use LOCK TABLES on InnoDB, look again my first test case and you'll see that it's different from what documentation says :)
Federico
--------------------------------------------
Mar 23/9/14, Roberto Spadim <roberto@xxxxxxxxxxxxx> ha scritto:
Oggetto: Re: [Maria-discuss] transactions and UNLOCK TABLES
A: "Federico Razzoli" <federico_raz@xxxxxxxx>
Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Data: Martedì 23 settembre 2014, 01:46
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_raz@xxxxxxxx>:
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 <roberto@xxxxxxxxxxxxx>
ha scritto:
Oggetto: Re: [Maria-discuss] transactions and UNLOCK
TABLES
A: "Federico Razzoli" <federico_raz@xxxxxxxx>
Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>,
"maria-docs" <maria-docs@xxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
--
Roberto Spadim
SPAEmpresarialEng. Automação e
Controle
References
