[mysqld] # https://www.percona.com/blog/2020/05/07/prepare-mysql-for-a-safe-shutdown/ # 4. Configure InnoDB for Max Flushing. # SET GLOBAL innodb_fast_shutdown=0; SET GLOBAL innodb_max_dirty_pages_pct=0; SET GLOBAL innodb_change_buffering='none'; # SHOW VARIABLES LIKE 'innodb_fast_shutdown'; SHOW VARIABLES LIKE 'innodb_max_dirty_pages_pct'; SHOW VARIABLES LIKE 'innodb_change_buffering'; innodb_fast_shutdown=0 innodb_max_dirty_pages_pct=0 innodb_change_buffering='none'