MySQL Forums
Forum List  »  NDB clusters

Regd MySQL Cluster Startup phases
Posted by: Balasubramanian Azhagappan
Date: June 30, 2005 07:39AM

We are currently checking, how much time it takes for the Mysql Cluster to startup.

right now we have 5 Million entries in 6 tables, with each each row(from each table)added up gives around 1084KB.
total size comes around 10GB of data in Memory when loaded.

We have a configured 7 machines in the cluster each machine, of which 2 machines with 12GB RAM is configured for the ndbd daemons and the rest 5 machines is alloted for the daemon.

node3, node5 are in 1 of the ndbd machine and
node2 and node4 are in another ndbd machine.


We have set the
NoOfDiskPagesToDiskDuringRestartTUP=500 (around 40MB)
NoOfDiskPagesToDiskDuringRestartACC=500 (around 40MB)

and we have a 15K-RPM SCSI harddisk in the ndbd machines.

During our observation, we found that the following major time consuming phases

1. IndexActivation takes around 3-4Mins
2. LocalCheckPoint after Step3(System Restart) takes 13-14Mins
3. Index Rebuild done - takes 3.4Mins

Totalling to around 23-24Mins.

I would like to know whether it is possible to bring the start up time within 10 mins including all the above 3 major phases.

If not, is it possible to skip the LocalCheckPoint during restart.

Thanks in advance.

regards,
Bala

Options: ReplyQuote


Subject
Views
Written By
Posted
Regd MySQL Cluster Startup phases
2883
June 30, 2005 07:39AM


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.