Locking is an important concept in databases. They help regulate access to the data, so your SELECT queries return consistent results and DML and DDL statements leave the data and schema in a consistent state. For the data, there are …

Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables Read more »

On a busy server, the binary logs can end up being one of the largest contributors to amount of disk space used. That means higher I/O, larger backups (you are backing up your binary logs, right?), potentially more network traffic …

MySQL Compressed Binary Logs Read more »

The Performance Schema and sys schema are great for investigating what is going on in MySQL including investigating performance issues. In my work in MySQL Support, I have several times heard questions whether a peak in the InnoDB Data File …

What Does I/O Latencies and Bytes Mean in the Performance and sys Schemas? Read more »

This post was originally published on the MySQL Support Team Blog at https://blogs.oracle.com/mysqlsupport/entry/innodb_locks_analysis_why_is on 14 April 2017. Consider the scenario that you execute a query. You expect it to be fast – typically subsecond – but now it take not …

InnoDB Locks Analysis: Why is Blocking Query NULL and How To Find More Information About the Blocking Transaction? Read more »