1SET @start_global_value = @@global.aria_sort_buffer_size; 2select @@global.aria_sort_buffer_size; 3@@global.aria_sort_buffer_size 4268434432 5select @@session.aria_sort_buffer_size; 6@@session.aria_sort_buffer_size 7268434432 8show global variables like 'aria_sort_buffer_size'; 9Variable_name Value 10aria_sort_buffer_size 268434432 11show session variables like 'aria_sort_buffer_size'; 12Variable_name Value 13aria_sort_buffer_size 268434432 14select * from information_schema.global_variables where variable_name='aria_sort_buffer_size'; 15VARIABLE_NAME VARIABLE_VALUE 16ARIA_SORT_BUFFER_SIZE 268434432 17select * from information_schema.session_variables where variable_name='aria_sort_buffer_size'; 18VARIABLE_NAME VARIABLE_VALUE 19ARIA_SORT_BUFFER_SIZE 268434432 20set global aria_sort_buffer_size=10; 21Warnings: 22Warning 1292 Truncated incorrect aria_sort_buffer_size value: '10' 23select @@global.aria_sort_buffer_size; 24@@global.aria_sort_buffer_size 254096 26set session aria_sort_buffer_size=10; 27Warnings: 28Warning 1292 Truncated incorrect aria_sort_buffer_size value: '10' 29select @@session.aria_sort_buffer_size; 30@@session.aria_sort_buffer_size 314096 32set global aria_sort_buffer_size=1.1; 33ERROR 42000: Incorrect argument type to variable 'aria_sort_buffer_size' 34set session aria_sort_buffer_size=1e1; 35ERROR 42000: Incorrect argument type to variable 'aria_sort_buffer_size' 36set global aria_sort_buffer_size="foo"; 37ERROR 42000: Incorrect argument type to variable 'aria_sort_buffer_size' 38set global aria_sort_buffer_size=0; 39Warnings: 40Warning 1292 Truncated incorrect aria_sort_buffer_size value: '0' 41select @@global.aria_sort_buffer_size; 42@@global.aria_sort_buffer_size 434096 44set session aria_sort_buffer_size=cast(-1 as unsigned int); 45select @@session.aria_sort_buffer_size; 46@@session.aria_sort_buffer_size 4718446744073709551615 48SET @@global.aria_sort_buffer_size = @start_global_value; 49