connect con1, localhost, root; create table t1 (a int) engine=innodb; insert t1 values (1),(2),(3),(4); delete from t1 where a=1; select user,state from information_schema.processlist order by 2; user state root root Filling schema table system user InnoDB purge coordinator system user InnoDB purge worker system user InnoDB purge worker system user InnoDB purge worker system user InnoDB shutdown handler set global debug_dbug='+d,only_kill_system_threads'; set global innodb_fast_shutdown=0; shutdown; connection default; disconnect con1; select user,state from information_schema.processlist order by 2; user state root Filling schema table system user InnoDB purge coordinator system user InnoDB purge worker system user InnoDB purge worker system user InnoDB purge worker system user InnoDB slow shutdown wait set global innodb_fast_shutdown=1; select user,state from information_schema.processlist order by 2; user state root Filling schema table delete from t1 where a=3; set global innodb_fast_shutdown=0; ERROR 42000: Variable 'innodb_fast_shutdown' can't be set to the value of '0' kill ID; ERROR 70100: Connection was killed drop table t1;