mysql> alter table 19m4t_enrol_authorize engine=ndbcluster;
ERROR 1005 (HY000): Can't create table './lmsdb/#sql-2ece_a.frm' (errno: 708)
when i want to cluster my tables on my other nodes this error appear.
The Solution is go to my mysql management node and i increase
increase "MaxNoOfAttributes"into my ndb_mgm.conf
example :
DataMemory = 24G
IndexMemory = 4G
MaxNoOfOrderedIndexes = 1024
MaxNoOfAttributes = 10000
MaxNoOfTables = 2500
MaxNoOfConcurrentOperations = 250000
MaxNoOfConcurrentIndexOperations = 250000
reboot all machine.
DONE!
excellent resolution thanks !
ReplyDeleteseems to be new with version 7.1.9a