ha scritto:
>
> Oggetto: Re: [Maria-discuss] R: transactions and UNLOCK TABLES
> A: "Federico Razzoli" ,
> maria-discuss@lists.launchpad.net
> Data: Martedì 23 settembre 2014, 11:51
>
> Hi Federico,
>
> On 23.09.2014 12:50, Federico
> Razzoli wrote:
> >
+1 =)
mysql manual sometimes don't help, that's why i really prefer mariadb kb
i think that many years ago mysql implement this nontransactional like
locks to innodb just to allow guys porting from myisam to innodb using old
apps without rewriting the lock/unlock to begin/commit
if you are using
erico
Mar 23/9/14, Elena Stepanova ha scritto:
Oggetto: Re: [Maria-discuss] R: transactions and UNLOCK TABLES
A: "Federico Razzoli" ,
maria-discuss@lists.launchpad.net
Data: Martedì 23 settembre 2014, 11:51
Hi Federico,
On 23.09.2014 12:50, Federico
Razzoli
Hi Federico,
On 23.09.2014 12:50, Federico Razzoli wrote:
Let's make the snippet simpler. Only one table, non-transactional, please look
at the difference from what docs say and the real behaviour. If one could
explain what UNLOCK TABLES exactly does, it would be great.
MariaDB [test]> SELECT
Let's make the snippet simpler. Only one table, non-transactional, please look
at the difference from what docs say and the real behaviour. If one could
explain what UNLOCK TABLES exactly does, it would be great.
MariaDB [test]> SELECT @@in_transaction, @@autocommit;
+--+
5 matches
Mail list logo