1SELECT @@innodb_stats_include_delete_marked; 2@@innodb_stats_include_delete_marked 30 4SET GLOBAL innodb_stats_include_delete_marked=1; 5SELECT @@innodb_stats_include_delete_marked; 6@@innodb_stats_include_delete_marked 71 8SET SESSION innodb_stats_include_delete_marked=1; 9ERROR HY000: Variable 'innodb_stats_include_delete_marked' is a GLOBAL variable and should be set with SET GLOBAL 10SET GLOBAL innodb_stats_include_delete_marked=100; 11ERROR 42000: Variable 'innodb_stats_include_delete_marked' can't be set to the value of '100' 12SET GLOBAL innodb_stats_include_delete_marked=foo; 13ERROR 42000: Variable 'innodb_stats_include_delete_marked' can't be set to the value of 'foo' 14SET GLOBAL innodb_stats_include_delete_marked=OFF ; 15SELECT @@innodb_stats_include_delete_marked; 16@@innodb_stats_include_delete_marked 170 18SET GLOBAL innodb_stats_include_delete_marked=ON ; 19SELECT @@innodb_stats_include_delete_marked; 20@@innodb_stats_include_delete_marked 211 22SET GLOBAL innodb_stats_include_delete_marked=Default ; 23SELECT @@innodb_stats_include_delete_marked; 24@@innodb_stats_include_delete_marked 250 26