Categories
Products
Technologies
Top Rated docs

April 13, 2021

Understanding Lock Granularity in MySQL

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...

March 11, 2020

How to Fix a Lock Wait Timeout Exceeded Error in MySQL

MySQL Enterprise Monitor is dead, let us help you determine your next move! One of the most common InnoDB errors is InnoDB lock wait timeout exceeded, for example: SQLSTATE[HY000]: General error: 1205 Lock wait timeout...

May 21, 2018

Understanding Deadlocks in MySQL & PostgreSQL

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...

Subscribe below to be notified of fresh posts