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