← Back to branch summary

~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/randgen/conf/optimizer/dsmrr-cpk-compare.cc
 
1
use Cwd;
 
2
 
 
3
$combinations = [
 
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
        '],
 
13
        ['--notnull', ''],
 
14
        ['--views', ''],
 
15
        [
 
16
                '--engine=InnoDB', '--engine=InnoDB', '--engine=InnoDB',
 
17
                '--engine=InnoDB', '--engine=InnoDB', '--engine=InnoDB', 
 
18
                '--engine=MyISAM', '--engine=Maria', '--engine=PBXT',
 
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',
 
25
                '--mysqld1=--join_cache_level=5 --mysqld2=--join_cache_level=5',
 
26
                '--mysqld1=--join_cache_level=6 --mysqld2=--join_cache_level=6',
 
27
                '--mysqld1=--join_cache_level=7 --mysqld2=--join_cache_level=7',
 
28
                '--mysqld1=--join_cache_level=8 --mysqld2=--join_cache_level=8'
 
29
        ],[
 
30
                '',
 
31
                '--mysqld1=--join_buffer_size=1 --mysqld2=--join_buffer_size=1',
 
32
                '--mysqld1=--join_buffer_size=100 --mysqld2=--join_buffer_size=100',
 
33
                '--mysqld1=--join_buffer_size=1K --mysqld2=--join_buffer_size=1K',
 
34
                '--mysqld1=--join_buffer_size=10K --mysqld2=--join_buffer_size=10K',
 
35
                '--mysqld1=--join_buffer_size=100K --mysqld2=--join_buffer_size=100K'
 
36
        ],[
 
37
                '
 
38
                        --basedir2=/home/philips/bzr/maria-5.3
 
39
                ',
 
40
                '
 
41
                        --mysqld1=--optimizer_switch=mrr_sort_keys=on
 
42
                        --mysqld2=--optimizer_switch=mrr_sort_keys=off
 
43
                '
 
44
        ],[
 
45
                '--grammar=conf/optimizer/optimizer_no_subquery.yy',
 
46
                '--grammar=conf/optimizer/outer_join.yy --gendata=conf/optimizer/outer_join.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'
 
51
        ]
 
52
];