increase "MaxNoOfAttributes" into my ndb_mgm.confexample :DataMemory = 24G IndexMemory = 4G MaxNoOfOrderedIndexes = 1024 MaxNoOfAttributes = 10000 MaxNoOfTables = 2500 MaxNoOfConcurrentOperations = 250000 MaxNoOfConcurrentIndexOperations = 250000 reboot all machine.
后面是否要加个column呢
mysql navicat 工具上已经测试,跟column实际上是没有关系的,主要是添加的列名不应该加上引号!ALTER TABLE bill add column was_manual_override_made TINYINT(1) DEFAULT '0' AFTER id; 详细参考 create TABLE bill( id int(10) NOT NULL auto_increment, title VARCHAR(30) NOT NULL, atime int(11) NOT NULL, PRIMARY KEY(id) )ENGINE=myisam charset=utf8;ALTER TABLE bill ADD ccc varchar(200) NOT NULL AFTER title; ALTER TABLE bill ADD column content varchar(200) NOT NULL AFTER title; ALTER TABLE bill add column was_manual_override_made TINYINT(1) DEFAULT '0' AFTER id; DESC bill id int(10) NO PRI auto_increment was_manual_override_made tinyint(1) YES 0 title varchar(30) NO ddd varchar(200) NO ccc varchar(200) NO content varchar(200) NO atime int(11) NO
什么叫 "增加所能包含的命令" ? 无法准确楼主想表达的汉语含义。
如果楼主是想增长一个表中所能拥有的字段数,则只能自己去改写相关存储引擎的源代码。
ERROR 1005 (HY000): Error Can't create table 'mytable' (errno: 708)
增加MaxNoOfAttributes=5000 config.ini
into my ndb_mgm.confexample :DataMemory = 24G
IndexMemory = 4G
MaxNoOfOrderedIndexes = 1024
MaxNoOfAttributes = 10000
MaxNoOfTables = 2500
MaxNoOfConcurrentOperations = 250000
MaxNoOfConcurrentIndexOperations = 250000 reboot all machine.
详细参考
create TABLE bill(
id int(10) NOT NULL auto_increment,
title VARCHAR(30) NOT NULL,
atime int(11) NOT NULL,
PRIMARY KEY(id)
)ENGINE=myisam charset=utf8;ALTER TABLE bill ADD ccc varchar(200) NOT NULL AFTER title; ALTER TABLE bill ADD column content varchar(200) NOT NULL AFTER title; ALTER TABLE bill add column was_manual_override_made TINYINT(1) DEFAULT '0' AFTER id;
DESC bill
id int(10) NO PRI auto_increment
was_manual_override_made tinyint(1) YES 0
title varchar(30) NO
ddd varchar(200) NO
ccc varchar(200) NO
content varchar(200) NO
atime int(11) NO