1SET @start_global_value = @@global.innodb_stats_modified_counter; 2SELECT @start_global_value; 3@start_global_value 40 5Valid values are one or above 6select @@global.innodb_stats_modified_counter >=1; 7@@global.innodb_stats_modified_counter >=1 80 9select @@global.innodb_stats_modified_counter; 10@@global.innodb_stats_modified_counter 110 12select @@session.innodb_stats_modified_counter; 13ERROR HY000: Variable 'innodb_stats_modified_counter' is a GLOBAL variable 14show global variables like 'innodb_stats_modified_counter'; 15Variable_name Value 16innodb_stats_modified_counter 0 17show session variables like 'innodb_stats_modified_counter'; 18Variable_name Value 19innodb_stats_modified_counter 0 20select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_STATS_MODIFIED_COUNTER 0 23select * from information_schema.session_variables where variable_name='innodb_stats_modified_counter'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_STATS_MODIFIED_COUNTER 0 26set global innodb_stats_modified_counter=10; 27select @@global.innodb_stats_modified_counter; 28@@global.innodb_stats_modified_counter 2910 30select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_STATS_MODIFIED_COUNTER 10 33select * from information_schema.session_variables where variable_name='innodb_stats_modified_counter'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_STATS_MODIFIED_COUNTER 10 36set session innodb_stats_modified_counter=1; 37ERROR HY000: Variable 'innodb_stats_modified_counter' is a GLOBAL variable and should be set with SET GLOBAL 38set global innodb_stats_modified_counter=1.1; 39ERROR 42000: Incorrect argument type to variable 'innodb_stats_modified_counter' 40set global innodb_stats_modified_counter=1e1; 41ERROR 42000: Incorrect argument type to variable 'innodb_stats_modified_counter' 42set global innodb_stats_modified_counter="foo"; 43ERROR 42000: Incorrect argument type to variable 'innodb_stats_modified_counter' 44set global innodb_stats_modified_counter=-7; 45Warnings: 46Warning 1292 Truncated incorrect innodb_stats_modified_counter value: '-7' 47select @@global.innodb_stats_modified_counter; 48@@global.innodb_stats_modified_counter 490 50select * from information_schema.global_variables where variable_name='innodb_stats_modified_counter'; 51VARIABLE_NAME VARIABLE_VALUE 52INNODB_STATS_MODIFIED_COUNTER 0 53SET @@global.innodb_stats_modified_counter = @start_global_value; 54SELECT @@global.innodb_stats_modified_counter; 55@@global.innodb_stats_modified_counter 560 57