MySQL Compressed Binary Logs
On a busy server, the binary logs can end up being one of the largest contributors …
Options
Install MySQL 8 on Linux with lower_case_table_names = 1
MySQL stores several files on disk. Even in MySQL 8 where the data dictionary is stored …
Install MySQL 8 on Linux with lower_case_table_names = 1 Read more →
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 →
MySQL 8.0: Persisted Variables
MySQL 8.0 introduced a new feature that allows you to persist configuration changes from inside MySQL. …
Changes to Options and Variables in MySQL 5.6
With MySQL 5.6 just gone GA, I thought it would be good to take a look …