Tag Archives: mysql

Transactions and Locks in MySQL

Refer: https://stackoverflow.com/questions/61212438/why-do-we-need-to-lock-a-mysql-table-during-select-when-beginning-a-transaction/ TL;DR: MySQL docs are wrong Transactions act like a try-catch block. They don’t provide protection against concurrency. If something fails in a transaction, it can be rolled back to undo pending operations that were not committed. To handle … Continue reading

Posted in Software | Tagged | Leave a comment