1SET @start_global_value = @@global.log_slow_filter;
2select @@global.log_slow_filter;
3@@global.log_slow_filter
4admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
5select @@session.log_slow_filter;
6@@session.log_slow_filter
7admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
8show global variables like 'log_slow_filter';
9Variable_name	Value
10log_slow_filter	admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
11show session variables like 'log_slow_filter';
12Variable_name	Value
13log_slow_filter	admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
14select * from information_schema.global_variables where variable_name='log_slow_filter';
15VARIABLE_NAME	VARIABLE_VALUE
16LOG_SLOW_FILTER	admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
17select * from information_schema.session_variables where variable_name='log_slow_filter';
18VARIABLE_NAME	VARIABLE_VALUE
19LOG_SLOW_FILTER	admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
20set global log_slow_filter=1;
21select @@global.log_slow_filter;
22@@global.log_slow_filter
23admin
24set session log_slow_filter=1;
25select @@session.log_slow_filter;
26@@session.log_slow_filter
27admin
28set session log_slow_filter=1;
29select @@session.log_slow_filter;
30@@session.log_slow_filter
31admin
32set session log_slow_filter=2;
33select @@session.log_slow_filter;
34@@session.log_slow_filter
35filesort
36set session log_slow_filter=5;
37select @@session.log_slow_filter;
38@@session.log_slow_filter
39admin,filesort_on_disk
40set session log_slow_filter='admin';
41select @@session.log_slow_filter;
42@@session.log_slow_filter
43admin
44set session log_slow_filter='filesort';
45select @@session.log_slow_filter;
46@@session.log_slow_filter
47filesort
48set session log_slow_filter='filesort_on_disk';
49select @@session.log_slow_filter;
50@@session.log_slow_filter
51filesort_on_disk
52set session log_slow_filter='full_join';
53select @@session.log_slow_filter;
54@@session.log_slow_filter
55full_join
56set session log_slow_filter='full_scan';
57select @@session.log_slow_filter;
58@@session.log_slow_filter
59full_scan
60set session log_slow_filter='not_using_index';
61select @@session.log_slow_filter;
62@@session.log_slow_filter
63not_using_index
64set session log_slow_filter='query_cache';
65select @@session.log_slow_filter;
66@@session.log_slow_filter
67query_cache
68set session log_slow_filter='query_cache_miss';
69select @@session.log_slow_filter;
70@@session.log_slow_filter
71query_cache_miss
72set session log_slow_filter='tmp_table';
73select @@session.log_slow_filter;
74@@session.log_slow_filter
75tmp_table
76set session log_slow_filter='tmp_table_on_disk';
77select @@session.log_slow_filter;
78@@session.log_slow_filter
79tmp_table_on_disk
80set session log_slow_filter='filesort,query_cache';
81select @@session.log_slow_filter;
82@@session.log_slow_filter
83filesort,query_cache
84set session log_slow_filter='admin,not_using_index,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk';
85select @@session.log_slow_filter;
86@@session.log_slow_filter
87admin,filesort,filesort_on_disk,full_join,full_scan,not_using_index,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
88set session log_slow_filter='';
89select @@session.log_slow_filter;
90@@session.log_slow_filter
91
92set session log_slow_filter=1.1;
93ERROR 42000: Incorrect argument type to variable 'log_slow_filter'
94set session log_slow_filter=1e1;
95ERROR 42000: Incorrect argument type to variable 'log_slow_filter'
96set session log_slow_filter="foo";
97ERROR 42000: Variable 'log_slow_filter' can't be set to the value of 'foo'
98set session log_slow_filter=16384;
99ERROR 42000: Variable 'log_slow_filter' can't be set to the value of '16384'
100SET @@global.log_slow_filter = @start_global_value;
101