MySQL 5.7 Online DDL Online DDL With the online DDL Prevent a table from becoming unavailable Adjust the balance between performance and concurrency by LOCK clause Less disk space usage and I/O overhead than table-copy MySQL act as below as possible. Choose the left option if possible rather than the right one. ALGORITHM = INPLACE | COPY LOCK = NONE | SHARED | EXCLUSIVE, DEFAULT TYPE QUERY DML NONE PERMIT PERMIT SHA.. 더보기 이전 1 2 3 4 5 ··· 349 다음