SET @start_value= @@global.log_throttle_queries_not_using_indexes;
SET @@global.log_throttle_queries_not_using_indexes= DEFAULT;
SELECT @@global.log_throttle_queries_not_using_indexes;
@@global.log_throttle_queries_not_using_indexes
0
SET @@global.log_throttle_queries_not_using_indexes= 1000;
SELECT @@global.log_throttle_queries_not_using_indexes;
@@global.log_throttle_queries_not_using_indexes
1000
SET @@global.log_throttle_queries_not_using_indexes= -1;
Warnings:
Warning	1292	Truncated incorrect log_throttle_queries_not_using_i value: '-1'
SELECT @@global.log_throttle_queries_not_using_indexes;
@@global.log_throttle_queries_not_using_indexes
0
SET @@global.log_throttle_queries_not_using_indexes= 5;
SELECT @@global.log_throttle_queries_not_using_indexes;
@@global.log_throttle_queries_not_using_indexes
5
SET @@global.log_throttle_queries_not_using_indexes= OFF;
ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
SELECT @@global.log_throttle_queries_not_using_indexes;
@@global.log_throttle_queries_not_using_indexes
5
SET @@global.log_throttle_queries_not_using_indexes= ON;
ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
SELECT @@global.log_throttle_queries_not_using_indexes;
@@global.log_throttle_queries_not_using_indexes
5
SET GLOBAL log_throttle_queries_not_using_indexes= 0.01;
ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
SET SESSION log_throttle_queries_not_using_indexes= 0;
ERROR HY000: Variable 'log_throttle_queries_not_using_indexes' is a GLOBAL variable and should be set with SET GLOBAL
SET LOCAL log_throttle_queries_not_using_indexes= 0;
ERROR HY000: Variable 'log_throttle_queries_not_using_indexes' is a GLOBAL variable and should be set with SET GLOBAL
SET @@global.log_throttle_queries_not_using_indexes= @start_value;