sql-bench

[Richard Garcia]

I have installed mysql-4.1.8 with ndb clustering enabled and running.

I am trying to use the /usr/share/mysql/sql-bench/run-all-tests utility
to test the mysql cluster.

Whenever I run it as root on the localhost, I get a bunch of "Can't create table"
errors. In the output files I see two different errors: 4318 and 708.

Here is an example of one of the output files:

#Testing server 'MySQL 4.1.8/' at 2005-01-14 14:14:59
#
#Testing of ALTER TABLE
#Testing with 1000 columns and 1000 rows in 100 steps
#Insert data into the table
#Time for insert (1000) 3 wallclock secs ( 0.02 usr 0.01 sys + 0.00 cusr 0.00 csys = 0.03 CPU)
#
#
#Error executing 'ALTER TABLE bench ADD i119 integer,ADD i120 integer,ADD i121 integer,ADD i122 #integer,ADD i123 integer,ADD i124 integer,ADD i125 integer,ADD i126 integer,ADD i127 #integer,ADD i128 integer':
#Can't create table './test/#sql-6ef1_9a28.frm' (errno: 4318)

#Testing server 'MySQL 4.1.8/' at 2005-01-14 14:22:36
#
#Testing the speed of creating and dropping tables
#Testing with 10000 tables and 10000 loop count
#
#Testing create of tables
#Can't execute command 'create table bench_68 (i int NOT NULL,d double,f float,s char(10),v #varchar(100),primary key (i))'
#Error: Can't create table './test/bench_68.frm' (errno: 708)

What do these errors mean?

-Rich