Re: Very long data node startup - Stewart Smith - com.mysql.lists.cluster

2 messages in com.mysql.lists.clusterRe: Very long data node startup

From	Sent On	Attachments
AUDO Olivier	13 Feb 2007 00:32
Stewart Smith	13 Feb 2007 04:27

Subject:	Re: Very long data node startup
From:	Stewart Smith (stew...@mysql.com)
Date:	02/13/2007 04:27:51 AM
List:	com.mysql.lists.cluster

On Tue, 2007-02-13 at 09:33 +0100, AUDO Olivier wrote:

Dear all,

I'm experiencing a very long start-up (2 hours) of storage node.

Version of MySQL Cluster is 5.0.27, with 2 storage nodes well started and holding 2 tables of 1 million lines each. After stop (kill of daemon) and start of one of the data nodes, it takes 2 hours to get sync. No CPU was used during the 2 hours on storage node. While starting, there were R/W SQL access to the Cluster.

What are the steps when a node starts-up ? Any idea on the reasons it could take so long ?

how much data is there? what speed network?

check how long LCP takes (check the manual) and check NoOfDiskPagesToDiskDuringRestart(ACC|TUP) parameters.

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html