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