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

mysql mysql-management database-cluster
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.

Related questions

ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'

I seem to be unable to re-create a simple user I've deleted, even as root in MySQL. My case: user 'jack' existed before, but I deleted it from mysql.user in order to recreate it. I see no vestiges of …

Read More
How to set root password to null

How can I change the password for root user of MySQL to null -- meaning no password or '' -- from the MySQL command line client?

Read More
mysql command for showing current configuration variables

Can not find a command that displays the current configuration of mysql from within the database. I know I could look at /etc/mysql/my.cnf but that is not what I need.

Read More