ERROR 1005 (HY000) at line **: Can't create table '**' (errno: 136)

1.When you get this error immediately run "SHOW WARNINGS" to see the storage engine level error codes. (mysql>) 2.Display: Got error 904 'Out of fragment records (increase MaxNoOfOrderedIndexes)' from NDB 3.$ ndb_config --type ndbd -q Id,MaxNoOfOrderedIndexes,MaxNoOfUniqueHashIndexes -r '\n' 4.$ ndb_show_tables | grep -c OrderedIndex 5. ndb_mgm> ALL REPORT MEMORY This clearly shows that your settings in the config.ini are not being applied to the cluster. Restart ndb_mgmd with --initial then do a rolling restart of all ndbd nodes to ensure that they use the increased values. Every table will have at least 1 Hash index used by the primary key. If you do not define a primary key for a table, ndb will define a hidden one for you. so setting MaxNoOfUniqueHashIndexes=1250 much lower than MaxNoOfTables=4096 is likely to run you into this "No more room in index file" message as soon as or before you have 1250 tables. I had exact same problem and increasing MaxNoOfOrderedIndexes to 1024 did indeed do the trick
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值