1SET @start_global_value = @@global.aria_log_purge_type; 2select @@global.aria_log_purge_type; 3@@global.aria_log_purge_type 4immediate 5select @@session.aria_log_purge_type; 6ERROR HY000: Variable 'aria_log_purge_type' is a GLOBAL variable 7show global variables like 'aria_log_purge_type'; 8Variable_name Value 9aria_log_purge_type immediate 10show session variables like 'aria_log_purge_type'; 11Variable_name Value 12aria_log_purge_type immediate 13select * from information_schema.global_variables where variable_name='aria_log_purge_type'; 14VARIABLE_NAME VARIABLE_VALUE 15ARIA_LOG_PURGE_TYPE immediate 16select * from information_schema.session_variables where variable_name='aria_log_purge_type'; 17VARIABLE_NAME VARIABLE_VALUE 18ARIA_LOG_PURGE_TYPE immediate 19set global aria_log_purge_type=1; 20select @@global.aria_log_purge_type; 21@@global.aria_log_purge_type 22external 23set session aria_log_purge_type=1; 24ERROR HY000: Variable 'aria_log_purge_type' is a GLOBAL variable and should be set with SET GLOBAL 25set global aria_log_purge_type=immediate; 26select @@global.aria_log_purge_type; 27@@global.aria_log_purge_type 28immediate 29set global aria_log_purge_type=external; 30select @@global.aria_log_purge_type; 31@@global.aria_log_purge_type 32external 33set global aria_log_purge_type=at_flush; 34select @@global.aria_log_purge_type; 35@@global.aria_log_purge_type 36at_flush 37set global aria_log_purge_type=1.1; 38ERROR 42000: Incorrect argument type to variable 'aria_log_purge_type' 39set global aria_log_purge_type=1e1; 40ERROR 42000: Incorrect argument type to variable 'aria_log_purge_type' 41set global aria_log_purge_type="foo"; 42ERROR 42000: Variable 'aria_log_purge_type' can't be set to the value of 'foo' 43set global aria_log_purge_type=3; 44ERROR 42000: Variable 'aria_log_purge_type' can't be set to the value of '3' 45SET @@global.aria_log_purge_type = @start_global_value; 46