MySQL Concurrency by Jesper Wisborg Krogh

Author:Jesper Wisborg Krogh
Language: eng
Format: epub
ISBN: 9781484266526
Publisher: Apress

Here only the two record locks on the secondary index and primary key are needed .

Tip

For a comprehensive list of the locks taken by various statements with and without unique indexes in InnoDB, see https://dev.mysql.com/doc/refman/en/innodb-locks-set.html.

Finally, roll back and drop the test tables:-- Connection 1

Connection 1> ROLLBACK;

Query OK, 0 rows affected (0.0714 sec)

Connection 1> DROP TABLE world._tmp_city1;

Query OK, 0 rows affected (0.7642 sec)

-- Connection 2

Connection 2> ROLLBACK;

Query OK, 0 rows affected (0.1038 sec)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.