Re: ERROR 1114 (HY000) at line 1038: The table 'member_attribute' is full

[Phil Bayfield]

Hi David,

You need to work out how much memory is required to load your database into NDB first really.

You need to work out the following:

1. How many records do you have in your database?

and/or:

2. What is the total size of the data plus indexes of your database?

If you are importing from an existing MyISAM/Innodb database you should try running ndb_size.pl and it will give you the answers to these questions.

Make sure you also understand how NDB stores data.

Index memory stores primary key indexes ONLY.
Data memory stores all the data + other indexes.

Hence as an example, if you have 10Gb data you will need more than 10Gb RAM on your machine, as non-primary key indexes will increase the amount of data memory required also.

You need to consider the fact you need memory for NDB to run (plus buffers etc) and available data/index memory for new records, I would try and keep it below 75%.

You obviously need more data memory, so you could:

1. Upgrade the existing machines with more RAM.
2. Add another pair of machines keeping number of replicas to 2, which will mean each copy of the database would span accross 2 machines.