MySQL / MariaDB DBA

Locking, Concurrency & Transactions

Question

Shared versus exclusive row locks: how do compatibility and use differ?

Answer

Shared locks permit concurrent shared locks but block exclusive requests; exclusive locks block both. Use shared locks for locking reads and exclusive locks for updates or deletes. Applies to MySQL and MariaDB.

This is 11 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples