You are here
MySQL Cluster: No more room in index file
Recently we were migrating an InnoDB/MyISAM schema to NDB. I was too lazy to calculate all the needed MySQL Cluster parameters (for example with ndb_size.pl) and just took my default config.ini template.
Because I am really lazy I have a little script doing this for me (alter_engine.pl).
But suddenly my euphoria was stopped abruptly by the following error:
MySQL error code 136: No more room in index file
The usual command that helps me in such a situation is a follows:
# perror 136 MySQL error code 136: No more room in index file
But in this case it is not really helpful. Also
# perror --ndb 136
does not bring us further. Strange: Index file... We are converting from MyISAM/InnoDB to NDB. Why the hell is he using an index file for this operation? It seems to be clearly a mysqld
error message and not a MySQL Cluster error message. And we are also not using MySQL Cluster disk data tables.
After bothering a bit MySQL support I had the idea to do the following:
# ndb_show_tables | grep -ic orderedindex 127
The MySQL online documentation clearly states:
MaxNoOfOrderedIndexes
...
The default value of this parameter is 128.
So this could be the reason! When I have changed this parameter followed by the common rolling restart of the MySQL Cluster I could continue to migrate my schema into cluster...
Conclusion
MySQL errors can be related to cluster errors and do not necessarily point to the source of the problem. The error:
MySQL error code 136: No more room in index file
means just MaxNoOfOrderedIndexes
is too small!
I hope that I can safe you some time with this little article.
- Shinguz's blog
- Log in or register to post comments
Comments
MySQL Cluster: No more room in index file
MySQL Cluster: No more room in index file
MySQL Cluster: No more room in index file