List:Cluster« Previous MessageNext Message »
From:Tomas Ulin Date:November 23 2004 7:01pm
Subject:Re: LOAD Testing NDB mySQL 4.1.7
View as plain text  
I've filed a bug report:

http://bugs.mysql.com/bug.php?id=6775

can you confirm if you have the same error in one of the ndb_<id>_error.log.

BR,

T

Dathan Vance Pattishall wrote:

>Wrote a program to test my NDB cluster:
>
>
>
>1 NDB MGMNT Server
>
> 
>
>5 NDB Storage Nodes
>
> 
>
>1 mySQL client.
>
> 
>
> 
>
>The goal was to achieve >= speed to a myISAM table loaded into memory for a
>sustained period of a few hours.
>
> 
>
>Test setup.
>
> 
>
>A process that forks off database connections an runs typical quieries for
>the Friendster.com site.
>
> 
>
>45 simultaneous threads sustained doing pure select Non-cacheable qureiries.
>
>NDB got up to 1200 qps but then failed with these errors:
>
> 
>
>dathan@ndb4:~> /usr/local/mysql/bin/perror --ndb 4025
>
>Error code 4025:  Node failure caused abort of transaction: Temporary error:
>Node Recovery error
>
> 
>
>/usr/local/mysql/bin/perror --ndb 4010
>
>Error code 4010:  Node failure caused abort of transaction: Temporary error:
>Node Recovery error
>
> 
>
> 
>
>Then the slave SQL thread failed with 4010 as well.
>
> 
>
> 
>
>Then connecting to the management node I see that ALL storage nodes failed.
>
> 
>
>What information does the list need in an effort to track down the problem?
>
> 
>
>DVP
>
>----
>
>Dathan Vance Pattishall     http://www.friendster.com
>
> 
>
>
>  
>

Thread
LOAD Testing NDB mySQL 4.1.7Dathan Vance Pattishall19 Nov
  • Re: LOAD Testing NDB mySQL 4.1.7Tomas Ulin23 Nov
  • Re: LOAD Testing NDB mySQL 4.1.7Tomas Ulin23 Nov