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 ha scritto:
Oggetto: Re: [Maria-discuss] transactions and UNL
t 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
>>
>>
>> ----------------
>&
are safe.
>
> Federico
>
>
>
> Mar 23/9/14, Roberto Spadim ha scritto:
>
> Oggetto: Re: [Maria-discuss] transactions and UNLOCK TABLES
> A: "Federico Razzoli"
> Cc: "Maria Discuss" , "maria-docs&q
rto Spadim ha scritto:
Oggetto: Re: [Maria-discuss] transactions and UNLOCK TABLES
A: "Federico Razzoli"
Cc: "Maria Discuss" , "maria-docs"
Data: Martedì 23 settembre 2014, 00:14
better
explained at mariadb
kbhttps://mariadb.com/kb/en/mariadb/documentati
better explained at mariadb kb
https://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
Un
this don't work too:
LOCK TABLE t WRITE;
BEGIN;
SELECT @@in_transaction; (return 1)
UNLOCK TABLES;
SELECT @@in_transaction; (return 1)
maybe a wrong documentation 'bug'
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@
LOCK always commits current transaction. This is documented. But I wasn't able
to commit a transaction with UNLOCK. Perhaps I'm missing something?
Federico
Lun 22/9/14, Roberto Spadim ha scritto:
Oggetto: Re: [Maria-discuss] transa
good question, at least here the implicity commit is with LOCK table and
not unlock table
CREATE OR REPLACE TABLE m (c INT) ENGINE = InnoDB;
CREATE OR REPLACE TABLE t (c INT) ENGINE = myisam; (must be nontransaction
table)
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
BEGIN;
SELECT @@in_transacti
In this MySQL manual page:
http://dev.mysql.com/doc/refman/5.6/en/implicit-commit.html
I read:
"UNLOCK TABLES commits a transaction only if any tables currently have been
locked with LOCK TABLES to acquire nontransactional table locks."
However, this doesn't seem to be the case, at least with Ma
9 matches
Mail list logo
