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.