mysql 8.0 alter table ALGORITHM [=] {DEFAULT|INSTANT|INPLACE|COPY}_mysql 8 alter table add index algorithm instant-CSDN博客

网站介绍:文章浏览阅读964次。The ALGORITHM clause is optional. If the ALGORITHM clause is omitted, MySQL uses ALGORITHM=INSTANT for storage engines and ALTER TABLE clauses that support it. Otherwise, ALGORITHM=INPLACE is used. If ALGORITHM=INPLACE is not supported, ALGORITHM=COPY is u_mysql 8 alter table add index algorithm instant