Oct 22, 2018

[HDGEM] How to configure MySQL slow shutdown


With a slow shutdown, InnoDB performs a full purge and change buffer merge before shutting down, which ensures that data files are fully prepared in case of file format differences between releases.         

Configure MySQL to perform a slow shutdown by setting innodb_fast_shutdown to 0. 
For example: 

mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"


--
Posted By Blogger to HDGEM at 1/12/2017 05:53:00 AM