From: Mikael Ronström
Date: August 16 2004 12:11pm
Subject: Re: NDB Cluster on AMD Opteron machine
List-Archive: http://lists.mysql.com/cluster/405
Message-Id: <5F881E70-EF7D-11D8-8801-000A959312A2@mysql.com>
MIME-Version: 1.0 (Apple Message framework v618)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi Aram,

2004-08-11 kl. 18.34 skrev Aram:

> Hi all,
>
> I setup both 4.1.3 and 5.0.1 releases on AMD Opteron machine.  Below
> is list of issues I encountered and details for my current
> environment:
>
> Version: 4.1.3
> --------------------
> Invoking "ndb_mgmd -c config.ini -l Ndb.cfg -d" generates segmentation
> fault in ConfigValuesFactory::put. (A quick diff between 4.1.3 and
> 5.0.1 shows several fixes in ConfigValues.cpp)
>
> Will those fixes be merged into 4.1.x branch?
>

Yes.

> Version: 5.0.1
> --------------------
> The general speed of ndb is very slow (at least 100 times compared to
> 32 bit machine).  This difference is not seen for InnoDB.  I based
> speed comparison on simple select count and bulk data import.
>

100 times I haven't seen before. Select count is slightly faster in=20
InnoDB what
I've seen so far. Bulk data import can be of similar and even faster=20
speed using
ndb. However the cluster team is currently focused on the 4.1.x=20
branches and
do not apply any particular tests on the 5.0.x branches. This will soon=20=

change.

Rgrds Mikael

> What could be the cause of this?
>
> Configuration options
> ------------------------------
> CFLAGS=3D-O3
> CXX=3Dgcc
> CXXFLAGS=3D'-O3 -felide-constructors -fno-exceptions -fno-rtti'
>
> ./configure --prefix=3D/usr/local/mysql --with-innodb =
--with-berkeley-db
> --with-embedded-server --enable-thread-safe-client --with-openssl
> --with-vio --with-ndbcluster
>
> config.ini
> -------------
> [COMPUTER DEFAULT]
>
> [MGM DEFAULT]
> ArbitrationRank: 1
>
> [DB DEFAULT]
> NoOfReplicas: 1
>
> [API DEFAULT]
>
> [TCP DEFAULT]
> PortNumber: 20000
>
> [COMPUTER]
> Id: 1
> ByteOrder: Little
> HostName: localhost
>
> [MGM]
> Id: 1
> ExecuteOnComputer: 1
>
> [DB]
> Id: 2
> ExecuteOnComputer: 1
> FileSystemPath: /usr/local/mysql/ndb_data
>
> [API]
> Id: 3
> ExecuteOnComputer: 1
>
> [TCP]
> NodeId1: 1
> NodeId2: 2
>
> [TCP]
> NodeId1: 2
> NodeId2: 3
>
> ----------------------------
> Thanks in advance,
> Aram
>
> --=20
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:   =20
> http://lists.mysql.com/cluster?unsub=3Dmikael@stripped
>
>
Mikael Ronstr=F6m, Senior Software Architect
MySQL AB, www.mysql.com

Clustering:
http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html

http://www.eweek.com/article2/0,1759,1567546,00.asp