In MySQL 8.0, Oracle has improved or added features; let's look at these.
This step in MySQL is something many DBAs or developers are not aware of, because it is not something that we check everyday but it is important; we're talking about the maximum value of the auto-increment counter, which is registered in the redo log and changes each time during each checkpoint.
In addition to being saved in a series of private tables and visible only by MySQL, the auto-increment counter has been improved so it is more persistent during a restart of MySQL. This means that during a reboot, the new value will persist and not change as in previous releases.
Another improvement is the dynamic configuration of Innodb_deadlock_detect, which can be used to disable or enable this variable, which normally if it is active can affect the performance of MySQL in the case...
