MySQL cluster error 1114 (HY000): The table 'users' is full

T-Wrecks picture T-Wrecks · Nov 14, 2010 · Viewed 10.5k times · Source

I have a MySQL cluster setup, There are 2 data nodes and 1 management node. We are now getting errors on our data nodes when doing inserts.

ERROR 1114 (HY000): The table 'users' is full

Please any help is appreciated, Is this a config issue, if so which node? each node is an Ubuntu 9 server.

Answer

Sergio picture Sergio · Mar 19, 2012

The answer is here: http://dev.mysql.com/doc/refman/5.0/en/faqs-mysql-cluster.html#qandaitem-B-10-1-13

in short: ndb engine holds all data in RAM. If your nodes have 1GB RAM and you are trying to load a 4GB database you are (nearly) out of luck.

There is a way to configure ndb to use disk to store data so that RAM is only used to store indexes (they still have to be stored in RAM), here is how: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-disk-data-objects.html

If you do that, however, you will get far lower performances.