Search code examples
mysqldatabase-cluster

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

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.

Solution

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