Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables
Locking is an important concept in databases. They help regulate access to the data, so your …
Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables Read more →
InnoDB
MySQL Compressed Binary Logs
On a busy server, the binary logs can end up being one of the largest contributors …
Reduce MySQL Core Dump Size by Excluding the InnoDB Buffer Pool
When things go horrible wrong and a process crashes, one of the most powerful things to …
Reduce MySQL Core Dump Size by Excluding the InnoDB Buffer Pool Read more →
InnoDB Progress Information
MySQL has since version 5.7 had support for progress information for some queries. As promised in …
MySQL 8.0.12: Instant ALTER TABLE
There are many nice changes included in the MySQL 8.0.12 release that were published a couple …