1 2 3# 2010-01-25 - Added 4# 5 6--source include/have_innodb.inc 7 8SET @start_global_value = @@global.innodb_adaptive_flushing; 9SELECT @start_global_value; 10 11# 12# exists as global only 13# 14--echo Valid values are 'ON' and 'OFF' 15select @@global.innodb_adaptive_flushing in (0, 1); 16select @@global.innodb_adaptive_flushing; 17--error ER_INCORRECT_GLOBAL_LOCAL_VAR 18select @@session.innodb_adaptive_flushing; 19show global variables like 'innodb_adaptive_flushing'; 20show session variables like 'innodb_adaptive_flushing'; 21select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing'; 22select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing'; 23 24# 25# show that it's writable 26# 27set global innodb_adaptive_flushing='OFF'; 28select @@global.innodb_adaptive_flushing; 29select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing'; 30select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing'; 31set @@global.innodb_adaptive_flushing=1; 32select @@global.innodb_adaptive_flushing; 33select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing'; 34select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing'; 35set global innodb_adaptive_flushing=0; 36select @@global.innodb_adaptive_flushing; 37select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing'; 38select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing'; 39set @@global.innodb_adaptive_flushing='ON'; 40select @@global.innodb_adaptive_flushing; 41select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing'; 42select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing'; 43--error ER_GLOBAL_VARIABLE 44set session innodb_adaptive_flushing='OFF'; 45--error ER_GLOBAL_VARIABLE 46set @@session.innodb_adaptive_flushing='ON'; 47 48# 49# incorrect types 50# 51--error ER_WRONG_TYPE_FOR_VAR 52set global innodb_adaptive_flushing=1.1; 53--error ER_WRONG_TYPE_FOR_VAR 54set global innodb_adaptive_flushing=1e1; 55--error ER_WRONG_VALUE_FOR_VAR 56set global innodb_adaptive_flushing=2; 57--echo NOTE: The following should fail with ER_WRONG_VALUE_FOR_VAR (BUG#50643) 58set global innodb_adaptive_flushing=-3; 59select @@global.innodb_adaptive_flushing; 60select * from information_schema.global_variables where variable_name='innodb_adaptive_flushing'; 61select * from information_schema.session_variables where variable_name='innodb_adaptive_flushing'; 62--error ER_WRONG_VALUE_FOR_VAR 63set global innodb_adaptive_flushing='AUTO'; 64 65# 66# Cleanup 67# 68 69SET @@global.innodb_adaptive_flushing = @start_global_value; 70SELECT @@global.innodb_adaptive_flushing; 71