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 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 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 # restart drop table t1;