← Back to team overview

maria-developers team mailing list archive

[Branch ~maria-captains/maria/5.1] Rev 2818: Increased loop counts of sql-bench tests to get run times around

 

------------------------------------------------------------
revno: 2818
committer: Hakan Kuecuekyilmaz <hakan@xxxxxxxxxxxx>
branch nick: maria
timestamp: Wed 2010-02-17 21:10:02 +0100
message:
  Increased loop counts of sql-bench tests to get run times around
  5 minutes on current machines. Tested on a Xeon machine and a new dual core laptop.
modified:
  sql-bench/test-ATIS.sh
  sql-bench/test-alter-table.sh
  sql-bench/test-big-tables.sh
  sql-bench/test-connect.sh
  sql-bench/test-select.sh
  sql-bench/test-transactions.sh
  sql-bench/test-wisconsin.sh


--
lp:maria
https://code.launchpad.net/~maria-captains/maria/5.1

Your team Maria developers is subscribed to branch lp:maria.
To unsubscribe from this branch go to https://code.launchpad.net/~maria-captains/maria/5.1/+edit-subscription.
=== modified file 'sql-bench/test-ATIS.sh'
--- sql-bench/test-ATIS.sh	2009-05-29 13:40:55 +0000
+++ sql-bench/test-ATIS.sh	2010-02-17 20:10:02 +0000
@@ -28,7 +28,7 @@
 use DBI;
 use Benchmark;
 
-$opt_loop_count=100;		# Run selects this many times
+$opt_loop_count=5000;		# Run selects this many times
 
 $pwd = cwd(); $pwd = "." if ($pwd eq '');
 require "$pwd/bench-init.pl" || die "Can't read Configuration file: $!\n";

=== modified file 'sql-bench/test-alter-table.sh'
--- sql-bench/test-alter-table.sh	2009-05-29 13:40:55 +0000
+++ sql-bench/test-alter-table.sh	2010-02-17 20:10:02 +0000
@@ -25,7 +25,7 @@
 use Benchmark;
 
 $opt_start_field_count=8;	# start with this many fields
-$opt_loop_count=100;		# How many tests to do
+$opt_loop_count=10000;		# How many tests to do
 $opt_row_count=1000; 		# Rows in the table
 $opt_field_count=1000;		# Add until this many fields.
 $opt_time_limit=10*60;		# Don't wait more than 10 min for some tests

=== modified file 'sql-bench/test-big-tables.sh'
--- sql-bench/test-big-tables.sh	2009-05-29 13:40:55 +0000
+++ sql-bench/test-big-tables.sh	2010-02-17 20:10:02 +0000
@@ -25,7 +25,7 @@
 use DBI;
 use Benchmark;
 
-$opt_loop_count=1000; # Change this to make test harder/easier
+$opt_loop_count=70000; # Change this to make test harder/easier
 $opt_field_count=1000;
 
 $pwd = cwd(); $pwd = "." if ($pwd eq '');

=== modified file 'sql-bench/test-connect.sh'
--- sql-bench/test-connect.sh	2010-02-10 21:26:06 +0000
+++ sql-bench/test-connect.sh	2010-02-17 20:10:02 +0000
@@ -28,7 +28,7 @@
 use DBI;
 use Benchmark;
 
-$opt_loop_count=100000;	# Change this to make test harder/easier
+$opt_loop_count=500000;	# Change this to make test harder/easier
 $str_length=65000;	# This is the length of blob strings in PART:5
 $max_test=20;		# How many times to test if the server is busy
 

=== modified file 'sql-bench/test-select.sh'
--- sql-bench/test-select.sh	2009-05-29 13:40:55 +0000
+++ sql-bench/test-select.sh	2010-02-17 20:10:02 +0000
@@ -26,7 +26,7 @@
 use Benchmark;
 
 $opt_loop_count=10000;
-$opt_medium_loop_count=1000;
+$opt_medium_loop_count=7000;
 $opt_small_loop_count=10;
 $opt_regions=6;
 $opt_groups=100;

=== modified file 'sql-bench/test-transactions.sh'
--- sql-bench/test-transactions.sh	2009-05-29 13:40:55 +0000
+++ sql-bench/test-transactions.sh	2010-02-17 20:10:02 +0000
@@ -28,8 +28,8 @@
 
 $opt_groups=27;		    # Characters are 'A' -> Z
 
-$opt_loop_count=10000;	    # Change this to make test harder/easier
-$opt_medium_loop_count=100; # Change this to make test harder/easier
+$opt_loop_count=500000;	    # Change this to make test harder/easier
+$opt_medium_loop_count=10000; # Change this to make test harder/easier
 
 $pwd = cwd(); $pwd = "." if ($pwd eq '');
 require "$pwd/bench-init.pl" || die "Can't read Configuration file: $!\n";

=== modified file 'sql-bench/test-wisconsin.sh'
--- sql-bench/test-wisconsin.sh	2009-05-29 13:40:55 +0000
+++ sql-bench/test-wisconsin.sh	2010-02-17 20:10:02 +0000
@@ -21,7 +21,7 @@
 use DBI;
 use Benchmark;
 
-$opt_loop_count=10;
+$opt_loop_count=5000;
 
 $pwd = cwd(); $pwd = "." if ($pwd eq '');
 require "$pwd/bench-init.pl" || die "Can't read Configuration file: $!\n";