2019/11 썸네일형 리스트형 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.. 더보기 MySQL 5.7 SQL Modes sql_mode Default SQL mode NO_ENGINE_SUBSTITUTION From 5.7.5 ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES From 5.7.7 NO_AUTO_CREATE_USER From 5.7.8 NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_IN_DATE Set sql_mode in my.cnf sql-mode="value1,value2" dynamic SET GLOBAL sql_mode = 'modes'; SET SESSION sql_mode = 'modes'; Full List of SQL Modes (based on 5.7.23) Strict SQL mode STRICT_ALL_TABLES - Enab.. 더보기 이전 1 다음