Re: Issues with a new Cluster - ERROR 1114 (HY000): The table 'xyz' is full

[Brad Riemann]

For those that come upon this issue, I appended my NDBD defaults to:

[NDBD DEFAULT]
NoOfReplicas = 2
DataMemory = 20480MB
IndexMemory = 1024MB
BackupMemory = 512MB
DataDir = /var/lib/mysql-cluster #directory for storing management data
MaxNoOfTables = 4096
MaxNoOfConcurrentOperations = 100000
MaxNoOfAttributes = 50000
MaxNoOfOrderedIndexes = 5000
MaxNoOfUniqueHashIndexes = 5000

and things work properly now, most likely I will have to do tuning down the road as we expand the ram from 32GB To 64GB per node.

I believe the issue was the MaxNoOfTables attribute, I may never know since I added proceeding settings after the fact, but it's working :s



Edited 1 time(s). Last edit at 12/05/2013 08:21AM by Brad Riemann.