Im trying to populate a Cluster database. The loading process terminates prematurely and I get an error message like this one: ERROR 1114: The table my_cluster_table is full Why is this happening?
The cause is very likely to be that your setup does not provide sufficient RAM for all table data and all indexes, including the primary key required by the NDB storage engine and automatically created in the event that the table definition does not include the definition of a primary key. It is also worth noting that all data nodes should have the same amount of RAM, since no data node in a cluster can use more memory than the least amount available to any individual data node. In other words, if there are four computers hosting Cluster data nodes, and three of these have 3GB of RAM available to store Cluster data while the remaining data node has only 1GB RAM, then each data node can devote only 1GB to clustering.
Related Questions
- I am trying to populate a MySQL Cluster database. The loading process terminates prematurely and I get an error message like this one: ERROR 1114: The table my_cluster_table is full Why is this happening?
- Im trying to populate a Cluster database. The loading process terminates prematurely and I get an error message like this one: ERROR 1114: The table my_cluster_table is full Why is this happening?
- What should I do when I get an error message telling me "There is not enough SoundFont cache", when loading SoundFonts?