By default in MySQL 5.6, each time MySQL is
started (regular start or crash recovery), it iterates through
all the binlog files when GTIDs are not enabled. This can take a
very long time if you have a large number of binary log files.
MySQL and Percona Server 5.6.21+ have a fix with the
simplified-binlog-gtid-recovery option. Let’s
explore this issue.
Understanding the issue
It was first reported by Yoshinori @ Facebook (bug …[Read more...]