Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Displaying posts with tag: innodb_autoinc_lock_mode (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.

The latest from the MySQL community

Get Started Contributing

Events

MySQL Showcase

Top Authors

Oracle MySQL Blogs

Vendor Blogs

MySQL Links