Re: how to handle cluster..

[Jonathan Stephens]

What are the table definitions and what is the number of records for each table?

Check your logs -- there should be warnings issued when 80% of available memory has been used (and at 85%, 90%, etc.).

Here are a few things to consider: Every table in MySQL 4.1 Cluster has a primary key that requires 35 bytes IndexMemory per table record. Every ordered index that you create uses 10 bytes DataMemory per table record. There is a limit of 8kb per table record, not including BLOB columns. In addition, since there are only fixed-width columns in Cluster (at least in MySQL 4.1 and 5.0), all VARCHAR columns require 256 bytes per record storage.

This is all mentioned in the FAQ -- you might also want to look at http://dev.mysql.com/doc/mysql/en/mysql-cluster-limitations-in-4-1.html

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle