← Back to team overview

maria-discuss team mailing list archive

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 :)


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.
 Mar 23/9/14, Roberto Spadim <roberto@xxxxxxxxxxxxx>
 ha scritto:
  Oggetto: Re: [Maria-discuss] transactions and UNLOCK
  A: "Federico Razzoli" <federico_raz@xxxxxxxx>
  Cc: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>,
 "maria-docs" <maria-docs@xxxxxxxxxxxxxxxxxxx>
  Data: Martedì 23 settembre 2014, 00:14
  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