← Back to branch summary

~sergei.glushchenko/percona-server/55-tp

« back to all changes in this revision

Viewing changes to mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.result

  • Committer: Oleg Tsarev
  • Date: 2010-12-09 18:30:58 UTC
  • Revision ID: oleg.tsarev@percona.com-20101209183058-1mq1qrgjjkz3qxof
propogate Oleg's patches

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/slow_extended.patch/percona_slow_extended-use_global_long_query_time.result
 
1
SELECT sleep(1);
 
2
sleep(1)
 
3
0
 
4
SELECT sleep(3);
 
5
sleep(3)
 
6
0
 
7
SELECT sleep(5);
 
8
sleep(5)
 
9
0
 
10
set global long_query_time=4;
 
11
set global use_global_long_query_time=1;
 
12
SELECT sleep(1);
 
13
sleep(1)
 
14
0
 
15
SELECT sleep(3);
 
16
sleep(3)
 
17
0
 
18
SELECT sleep(5);
 
19
sleep(5)
 
20
0
 
21
set global long_query_time=2;
 
22
set global use_global_long_query_time=0;
 
23
3
 
24
show global variables like 'use_global_log_slow_control';
 
25
Variable_name   Value
 
26
use_global_log_slow_control     none
 
27
show global variables like 'use_global_long_query_time';
 
28
Variable_name   Value
 
29
use_global_long_query_time      OFF
 
30
set global use_global_log_slow_control = long_query_time;
 
31
show global variables like 'use_global_log_slow_control';
 
32
Variable_name   Value
 
33
use_global_log_slow_control     long_query_time
 
34
show global variables like 'use_global_long_query_time';
 
35
Variable_name   Value
 
36
use_global_long_query_time      ON
 
37
set global use_global_log_slow_control = log_slow_filter;
 
38
show global variables like 'use_global_log_slow_control';
 
39
Variable_name   Value
 
40
use_global_log_slow_control     log_slow_filter
 
41
show global variables like 'use_global_long_query_time';
 
42
Variable_name   Value
 
43
use_global_long_query_time      OFF
 
44
set global use_global_long_query_time = ON;
 
45
show global variables like 'use_global_log_slow_control';
 
46
Variable_name   Value
 
47
use_global_log_slow_control     log_slow_filter,long_query_time
 
48
show global variables like 'use_global_long_query_time';
 
49
Variable_name   Value
 
50
use_global_long_query_time      ON
 
51
set global use_global_long_query_time = OFF;
 
52
show global variables like 'use_global_log_slow_control';
 
53
Variable_name   Value
 
54
use_global_log_slow_control     log_slow_filter
 
55
show global variables like 'use_global_long_query_time';
 
56
Variable_name   Value
 
57
use_global_long_query_time      OFF
 
58
set global use_global_log_slow_control = long_query_time;