1SET @start_global_value = @@global.innodb_stats_transient_sample_pages; 2SELECT @start_global_value; 3@start_global_value 48 5Valid values are zero or above 6SELECT @@global.innodb_stats_transient_sample_pages >=0; 7@@global.innodb_stats_transient_sample_pages >=0 81 9SELECT @@global.innodb_stats_transient_sample_pages; 10@@global.innodb_stats_transient_sample_pages 118 12SELECT @@session.innodb_stats_transient_sample_pages; 13ERROR HY000: Variable 'innodb_stats_transient_sample_pages' is a GLOBAL variable 14SHOW global variables LIKE 'innodb_stats_transient_sample_pages'; 15Variable_name Value 16innodb_stats_transient_sample_pages 8 17SHOW session variables LIKE 'innodb_stats_transient_sample_pages'; 18Variable_name Value 19innodb_stats_transient_sample_pages 8 20SELECT * FROM information_schema.global_variables 21WHERE variable_name='innodb_stats_transient_sample_pages'; 22VARIABLE_NAME VARIABLE_VALUE 23INNODB_STATS_TRANSIENT_SAMPLE_PAGES 8 24SELECT * FROM information_schema.session_variables 25WHERE variable_name='innodb_stats_transient_sample_pages'; 26VARIABLE_NAME VARIABLE_VALUE 27INNODB_STATS_TRANSIENT_SAMPLE_PAGES 8 28set global innodb_stats_transient_sample_pages=DEFAULT; 29select @@global.innodb_stats_transient_sample_pages; 30@@global.innodb_stats_transient_sample_pages 318 32SET global innodb_stats_transient_sample_pages=10; 33SELECT @@global.innodb_stats_transient_sample_pages; 34@@global.innodb_stats_transient_sample_pages 3510 36SELECT * FROM information_schema.global_variables 37WHERE variable_name='innodb_stats_transient_sample_pages'; 38VARIABLE_NAME VARIABLE_VALUE 39INNODB_STATS_TRANSIENT_SAMPLE_PAGES 10 40SELECT * FROM information_schema.session_variables 41WHERE variable_name='innodb_stats_transient_sample_pages'; 42VARIABLE_NAME VARIABLE_VALUE 43INNODB_STATS_TRANSIENT_SAMPLE_PAGES 10 44SET session innodb_stats_transient_sample_pages=1; 45ERROR HY000: Variable 'innodb_stats_transient_sample_pages' is a GLOBAL variable and should be set with SET GLOBAL 46SET global innodb_stats_transient_sample_pages=1.1; 47ERROR 42000: Incorrect argument type to variable 'innodb_stats_transient_sample_pages' 48SET global innodb_stats_transient_sample_pages=1e1; 49ERROR 42000: Incorrect argument type to variable 'innodb_stats_transient_sample_pages' 50SET global innodb_stats_transient_sample_pages="foo"; 51ERROR 42000: Incorrect argument type to variable 'innodb_stats_transient_sample_pages' 52SET global innodb_stats_transient_sample_pages=' '; 53ERROR 42000: Incorrect argument type to variable 'innodb_stats_transient_sample_pages' 54SET global innodb_stats_transient_sample_pages=-7; 55Warnings: 56Warning 1292 Truncated incorrect innodb_stats_transient_sample... value: '-7' 57SELECT @@global.innodb_stats_transient_sample_pages; 58@@global.innodb_stats_transient_sample_pages 591 60SELECT * FROM information_schema.global_variables 61WHERE variable_name='innodb_stats_transient_sample_pages'; 62VARIABLE_NAME VARIABLE_VALUE 63INNODB_STATS_TRANSIENT_SAMPLE_PAGES 1 64SET @@global.innodb_stats_transient_sample_pages = @start_global_value; 65SELECT @@global.innodb_stats_transient_sample_pages; 66@@global.innodb_stats_transient_sample_pages 678 68