# variables show variables like "gtid_mode"; Variable_name Value gtid_mode ON show variables like "recovery_apply_binlog"; Variable_name Value recovery_apply_binlog ON set global recovery_apply_binlog=OFF; ERROR HY000: Variable 'recovery_apply_binlog' is a read only variable # restart: --gtid_mode=on --enforce_gtid_consistency=ON show variables like "recovery_apply_binlog"; Variable_name Value recovery_apply_binlog ON flush logs; create table t (a int); # restart: --gtid_mode=on --enforce_gtid_consistency=ON show variables like "recovery_apply_binlog"; Variable_name Value recovery_apply_binlog ON # restart: --gtid_mode=off show variables like "recovery_apply_binlog"; Variable_name Value recovery_apply_binlog OFF # restart drop table t;