1SET @start_value= @@global.log_queries_not_using_indexes; 2SET @filter_start_value= @@global.log_slow_filter; 3SET @@global.log_queries_not_using_indexes= TRUE; 4SET @@session.log_queries_not_using_indexes= TRUE; 5SET @@global.log_queries_not_using_indexes= FALSE; 6SET @@session.log_queries_not_using_indexes= FALSE; 7SET @@global.log_queries_not_using_indexes= DEFAULT; 8SELECT @@global.log_queries_not_using_indexes; 9@@global.log_queries_not_using_indexes 100 11SET @@global.log_queries_not_using_indexes= TRUE; 12SELECT @@global.log_queries_not_using_indexes; 13@@global.log_queries_not_using_indexes 141 15SET @@global.log_queries_not_using_indexes= true; 16SELECT @@global.log_queries_not_using_indexes; 17@@global.log_queries_not_using_indexes 181 19SET @@global.log_queries_not_using_indexes= 0; 20SELECT @@global.log_queries_not_using_indexes; 21@@global.log_queries_not_using_indexes 220 23SET @@global.log_queries_not_using_indexes= 1; 24SELECT @@global.log_queries_not_using_indexes; 25@@global.log_queries_not_using_indexes 261 27SET @goodvar= TRUE; 28SET @@global.log_queries_not_using_indexes= @goodvar; 29SELECT @@global.log_queries_not_using_indexes; 30@@global.log_queries_not_using_indexes 311 32SET GLOBAL log_queries_not_using_indexes= DEFAULT; 33SELECT @@global.log_queries_not_using_indexes; 34@@global.log_queries_not_using_indexes 350 36SET GLOBAL log_queries_not_using_indexes= ON; 37SELECT @@global.log_queries_not_using_indexes; 38@@global.log_queries_not_using_indexes 391 40SET GLOBAL log_queries_not_using_indexes= OFF; 41SELECT @@global.log_queries_not_using_indexes; 42@@global.log_queries_not_using_indexes 430 44SET GLOBAL log_queries_not_using_indexes= -0; 45SELECT @@global.log_queries_not_using_indexes; 46@@global.log_queries_not_using_indexes 470 48SET GLOBAL log_queries_not_using_indexes= 0.00; 49ERROR 42000: Incorrect argument type to variable 'log_queries_not_using_indexes' 50SET GLOBAL log_queries_not_using_indexes= +0; 51SELECT @@global.log_queries_not_using_indexes; 52@@global.log_queries_not_using_indexes 530 54SET @@global.log_queries_not_using_indexes= 'DEFAULT'; 55ERROR 42000: Variable 'log_queries_not_using_indexes' can't be set to the value of 'DEFAULT' 56SET @@global.log_queries_not_using_indexes= 'true'; 57ERROR 42000: Variable 'log_queries_not_using_indexes' can't be set to the value of 'true' 58SET @@global.log_queries_not_using_indexes= BLABLA; 59ERROR 42000: Variable 'log_queries_not_using_indexes' can't be set to the value of 'BLABLA' 60SET @@global.log_queries_not_using_indexes= 25; 61ERROR 42000: Variable 'log_queries_not_using_indexes' can't be set to the value of '25' 62SET GLOBAL log_queries_not_using_indexes= -1; 63ERROR 42000: Variable 'log_queries_not_using_indexes' can't be set to the value of '-1' 64SET @badvar= 'true'; 65SET @@global.log_queries_not_using_indexes= @badvar; 66ERROR 42000: Variable 'log_queries_not_using_indexes' can't be set to the value of 'true' 67SET GLOBAL log_queries_not_using_indexes= 'DEFAULT'; 68ERROR 42000: Variable 'log_queries_not_using_indexes' can't be set to the value of 'DEFAULT' 69SET @@global log_queries_not_using_indexes= TRUE; 70ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'log_queries_not_using_indexes= TRUE' at line 1 71SET @@SESSION log_queries_not_using_indexes= TRUE; 72ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'log_queries_not_using_indexes= TRUE' at line 1 73SET @@SESSION.log_queries_not_using_indexes= TRUE; 74select @@SESSION.log_slow_filter; 75@@SESSION.log_slow_filter 76admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,not_using_index,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk 77SET @@SESSION.log_queries_not_using_indexes= FALSE; 78select @@SESSION.log_slow_filter; 79@@SESSION.log_slow_filter 80admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk 81SET @@GLOBAL.log_queries_not_using_indexes= TRUE; 82select @@GLOBAL.log_slow_filter; 83@@GLOBAL.log_slow_filter 84admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,not_using_index,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk 85SET @@GLOBAL.log_queries_not_using_indexes= FALSE; 86select @@GLOBAL.log_slow_filter; 87@@GLOBAL.log_slow_filter 88admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk 89SET @@SESSION.log_slow_filter=""; 90select @@SESSION.log_queries_not_using_indexes; 91@@SESSION.log_queries_not_using_indexes 920 93SET @@SESSION.log_slow_filter="not_using_index"; 94select @@SESSION.log_queries_not_using_indexes; 95@@SESSION.log_queries_not_using_indexes 961 97SET @@GLOBAL.log_slow_filter=""; 98select @@GLOBAL.log_queries_not_using_indexes; 99@@GLOBAL.log_queries_not_using_indexes 1000 101SET @@GLOBAL.log_slow_filter="not_using_index"; 102select @@GLOBAL.log_queries_not_using_indexes; 103@@GLOBAL.log_queries_not_using_indexes 1041 105SET @@global.log_queries_not_using_indexes= @start_value; 106SET @@global.log_slow_filter= @filter_start_value; 107