Planet MySQL

Displaying posts with tag: auto_inc lock (reset)

May

2011

Posted by Ovais Tariq on Sat 14 May 2011 20:48 UTC
Tags:

Replication, Notes, locking, auto_increment, MVCC, row-level locking, mysql resources, innodb vs myisam, row-based, statement-based, read-lock, locking reads, shared locks, MySQL, auto_inc lock, concurrent inserts, exclusive locks, innodb locking, innodb_autoinc_lock_mode, lock priority, myisam locking, write locks

This is another article in a series of articles titled "A few notes ..." in which I will be posting some important information about locking concepts, different types of locks and what locks table engines support. Just like the previous article, the purpose of this article is to highlight important aspects that you should have in the back of your mind when developing applications.

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links