1SET @start_global_value = @@global.log_slow_rate_limit; 2select @@global.log_slow_rate_limit; 3@@global.log_slow_rate_limit 41 5select @@session.log_slow_rate_limit; 6@@session.log_slow_rate_limit 71 8show global variables like 'log_slow_rate_limit'; 9Variable_name Value 10log_slow_rate_limit 1 11show session variables like 'log_slow_rate_limit'; 12Variable_name Value 13log_slow_rate_limit 1 14select * from information_schema.global_variables where variable_name='log_slow_rate_limit'; 15VARIABLE_NAME VARIABLE_VALUE 16LOG_SLOW_RATE_LIMIT 1 17select * from information_schema.session_variables where variable_name='log_slow_rate_limit'; 18VARIABLE_NAME VARIABLE_VALUE 19LOG_SLOW_RATE_LIMIT 1 20set global log_slow_rate_limit=10; 21select @@global.log_slow_rate_limit; 22@@global.log_slow_rate_limit 2310 24set session log_slow_rate_limit=10; 25select @@session.log_slow_rate_limit; 26@@session.log_slow_rate_limit 2710 28set global log_slow_rate_limit=1.1; 29ERROR 42000: Incorrect argument type to variable 'log_slow_rate_limit' 30set session log_slow_rate_limit=1e1; 31ERROR 42000: Incorrect argument type to variable 'log_slow_rate_limit' 32set global log_slow_rate_limit="foo"; 33ERROR 42000: Incorrect argument type to variable 'log_slow_rate_limit' 34set global log_slow_rate_limit=0; 35Warnings: 36Warning 1292 Truncated incorrect log_slow_rate_limit value: '0' 37select @@global.log_slow_rate_limit; 38@@global.log_slow_rate_limit 391 40set session log_slow_rate_limit=cast(-1 as unsigned int); 41Warnings: 42Note 1105 Cast to unsigned converted negative integer to it's positive complement 43Warning 1292 Truncated incorrect log_slow_rate_limit value: '18446744073709551615' 44select @@session.log_slow_rate_limit; 45@@session.log_slow_rate_limit 464294967295 47SET @@global.log_slow_rate_limit = @start_global_value; 48