MySQL Forums
Forum List  »  NDB clusters

Re: ERROR 1114 (HY000) at line 1038: The table 'member_attribute' is full
Posted by: Phil Bayfield
Date: September 19, 2008 04:59PM

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?


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 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.

Options: ReplyQuote

Written By
Re: ERROR 1114 (HY000) at line 1038: The table 'member_attribute' is full
September 19, 2008 04:59PM

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.