summaryrefslogtreecommitdiff
path: root/sql-bench/test-create.sh
diff options
context:
space:
mode:
authorunknown <monty@tik.mysql.fi>2001-09-06 23:57:32 +0300
committerunknown <monty@tik.mysql.fi>2001-09-06 23:57:32 +0300
commit44e61cdad7da3d5c98002b56dcfa3d026b205bcf (patch)
treee9cc497510dfb664a30e2714aaceae4638a512a0 /sql-bench/test-create.sh
parent07a887b3836904c19a7dcc74ac1b73e82dbed7ec (diff)
downloadmariadb-git-44e61cdad7da3d5c98002b56dcfa3d026b205bcf.tar.gz
Fixed a problem using LOCK TABLES and BDB tables
Docs/manual.texi: Added description of C thread functions sql-bench/test-create.sh: Faster --fast option
Diffstat (limited to 'sql-bench/test-create.sh')
-rw-r--r--sql-bench/test-create.sh12
1 files changed, 10 insertions, 2 deletions
diff --git a/sql-bench/test-create.sh b/sql-bench/test-create.sh
index 09d79c67b04..2853984e393 100644
--- a/sql-bench/test-create.sh
+++ b/sql-bench/test-create.sh
@@ -39,13 +39,21 @@ $opt_loop_count=10000; # Change this to make test harder/easier
chomp($pwd = `pwd`); $pwd = "." if ($pwd eq '');
require "$pwd/bench-init.pl" || die "Can't read Configuration file: $!\n";
+$create_loop_count=$opt_loop_count;
if ($opt_small_test)
{
$opt_loop_count/=100;
+ $create_loop_count/=1000;
}
$max_tables=min($limits->{'max_tables'},$opt_loop_count);
+if ($opt_small_test)
+{
+ $max_tables=10;
+}
+
+
print "Testing the speed of creating and droping tables\n";
print "Testing with $max_tables tables and $opt_loop_count loop count\n\n";
@@ -177,7 +185,7 @@ print "Testing create+drop\n";
$loop_time=new Benchmark;
-for ($i=1 ; $i <= $opt_loop_count ; $i++)
+for ($i=1 ; $i <= $create_loop_count ; $i++)
{
do_many($dbh,$server->create("bench_$i",
["i int NOT NULL",
@@ -190,7 +198,7 @@ for ($i=1 ; $i <= $opt_loop_count ; $i++)
}
$end_time=new Benchmark;
-print "Time for create+drop ($opt_loop_count): " .
+print "Time for create+drop ($create_loop_count): " .
timestr(timediff($end_time, $loop_time),"all") . "\n";
if ($opt_fast && defined($server->{vacuum}))