1 2# 3# 2010-01-25 - Added 4# 5 6--source include/have_innodb.inc 7 8SET @start_global_value = @@global.innodb_stats_persistent_sample_pages; 9SELECT @start_global_value; 10 11# 12# exists as global only 13# 14--echo Valid values are zero or above 15SELECT @@global.innodb_stats_persistent_sample_pages >=0; 16SELECT @@global.innodb_stats_persistent_sample_pages; 17--error ER_INCORRECT_GLOBAL_LOCAL_VAR 18SELECT @@session.innodb_stats_persistent_sample_pages; 19SHOW global variables LIKE 'innodb_stats_persistent_sample_pages'; 20SHOW session variables LIKE 'innodb_stats_persistent_sample_pages'; 21--disable_warnings 22SELECT * FROM information_schema.global_variables 23WHERE variable_name='innodb_stats_persistent_sample_pages'; 24SELECT * FROM information_schema.session_variables 25WHERE variable_name='innodb_stats_persistent_sample_pages'; 26--enable_warnings 27 28# 29# SHOW that it's writable 30# 31SET global innodb_stats_persistent_sample_pages=10; 32SELECT @@global.innodb_stats_persistent_sample_pages; 33--disable_warnings 34SELECT * FROM information_schema.global_variables 35WHERE variable_name='innodb_stats_persistent_sample_pages'; 36SELECT * FROM information_schema.session_variables 37WHERE variable_name='innodb_stats_persistent_sample_pages'; 38--enable_warnings 39--error ER_GLOBAL_VARIABLE 40SET session innodb_stats_persistent_sample_pages=1; 41 42# 43# show the default value 44# 45set global innodb_stats_persistent_sample_pages=DEFAULT; 46select @@global.innodb_stats_persistent_sample_pages; 47 48# 49# valid values 50# 51SET global innodb_stats_persistent_sample_pages=0; 52SELECT @@global.innodb_stats_persistent_sample_pages; 53 54SET global innodb_stats_persistent_sample_pages=10; 55SELECT @@global.innodb_stats_persistent_sample_pages; 56 57 58 59 60# 61# incorrect types 62# 63--error ER_WRONG_TYPE_FOR_VAR 64SET global innodb_stats_persistent_sample_pages=1.1; 65--error ER_WRONG_TYPE_FOR_VAR 66SET global innodb_stats_persistent_sample_pages=1e1; 67--error ER_WRONG_TYPE_FOR_VAR 68SET global innodb_stats_persistent_sample_pages="foo"; 69--error ER_WRONG_TYPE_FOR_VAR 70SET global innodb_stats_persistent_sample_pages=' '; 71SELECT @@global.innodb_stats_persistent_sample_pages; 72--error ER_WRONG_TYPE_FOR_VAR 73SET global innodb_stats_persistent_sample_pages=" "; 74SELECT @@global.innodb_stats_persistent_sample_pages; 75SET global innodb_stats_persistent_sample_pages=-7; 76SELECT @@global.innodb_stats_persistent_sample_pages; 77--disable_warnings 78SELECT * FROM information_schema.global_variables 79WHERE variable_name='innodb_stats_persistent_sample_pages'; 80--enable_warnings 81 82 83# 84# cleanup 85# 86SET @@global.innodb_stats_persistent_sample_pages = @start_global_value; 87SELECT @@global.innodb_stats_persistent_sample_pages; 88