diff options
Diffstat (limited to 'sql-bench')
| -rwxr-xr-x | sql-bench/bench-init.pl.sh | 7 | ||||
| -rwxr-xr-x | sql-bench/test-insert.sh | 4 |
2 files changed, 8 insertions, 3 deletions
diff --git a/sql-bench/bench-init.pl.sh b/sql-bench/bench-init.pl.sh index 3b9e343bc4a..3f650885c21 100755 --- a/sql-bench/bench-init.pl.sh +++ b/sql-bench/bench-init.pl.sh @@ -51,7 +51,7 @@ $log_prog_args=join(" ", skip_arguments(\@ARGV,"comments","cmp","server", "user", "host", "database", "password", "use-old-results","skip-test", "machine", "dir", "suffix", "log")); -GetOptions("skip-test=s","comments=s","cmp=s","server=s","user=s","host=s","database=s","password=s","loop-count=i","row-count=i","skip-create","skip-delete","verbose","fast-insert","lock-tables","debug","fast","force","field-count=i","regions=i","groups=i","time-limit=i","log","use-old-results","machine=s","dir=s","suffix=s","help","odbc","small-test","small-tables","small-key-tables","stage=i","old-headers","die-on-errors","create-options","hires") || usage(); +GetOptions("skip-test=s","comments=s","cmp=s","server=s","user=s","host=s","database=s","password=s","loop-count=i","row-count=i","skip-create","skip-delete","verbose","fast-insert","lock-tables","debug","fast","force","field-count=i","regions=i","groups=i","time-limit=i","log","use-old-results","machine=s","dir=s","suffix=s","help","odbc","small-test","small-tables","small-key-tables","stage=i","old-headers","die-on-errors","create-options=s","hires") || usage(); usage() if ($opt_help); $server=get_server($opt_server,$opt_host,$opt_database,$opt_odbc, @@ -400,6 +400,11 @@ All benchmarks takes the following options: with the same --cmp, you will get a test that is comparable between the different sql servers. +--create-options=# + Extra argument to all create statements. If you for example want to + create all MySQL tables as BDB tables use: + --create-options=TYPE=BDB + --database (Default $opt_database) In which database the test tables are created. diff --git a/sql-bench/test-insert.sh b/sql-bench/test-insert.sh index ec269df5d3b..a6161781ba9 100755 --- a/sql-bench/test-insert.sh +++ b/sql-bench/test-insert.sh @@ -572,7 +572,7 @@ if ($limits->{'group_functions'}) $loop_time=new Benchmark; $count=$estimated=0; - for ($tests=0 ; $tests < $small_loop_count ; $tests++) + for ($tests=1 ; $tests <= $small_loop_count ; $tests++) { $count+=2; fetch_all_rows($dbh,"select count(distinct dummy1) from bench1"); @@ -834,7 +834,7 @@ if ($limits->{'func_odbc_floor'} && $limits->{'left_outer_join'}) $count=$estimated=0; $loop_time=new Benchmark; - for ($i=0 ; $i < $small_loop_count ; $i++) + for ($i=1 ; $i <= $small_loop_count ; $i++) { $count+=fetch_all_rows($dbh,"select count(a.dummy1),count(b.dummy1) from bench1 as a left outer join bench1 as b on (a.id2=b.id3) where b.id3 is null"); $end_time=new Benchmark; |