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