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
Subject
Views
Written By
Posted
Table creation fails with - No more table metadata records (increase MaxNoOfTables)
1557
June 01, 2017 12:23PM
682
June 13, 2017 03:51AM
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.