1SET @start_value= @@global.log_throttle_queries_not_using_indexes;
2SET @@global.log_throttle_queries_not_using_indexes= DEFAULT;
3SELECT @@global.log_throttle_queries_not_using_indexes;
4@@global.log_throttle_queries_not_using_indexes
50
6SET @@global.log_throttle_queries_not_using_indexes= 1000;
7SELECT @@global.log_throttle_queries_not_using_indexes;
8@@global.log_throttle_queries_not_using_indexes
91000
10SET @@global.log_throttle_queries_not_using_indexes= -1;
11Warnings:
12Warning	1292	Truncated incorrect log_throttle_queries_not_using_i value: '-1'
13SELECT @@global.log_throttle_queries_not_using_indexes;
14@@global.log_throttle_queries_not_using_indexes
150
16SET @@global.log_throttle_queries_not_using_indexes= 5;
17SELECT @@global.log_throttle_queries_not_using_indexes;
18@@global.log_throttle_queries_not_using_indexes
195
20SET @@global.log_throttle_queries_not_using_indexes= OFF;
21ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
22SELECT @@global.log_throttle_queries_not_using_indexes;
23@@global.log_throttle_queries_not_using_indexes
245
25SET @@global.log_throttle_queries_not_using_indexes= ON;
26ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
27SELECT @@global.log_throttle_queries_not_using_indexes;
28@@global.log_throttle_queries_not_using_indexes
295
30SET GLOBAL log_throttle_queries_not_using_indexes= 0.01;
31ERROR 42000: Incorrect argument type to variable 'log_throttle_queries_not_using_indexes'
32SET SESSION log_throttle_queries_not_using_indexes= 0;
33ERROR HY000: Variable 'log_throttle_queries_not_using_indexes' is a GLOBAL variable and should be set with SET GLOBAL
34SET LOCAL log_throttle_queries_not_using_indexes= 0;
35ERROR HY000: Variable 'log_throttle_queries_not_using_indexes' is a GLOBAL variable and should be set with SET GLOBAL
36SET @@global.log_throttle_queries_not_using_indexes= @start_value;
37