summaryrefslogtreecommitdiff
path: root/sql-bench
diff options
context:
space:
mode:
authorunknown <monty@tik.mysql.fi>2001-09-08 01:01:10 +0300
committerunknown <monty@tik.mysql.fi>2001-09-08 01:01:10 +0300
commita41b148e478c522c8fe8037f86969c7eff15073c (patch)
tree3f8bb55c2b3ec5e00a3dc49b4fed5d540e339591 /sql-bench
parentdac2557acfb7a1b073eb8facfa4b115c6a55126d (diff)
downloadmariadb-git-a41b148e478c522c8fe8037f86969c7eff15073c.tar.gz
Unlock tables on BEGIN
sql-bench/test-create.sh: Made --small-test a bit faster sql/ha_innobase.cc: Cleanup memory at exit sql/mysqld.cc: Remove debug notes at shutdown
Diffstat (limited to 'sql-bench')
-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}))