← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

comprehensive .CC files for DS-MRR optimization

Show diffs side-by-side

added added

removed removed

Lines of Context:
conf/optimizer/dsmrr-cpk-single.cc
 
1
use Cwd;
 
2
        
1
3
$combinations = [
2
4
        ['
3
 
                --queries=1M --duration=180 --threads=1 --seed=time
4
 
                --reporter=QueryTimeout,Deadlock,Backtrace,ErrorLog --validator=Transformer --filter=conf/optimizer/dsmrr-cpk.ff
5
 
        '],
 
5
                --queries=1M
 
6
                --duration=300
 
7
                --threads=2
 
8
                --seed=time
 
9
                --reporter=QueryTimeout,Deadlock,Backtrace,ErrorLog
 
10
                --validator=Transformer
 
11
                --filter=conf/optimizer/dsmrr-cpk.ff
 
12
                --no-mask
 
13
                --mysqld=--sql_mode=ONLY_FULL_GROUP_BY
 
14
                --mysqld=--optimizer_search_depth=6
 
15
                --debug
 
16
        '],
 
17
        ['', '', '', '', '',
 
18
                '--mysqld=--optimizer_switch=mrr_sort_keys=off',
 
19
                '--mysqld=--optimizer_switch=index_condition_pushdown=off',
 
20
        ],
6
21
        ['', '--notnull'],
7
22
        ['', '--views'],
 
23
        ['', '', '', '', '--valgrind-xml'],
8
24
        [
9
 
                '--engine=MyISAM',
10
 
                '--engine=Maria',
11
 
                '--engine=Memory',
12
 
                '--engine=InnoDB',
13
 
                '--engine=InnoDB',
14
 
                '--engine=PBXT'
15
 
        ],[
16
 
                '--mysqld=--join_cache_level=5',
17
 
                '--mysqld=--join_cache_level=6',
18
 
                '--mysqld=--join_cache_level=7',
19
 
                '--mysqld=--join_cache_level=8'
 
25
                '--engine=InnoDB', '--engine=InnoDB', '--engine=InnoDB',
 
26
                '--engine=InnoDB', '--engine=InnoDB', '--engine=InnoDB',
 
27
                '--engine=InnoDB', '--engine=InnoDB', '--engine=InnoDB',
 
28
                '--engine=MyISAM', '--engine=Maria', '--engine=PBXT'
20
29
        ],[
21
30
                '',
22
31
                '--mysqld=--join_buffer_size=1',
25
34
                '--mysqld=--join_buffer_size=10K',
26
35
                '--mysqld=--join_buffer_size=100K'
27
36
        ],[
 
37
                '--mysqld=--join_cache_level=0',
 
38
                '--mysqld=--join_cache_level=1',
 
39
                '--mysqld=--join_cache_level=2',
 
40
                '--mysqld=--join_cache_level=3',
 
41
                '--mysqld=--join_cache_level=4',
 
42
                '--mysqld=--join_cache_level=5',
 
43
                '--mysqld=--join_cache_level=6',
 
44
                '--mysqld=--join_cache_level=7',
 
45
                '--mysqld=--join_cache_level=8'
 
46
        ],[
 
47
                '',
 
48
                '--mysqld=--join_buffer_size=1',
 
49
                '--mysqld=--join_buffer_size=100',
 
50
                '--mysqld=--join_buffer_size=1K',
 
51
                '--mysqld=--join_buffer_size=10K',
 
52
                '--mysqld=--join_buffer_size=100K'
 
53
        ],[
 
54
                '',
 
55
                '--mysqld=--mrr_buffer_size=1',
 
56
                '--mysqld=--mrr_buffer_size=100',
 
57
                '--mysqld=--mrr_buffer_size=1K',
 
58
                '--mysqld=--mrr_buffer_size=10K',
 
59
                '--mysqld=--mrr_buffer_size=100K'
 
60
        ],[
28
61
                '--grammar=conf/optimizer/optimizer_no_subquery.yy',
29
62
                '--grammar=conf/optimizer/outer_join.yy --gendata=conf/optimizer/outer_join.zz',
30
 
                '--grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz'
 
63
                '--grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz',
 
64
                '--grammar=conf/dbt3/dbt3-joins.yy --mysqld=--init-file='.getcwd().'/conf/dbt3/dbt3-s0.001.dump'
31
65
        ]
32
66
];