ps:12月27日 今日有点时间,在mysql官网上发现一段文字
For MyISAM tables, key updating can be controlled explicitly. UseALTER TABLE ... DISABLE KEYS to tell MySQL to stop updating nonunique indexes. Then useALTER TABLE ... ENABLE KEYS to re-create missing indexes.MyISAM does this with a special algorithm that is much faster than inserting keys one by one, so disabling keys before performing bulk insert operations should give a considerable speedup. UsingALTER TABLE ... DISABLE KEYS requires the INDEX privilege in addition to the privileges mentioned earlier.
这意思是今后myisam 才支持 DISABLE KEYS操作,什么神马节奏?
9797

被折叠的 条评论
为什么被折叠?



