1SET @start_global_value = @@global.innodb_stats_persistent_sample_pages; 2SELECT @start_global_value; 3@start_global_value 420 5Valid values are zero or above 6SELECT @@global.innodb_stats_persistent_sample_pages >=0; 7@@global.innodb_stats_persistent_sample_pages >=0 81 9SELECT @@global.innodb_stats_persistent_sample_pages; 10@@global.innodb_stats_persistent_sample_pages 1120 12SELECT @@session.innodb_stats_persistent_sample_pages; 13ERROR HY000: Variable 'innodb_stats_persistent_sample_pages' is a GLOBAL variable 14SHOW global variables LIKE 'innodb_stats_persistent_sample_pages'; 15Variable_name Value 16innodb_stats_persistent_sample_pages 20 17SHOW session variables LIKE 'innodb_stats_persistent_sample_pages'; 18Variable_name Value 19innodb_stats_persistent_sample_pages 20 20SELECT * FROM information_schema.global_variables 21WHERE variable_name='innodb_stats_persistent_sample_pages'; 22VARIABLE_NAME VARIABLE_VALUE 23INNODB_STATS_PERSISTENT_SAMPLE_PAGES 20 24SELECT * FROM information_schema.session_variables 25WHERE variable_name='innodb_stats_persistent_sample_pages'; 26VARIABLE_NAME VARIABLE_VALUE 27INNODB_STATS_PERSISTENT_SAMPLE_PAGES 20 28SET global innodb_stats_persistent_sample_pages=10; 29SELECT @@global.innodb_stats_persistent_sample_pages; 30@@global.innodb_stats_persistent_sample_pages 3110 32SELECT * FROM information_schema.global_variables 33WHERE variable_name='innodb_stats_persistent_sample_pages'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_STATS_PERSISTENT_SAMPLE_PAGES 10 36SELECT * FROM information_schema.session_variables 37WHERE variable_name='innodb_stats_persistent_sample_pages'; 38VARIABLE_NAME VARIABLE_VALUE 39INNODB_STATS_PERSISTENT_SAMPLE_PAGES 10 40SET session innodb_stats_persistent_sample_pages=1; 41ERROR HY000: Variable 'innodb_stats_persistent_sample_pages' is a GLOBAL variable and should be set with SET GLOBAL 42set global innodb_stats_persistent_sample_pages=DEFAULT; 43select @@global.innodb_stats_persistent_sample_pages; 44@@global.innodb_stats_persistent_sample_pages 4520 46SET global innodb_stats_persistent_sample_pages=0; 47Warnings: 48Warning 1292 Truncated incorrect innodb_stats_persistent_sample_p value: '0' 49SELECT @@global.innodb_stats_persistent_sample_pages; 50@@global.innodb_stats_persistent_sample_pages 511 52SET global innodb_stats_persistent_sample_pages=10; 53SELECT @@global.innodb_stats_persistent_sample_pages; 54@@global.innodb_stats_persistent_sample_pages 5510 56SET global innodb_stats_persistent_sample_pages=1.1; 57ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages' 58SET global innodb_stats_persistent_sample_pages=1e1; 59ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages' 60SET global innodb_stats_persistent_sample_pages="foo"; 61ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages' 62SET global innodb_stats_persistent_sample_pages=' '; 63ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages' 64SELECT @@global.innodb_stats_persistent_sample_pages; 65@@global.innodb_stats_persistent_sample_pages 6610 67SET global innodb_stats_persistent_sample_pages=" "; 68ERROR 42000: Incorrect argument type to variable 'innodb_stats_persistent_sample_pages' 69SELECT @@global.innodb_stats_persistent_sample_pages; 70@@global.innodb_stats_persistent_sample_pages 7110 72SET global innodb_stats_persistent_sample_pages=-7; 73Warnings: 74Warning 1292 Truncated incorrect innodb_stats_persistent_sample_p value: '-7' 75SELECT @@global.innodb_stats_persistent_sample_pages; 76@@global.innodb_stats_persistent_sample_pages 771 78SELECT * FROM information_schema.global_variables 79WHERE variable_name='innodb_stats_persistent_sample_pages'; 80VARIABLE_NAME VARIABLE_VALUE 81INNODB_STATS_PERSISTENT_SAMPLE_PAGES 1 82SET @@global.innodb_stats_persistent_sample_pages = @start_global_value; 83SELECT @@global.innodb_stats_persistent_sample_pages; 84@@global.innodb_stats_persistent_sample_pages 8520 86