← Back to branch summary

~tsarev/dbqp/dbqp_out_of_source

« back to all changes in this revision

Viewing changes to randgen/conf/optimizer/mrr-single.cc

  • Committer: patrick crews
  • Date: 2011-10-05 20:26:34 UTC
  • Revision ID: gleebix@gmail.com-20111005202634-2q6baxxvbfuhmdzy
Initial branch

Show diffs side-by-side

added added

removed removed

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