MySQL cluster - error 707
Hello All,
We've setup MySQL cluster some time ago. Most of our tables are running ndbcluster, but we can't create any new ones (or alter MyISAM tables). At first I tought this had to do with MaxNoOfTables, but that's not the problem. If I create a table without a KEY it works just fine, but with a KEY we get the error:
Error Code: 1005 Can't create table 'dbname.table' (errno: 707)
Perror says:
perror --ndb 707
NDB error code 707: No more table metadata records (increase MaxNoOfTables): Permanent error: Schema error
But I think we shouldn't be able to create tables without a KEY.
The setup is running NDB 7.1.13 and MySQL 5.1.56 (2 data nodes, 1 management server). We used this in the config.ini file:
DataMemory=2G
IndexMemory=1000M
MaxNoOfConcurrentOperations=100000
MaxNoOfConcurrentTransactions=16384
StringMemory=25
MaxNoOfTables=20320
MaxNoOfOrderedIndexes=25000
MaxNoOfUniqueHashIndexes=15000
MaxNoOfAttributes=201950
MaxNoOfTriggers=71120
NoOfFragmentLogFiles=25
Anyone has an idea?
Subject
Views
Written By
Posted
MySQL cluster - error 707
3195
September 16, 2011 02:43AM
1876
September 19, 2011 04:26PM
1020
September 20, 2011 12:23AM
961
September 19, 2011 04:29PM
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.