MySQL Forums
Forum List  »  NDB clusters

Table creation fails with - No more table metadata records (increase MaxNoOfTables)
Posted by: Dev Das
Date: June 01, 2017 12:23PM

We are running MySQL Server version: 5.7.16-ndb-7.5.4-cluster-gpl-log on dedicated 2 nodes under Management, 2 nodes for NDBD and 2 nodes for API.
Multiple databases are created, with tables under ndbcluster ENGINE; tables do contains blob fields.
Under current stage we are reaching a maximum of 4682 tables, and further unable to create additional tables, MySQL throws following error message:
Got error 707 'No more table metadata records (increase MaxNoOfTables)' from NDBCLUSTER.

snippet from config.ini
[NDBD DEFAULT]
NoOfReplicas=2
Datadir=/var/lib/mysql-cluster
FileSystemPathDD=/var/lib/mysql-cluster
DataMemory=76800M
IndexMemory=10240M
MaxNoOfTables=20320
MaxNoOfOrderedIndexes=102400
MaxNoOfUniqueHashIndexes=512
MaxNoOfAttributes=24576000
MaxNoOfTriggers=14336

Please suggest if anyone has faced similar issues and has a solution for the same, we would like to be able to maintain around 10000 tables.
Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Table creation fails with - No more table metadata records (increase MaxNoOfTables)
168
June 01, 2017 12:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.