MySQL Forums
Forum List  »  NDB clusters

Re: sql-bench
Posted by: Mikael Ronström
Date: January 15, 2005 02:11AM

Richard Garcia wrote:
> 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)
>


Max no of attributes in a table is 128 in MySQL Cluster currently

Rgrds Mikael

> #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

Options: ReplyQuote


Subject
Views
Written By
Posted
6743
January 14, 2005 04:32PM
2485
January 15, 2005 02:09AM
2301
February 05, 2005 12:43AM
Re: sql-bench
2559
January 15, 2005 02:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.