← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mariadb-5.5/trusty-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/sys_vars/r/log_slow_filter_basic.result

  • Committer: Package Import Robot
  • Author(s): Otto Kekäläinen
  • Date: 2013-12-22 10:27:05 UTC
  • Revision ID: package-import@ubuntu.com-20131222102705-mndw7s12mz0szrcn
Tags: upstream-5.5.32
Import upstream version 5.5.32

Show diffs side-by-side

added added

removed removed

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