In this session I will cover many of the various problems that databases need to account for in order to allow multiple users to access data at once.

Attendees will also get a better understanding of various database errors, and know how they are expected to be handled by applications. Examples will use MySQL 5.6, but cover theory that is 90% applicable to all databases.

Topics covered include table/row locks, MVCC, deadlocks & lock waits, transactions and isolation levels.