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 »