1SET @start_global_value = @@global.aria_log_file_size; 2select @@global.aria_log_file_size; 3@@global.aria_log_file_size 41073741824 5select @@session.aria_log_file_size; 6ERROR HY000: Variable 'aria_log_file_size' is a GLOBAL variable 7show global variables like 'aria_log_file_size'; 8Variable_name Value 9aria_log_file_size 1073741824 10show session variables like 'aria_log_file_size'; 11Variable_name Value 12aria_log_file_size 1073741824 13select * from information_schema.global_variables where variable_name='aria_log_file_size'; 14VARIABLE_NAME VARIABLE_VALUE 15ARIA_LOG_FILE_SIZE 1073741824 16select * from information_schema.session_variables where variable_name='aria_log_file_size'; 17VARIABLE_NAME VARIABLE_VALUE 18ARIA_LOG_FILE_SIZE 1073741824 19set global aria_log_file_size=1024*1024*10; 20select @@global.aria_log_file_size; 21@@global.aria_log_file_size 2210485760 23set session aria_log_file_size=1; 24ERROR HY000: Variable 'aria_log_file_size' is a GLOBAL variable and should be set with SET GLOBAL 25set global aria_log_file_size=1.1; 26ERROR 42000: Incorrect argument type to variable 'aria_log_file_size' 27set global aria_log_file_size=1e1; 28ERROR 42000: Incorrect argument type to variable 'aria_log_file_size' 29set global aria_log_file_size="foo"; 30ERROR 42000: Incorrect argument type to variable 'aria_log_file_size' 31set global aria_log_file_size=1; 32Warnings: 33Warning 1292 Truncated incorrect aria_log_file_size value: '1' 34select @@global.aria_log_file_size; 35@@global.aria_log_file_size 368388608 37set global aria_log_file_size=@@global.aria_log_file_size + 8192 - 1; 38Warnings: 39Warning 1292 Truncated incorrect aria_log_file_size value: '8396799' 40select @@global.aria_log_file_size; 41@@global.aria_log_file_size 428388608 43set global aria_log_file_size=@@global.aria_log_file_size + 8192; 44select @@global.aria_log_file_size; 45@@global.aria_log_file_size 468396800 47set global aria_log_file_size=cast(-1 as unsigned int); 48Warnings: 49Note 1105 Cast to unsigned converted negative integer to it's positive complement 50Note 1105 Cast to unsigned converted negative integer to it's positive complement 51Warning 1292 Truncated incorrect aria_log_file_size value: '18446744073709551615' 52select @@global.aria_log_file_size; 53@@global.aria_log_file_size 544294959104 55SET @@global.aria_log_file_size = @start_global_value; 56