Have you been experiencing slow MySQL startup times in GTID mode?
We recently ran into this issue on one of our MySQL
hosting deployments and set out to solve the problem. In
this blog, we break down the issue that could be slowing
down your MySQL restart times, how to debug for your deployment,
and what you can do to decrease your start time and improve your
understanding of GTID-based replication.

How We Found The Problem

We were investigating slow MySQL startup times on a low-end,
disk-based MySQL 5.7.21 deployment which had GTID mode enabled.
The system was part of a master-slave pair and was under a moderate
write load. When restarting during a scheduled maintenance, we …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.