maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

nice, i will include the information about lock innodb tables to your bug
request just to help a better explain at mysql docs

2014-09-23 8:50 GMT-03:00 Federico Razzoli <federico_raz@xxxxxxxx>:

> Thank you for your clarification, Elena. Based on this information, I find
> the MySQL manual confusing, so I have reported a bug:
>
> http://bugs.mysql.com/bug.php?id=74033
>
> Unless it turns out that I'm still missing something, I will also check
> the kb.
>
> Regards
> Federico
>
>
> --------------------------------------------
> Mar 23/9/14, Elena Stepanova <elenst@xxxxxxxxxxxxxxxx> ha scritto:
>
>  Oggetto: Re: [Maria-discuss] R: transactions and UNLOCK TABLES
>  A: "Federico Razzoli" <federico_raz@xxxxxxxx>,
> maria-discuss@xxxxxxxxxxxxxxxxxxx
>  Data: Martedì 23 settembre 2014, 11:51
>
>  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
>  @@in_transaction, @@autocommit;
>  >
>  +------------------+--------------+
>  > |
>  @@in_transaction | @@autocommit |
>  >
>  +------------------+--------------+
>  > |
>                0 |            1 |
>  > +------------------+--------------+
>  > 1 row in set (0.00 sec)
>  >
>  > MariaDB [test]>
>  CREATE OR REPLACE TABLE t (c INT) ENGINE = MEMORY;
>  > Query OK, 0 rows affected (0.12 sec)
>  >
>  > MariaDB [test]>
>  LOCK TABLE t WRITE;
>  > Query OK, 0 rows
>  affected (0.00 sec)
>  >
>  > MariaDB [test]> START TRANSACTION;
>  > Query OK, 0 rows affected (0.00 sec)
>
>  "Beginning a transaction
>  causes table locks acquired with LOCK TABLES to
>  be released, as though you had executed UNLOCK
>  TABLES."
>
>  http://dev.mysql.com/doc/refman/5.5/en/commit.html
>
>  >
>  >
>  MariaDB [test]> INSERT INTO t VALUES (1);
>  > Query OK, 1 row affected (0.01 sec)
>  >
>  > MariaDB [test]>
>  UNLOCK TABLES;
>  > Query OK, 0 rows
>  affected (0.00 sec)
>
>  So,
>  this UNLOCK is not actually doing anything.
>
>  Regards,
>  Elena
>
>  >
>  > MariaDB [test]> SELECT
>  @@in_transaction;
>  >
>  +------------------+
>  > | @@in_transaction
>  |
>  > +------------------+
>  > |                1 |
>  > +------------------+
>  >
>  1 row in set (0.00 sec)
>  >
>  >
>  > Regards
>  > Federico
>  >
>  >
>  >
>  _______________________________________________
>  > 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
>  >
>
>
> _______________________________________________
> 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
SPAEmpresarial
Eng. Automação e Controle