diff options
author | unknown <magnus@neptunus.(none)> | 2004-04-30 10:08:44 +0200 |
---|---|---|
committer | unknown <magnus@neptunus.(none)> | 2004-04-30 10:08:44 +0200 |
commit | 92d988402c993a3a7347204147c2c02180b9419d (patch) | |
tree | 2c847ea04fc897a6c7de6b529ee90e8bcf885b9b | |
parent | 540c19bd4a74c279eba66325ac23df6f46821b1f (diff) | |
download | mariadb-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.sh | 11 | ||||
-rw-r--r-- | mysql-test/ndb/ndb_config_2_node.ini | 1 | ||||
-rw-r--r-- | sql-bench/server-cfg.sh | 7 |
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 |