RE: I want to use sql-bench to test the performance,but I got this! - 刘兰增 - com.mysql.lists.cluster

3 messages in com.mysql.lists.clusterRE: I want to use sql-bench to test t...

From	Sent On	Attachments
刘兰增	25 Oct 2004 19:13
Kenji HIROHAMA	25 Oct 2004 23:27
刘兰增	26 Oct 2004 21:00

Subject:	RE: I want to use sql-bench to test the performance,but I got this!
From:	刘兰增 (liul...@baidu.com)
Date:	10/26/2004 09:00:26 PM
List:	com.mysql.lists.cluster

Thanks

With the --small-test option, it only create 10 tables.

I am afraid that it can't create more, like 1000 tables.

If you have time, I'd like you to do a full test without --small-test option.

Thank you again.

-----邮件原件----- 发件人: Kenji HIROHAMA [mailto:kenj...@gmail.com] 发送时间: 2004年10月26日 14:27 收件人: 刘兰增抄送: clus...@lists.mysql.com 主题: Re: I want to use sql-bench to test the performance,but I got this!

I've succeeded in testing sql-bench with --small-tset option, just now. Here is my config.ini, I reffered old posts in this ML,

----------config.ini----------- [NDBD DEFAULT] NoOfReplicas: 2 DataMemory = 1000M IndexMemory = 400M MaxNoOfConcurrentTransactions = 50 MaxNoOfConcurrentOperations = 250000 TimeBetweenWatchDogCheck = 4000 MaxNoOfOrderedIndexes = 27000 MaxNoOfTables = 9000 MaxNoOfAttributes = 25000

[MGM] Hostname: 172.16.129.60

[NDBD] HostName: 172.16.129.60 DataDir: /var/lib/mysql-cluster/

[NDBD] HostName: 172.16.129.59 DataDir: /var/lib/mysql-cluster/

[MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] HostName: 172.16.129.61

-----------end of config.ini----------

2 Server Spec(mgm, ndbd): P4 3.2GHz(800MHz FSB) 2GB Memory(PC3200 ECC DDR400 SDRAM) 73GB HDD(10,000rpm, U320)

1 Client Spec(mysqld, mysql, sql-bench): P3-M 1.2GHz 512MB Memory 40GB HDD

Hello everybody

[liulz@ecom sql-bench]$ ./test-create --socket=/home/liulz/tmp/mysql416.sock --create-option=engine=NDBCLUSTER

Testing server 'MySQL 4.1.6 gamma max log' at 2004-10-26 10:14:21

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_49 (i int NOT NULL,d double,f float,s char(10),v varchar(100),primary key (i)) engine=NDBCLUSTER'

Error: Can't create table './test/bench_49.frm' (errno: 4009)

My config.ini

[NDBD DEFAULT]

NoOfReplicas:2

MaxNoOfOrderedIndexes:256

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

[NDB_MGMD]

HostName = 172.16.80.250

[NDBD]

HostName = 172.16.80.250

DataDir: /home/liulz/local/mysql416/mysql-cluster/db2

[NDBD]

HostName = 172.16.50.6

DataDir: /rd0/chenqy/local/mysql416/mysql-cluster/db3

[MYSQLD]

HostName = 172.16.50.6

Ndb_2_error.log :

Current byte-offset of file-pointer is: 468

Date/Time: Tuesday 26 October 2004 - 10:15:01

Type of error: error

Message: Pointer too large

Fault ID: 2306

Problem data: DbaccMain.cpp

Object of reference: DBACC (Line: 1066) 0x0000000a

ProgramName: NDB Kernel

ProcessID: 7062

TraceFile: /home/liulz/local/mysql416/mysql-cluster/db2/ndb_2_trace.log.1

***EOM***

Thanks for your help!

Yours Leo