← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to conf/optimizer/dsmrr-cpk-compare.cc

comprehensive .CC files for DS-MRR optimization

Show diffs side-by-side

added added

removed removed

Lines of Context:
conf/optimizer/dsmrr-cpk-compare.cc
 
1
use Cwd;
 
2
 
1
3
$combinations = [
2
 
        ['--queries=1M --duration=180 --threads=1 --reporter=QueryTimeout,Backtrace,ErrorLog,Deadlock  --filter=conf/optimizer/dsmrr-cpk.ff'],
 
4
        ['
 
5
                --vardir2=/tmp/vardir2
 
6
                --queries=1M
 
7
                --duration=300
 
8
                --threads=2
 
9
                --reporter=QueryTimeout,Backtrace,ErrorLog,Deadlock
 
10
                --validator=ResultsetComparatorSimplify
 
11
                --filter=conf/optimizer/dsmrr-cpk.ff
 
12
        '],
3
13
        ['--notnull', ''],
4
14
        ['--views', ''],
5
15
        [
6
 
                '--engine=MyISAM',
7
 
                '--engine=Maria',
8
 
                '--engine=Memory',
9
 
                '--engine=InnoDB',
10
 
                '--engine=InnoDB',
11
 
                '--engine=PBXT',
 
16
                '--engine=InnoDB', '--engine=InnoDB', '--engine=InnoDB',
 
17
                '--engine=InnoDB', '--engine=InnoDB', '--engine=InnoDB', 
 
18
                '--engine=MyISAM', '--engine=Maria', '--engine=PBXT',
12
19
        ],[
 
20
                '--mysqld1=--join_cache_level=0 --mysqld2=--join_cache_level=0',
 
21
                '--mysqld1=--join_cache_level=1 --mysqld2=--join_cache_level=1',
 
22
                '--mysqld1=--join_cache_level=2 --mysqld2=--join_cache_level=2',
 
23
                '--mysqld1=--join_cache_level=3 --mysqld2=--join_cache_level=3',
 
24
                '--mysqld1=--join_cache_level=4 --mysqld2=--join_cache_level=4',
13
25
                '--mysqld1=--join_cache_level=5 --mysqld2=--join_cache_level=5',
14
26
                '--mysqld1=--join_cache_level=6 --mysqld2=--join_cache_level=6',
15
27
                '--mysqld1=--join_cache_level=7 --mysqld2=--join_cache_level=7',
24
36
        ],[
25
37
                '
26
38
                        --basedir2=/home/philips/bzr/maria-5.3
27
 
                        --validator=ResultsetComparatorSimplify
28
39
                ',
 
40
                '
 
41
                        --mysqld1=--optimizer_switch=mrr_sort_keys=on
 
42
                        --mysqld2=--optimizer_switch=mrr_sort_keys=off
 
43
                '
29
44
        ],[
30
45
                '--grammar=conf/optimizer/optimizer_no_subquery.yy',
31
46
                '--grammar=conf/optimizer/outer_join.yy --gendata=conf/optimizer/outer_join.zz',
32
 
                '--grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz'
 
47
                '--grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz',
 
48
                '--grammar=conf/dbt3/dbt3-joins.yy
 
49
                 --mysqld1=--init-file='.getcwd().'/conf/dbt3/dbt3-s0.001.dump
 
50
                 --mysqld2=--init-file='.getcwd().'/conf/dbt3/dbt3-s0.001.dump'
33
51
        ]
34
52
];