summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <magnus@neptunus.(none)>2004-04-30 10:08:44 +0200
committerunknown <magnus@neptunus.(none)>2004-04-30 10:08:44 +0200
commit92d988402c993a3a7347204147c2c02180b9419d (patch)
tree2c847ea04fc897a6c7de6b529ee90e8bcf885b9b
parent540c19bd4a74c279eba66325ac23df6f46821b1f (diff)
downloadmariadb-git-92d988402c993a3a7347204147c2c02180b9419d.tar.gz
Updated default NDB config to work better with sql-bench
Updated sql-bench configs to take NDB's limitations into account mysql-test/mysql-test-run.sh: Instruct run-all-tests to create tables in NDB if USE_NDBCLUSTER is set mysql-test/ndb/ndb_config_2_node.ini: Increase MaxNumberOfOperations to 100000 to support large deletes and inserts. sql-bench/server-cfg.sh: Add settings and limitations for NDB
-rw-r--r--mysql-test/mysql-test-run.sh11
-rw-r--r--mysql-test/ndb/ndb_config_2_node.ini1
-rw-r--r--sql-bench/server-cfg.sh7
3 files changed, 17 insertions, 2 deletions
diff --git a/mysql-test/mysql-test-run.sh b/mysql-test/mysql-test-run.sh
index 36f11220862..fd992714f36 100644
--- a/mysql-test/mysql-test-run.sh
+++ b/mysql-test/mysql-test-run.sh
@@ -1469,16 +1469,23 @@ $ECHO "Starting Tests"
#
if [ "$DO_BENCH" = 1 ]
then
+ start_master
+
+ if [ ! -z "$USE_NDBCLUSTER" ]
+ then
+ EXTRA_BENCH_ARGS="--create-options=TYPE=ndb"
+ fi
+
BENCHDIR=$BASEDIR/sql-bench/
savedir=`pwd`
cd $BENCHDIR
if [ -z "$1" ]
then
- ./run-all-tests --socket=$MASTER_MYSOCK --user=root
+ ./run-all-tests --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS
else
if [ -x "./$1" ]
then
- ./$1 --socket=$MASTER_MYSOCK --user=root
+ ./$1 --socket=$MASTER_MYSOCK --user=root $EXTRA_BENCH_ARGS
else
echo "benchmark $1 not found"
fi
diff --git a/mysql-test/ndb/ndb_config_2_node.ini b/mysql-test/ndb/ndb_config_2_node.ini
index 9e0f8254c78..57aa2f527e0 100644
--- a/mysql-test/ndb/ndb_config_2_node.ini
+++ b/mysql-test/ndb/ndb_config_2_node.ini
@@ -2,6 +2,7 @@
#NoOfFragmentLogfiles: 1
#TimeBetweenLocalCheckpoints: 31
NoOfReplicas: 2
+MaxNoOfConcurrentOperations: 100000
[COMPUTER]
Id: 1
diff --git a/sql-bench/server-cfg.sh b/sql-bench/server-cfg.sh
index 905e7ee65be..9d5df27379c 100644
--- a/sql-bench/server-cfg.sh
+++ b/sql-bench/server-cfg.sh
@@ -184,6 +184,13 @@ sub new
$self->{'transactions'} = 1; # Transactions enabled
}
if (defined($main::opt_create_options) &&
+ $main::opt_create_options =~ /type=ndb/i)
+ {
+ $self->{'transactions'} = 1; # Transactions enabled
+ $limits{'max_columns'} = 90; # Max number of columns in table
+ $limits{'working_blobs'} = 0; # NDB tables can't handle BLOB's
+ }
+ if (defined($main::opt_create_options) &&
$main::opt_create_options =~ /type=bdb/i)
{
$self->{'transactions'} = 1; # Transactions enabled