[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 # so ist sie im Dauerstress innodb_max_dirty_pages_pct = 50 # damit sie schneller startet #innodb_max_dirty_pages_pct_lwm = 0 innodb_max_dirty_pages_pct_lwm = 20 # damit sie schneller startet innodb_change_buffering = 'none'