To run sql-bench you should use the the flag --create-options=type=ndb,
This will not only create the tables in NDB, but also apply some limits,
which should make it possible to run the benchmarks.
Look in server-cfg.sh:187
On Thu, 2004-09-02 at 05:37, Chad Martin wrote:
> Martin Skold wrote:
> > Note that the flag is:
> > --default-storage-engine=ndbcluster
> >
> > table-type is a depricated concept.
> >
> > Mikael Ronström wrote:
> >
> >> A very simple way is to start mysqld with the option
> >> default-table-type=ndbcluster.
> >> In this way all tables will be stored in the cluster unless
> >> specifically said not to.
> >>
> >> No benchmarks program in the mysql benchmark suites are specifically
> >> made for
> >> testing clusters.
>
> Not surprisingly, running the perl tests and crash-me with mysqld
> started with --default-storage-engine=ndbcluster failed in pretty much
> every case. Many of the tests tried to create tables that were in one
> way or another illegal in NDBcluster tables. My company has two other
> specific benchmarks we hope to try. One is a simple Java application
> with a high update to select ratio, and the other is a Perl application
> that is designed to create a database in about as complicated a way as
> possible, including, in part, a fully-connected 3D graph representation.
> I'll let the list know the results, if they are worthwhile.
>
> It would be nice to have NDB-friendly tests like the ones in the
> sql-bench directory. I'm sure a developer will get right to work on
> this, given all the free time you guys must have. ;)
>
> Chad Martin
> Arete Studios
--
Magnus Svensson, Software Engineer
MySQL AB, www.mysql.com
Office: +46 709 164 491
