While working with different clients I happen to run across very
large slow log files from time to time. While several
opinions on how they should be rotated exist. Many of these
opinions use log rotate and the flush logs command, I
prefer not to flush my binary logs though. This is why I agree
with Ronald Bradford's blog post from years ago on how to do
this.
I have taken it a little further and scripted the steps. The bash
script is built with MySQL 5.6 and the mysql_config_editor in
mind it can be used on older versions of MySQL as well.
The script …