← 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-min_examined_row_limit.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-min_examined_row_limit.result
 
1
SET GLOBAL SLOW_QUERY_LOG=OFF;
 
2
drop table if exists t;
 
3
# Create test table
 
4
create table t(id INT PRIMARY KEY) engine=InnoDB;
 
5
# Insert two rows to test table
 
6
insert into t values(1);
 
7
insert into t values(2);
 
8
insert into t values(3);
 
9
SET GLOBAL SLOW_QUERY_LOG=ON;
 
10
SELECT sleep(2);
 
11
sleep(2)
 
12
0
 
13
set min_examined_row_limit=5;
 
14
SELECT sleep(2) union select t2.id from t as t1,t as t2;
 
15
sleep(2)
 
16
0
 
17
1
 
18
2
 
19
3
 
20
SELECT sleep(2);
 
21
sleep(2)
 
22
0
 
23
drop table if exists t;
 
24
2