在MySQL5.6引入了在线DDL,添加字段和辅助索引不锁表,但修改字段属性是锁表的。请见:http://hcymysql.blog.51cto.com/5223301/1370546如今在MySQL5.7,加强了
在MySQL5.6引入了在线DDL,添加字段和辅助索引不锁表,但修改字段属性是锁表的。请见:
如今在MySQL5.7,加强了修改varchar字段属性不锁表,例:
参考:
BTW:
MySQL5.7还支持更改索引名,不过实用性不高,谁没事闲得改索引的名字?例:
本文出自 “贺春旸的技术专栏” 博客,请务必保留此出处
Statement:The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn