37 lines
1.8 KiB
Plaintext
37 lines
1.8 KiB
Plaintext
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;
|