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 »