If you’ve been working with MySQL for some time, you have probably heard the terms “table-level locking” and “row-level locking”. These terms refer to the lock granularity in MySQL - in this blog we will...

One of the most popular InnoDB errors is InnoDB lock wait timeout exceeded, for example: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction The above simply means the transaction has reached the...

Working with databases, concurrency control is the concept that ensures that database transactions are performed concurrently without violating data integrity. There is a lot of theory and different approaches around this concept and how to...