1SET @start_global_value = @@global.mrr_buffer_size; 2select @@global.mrr_buffer_size; 3@@global.mrr_buffer_size 4262144 5select @@session.mrr_buffer_size; 6@@session.mrr_buffer_size 7262144 8show global variables like 'mrr_buffer_size'; 9Variable_name Value 10mrr_buffer_size 262144 11show session variables like 'mrr_buffer_size'; 12Variable_name Value 13mrr_buffer_size 262144 14select * from information_schema.global_variables where variable_name='mrr_buffer_size'; 15VARIABLE_NAME VARIABLE_VALUE 16MRR_BUFFER_SIZE 262144 17select * from information_schema.session_variables where variable_name='mrr_buffer_size'; 18VARIABLE_NAME VARIABLE_VALUE 19MRR_BUFFER_SIZE 262144 20set global mrr_buffer_size=10; 21Warnings: 22Warning 1292 Truncated incorrect mrr_buffer_size value: '10' 23select @@global.mrr_buffer_size; 24@@global.mrr_buffer_size 258192 26set session mrr_buffer_size=10; 27Warnings: 28Warning 1292 Truncated incorrect mrr_buffer_size value: '10' 29select @@session.mrr_buffer_size; 30@@session.mrr_buffer_size 318192 32set global mrr_buffer_size=1.1; 33ERROR 42000: Incorrect argument type to variable 'mrr_buffer_size' 34set session mrr_buffer_size=1e1; 35ERROR 42000: Incorrect argument type to variable 'mrr_buffer_size' 36set global mrr_buffer_size="foo"; 37ERROR 42000: Incorrect argument type to variable 'mrr_buffer_size' 38set global mrr_buffer_size=0; 39Warnings: 40Warning 1292 Truncated incorrect mrr_buffer_size value: '0' 41select @@global.mrr_buffer_size; 42@@global.mrr_buffer_size 438192 44set session mrr_buffer_size=cast(-1 as unsigned int); 45Warnings: 46Note 1105 Cast to unsigned converted negative integer to it's positive complement 47Warning 1292 Truncated incorrect mrr_buffer_size value: '18446744073709551615' 48select @@session.mrr_buffer_size; 49@@session.mrr_buffer_size 502147483647 51SET @@global.mrr_buffer_size = @start_global_value; 52