데이터베이스/MySql
Warning Code : 1478InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope.InnoDB: assuming ROW_FORMAT=COMPACT.
ShyK
2022. 10. 27. 14:16
반응형
Warning Code : 1478InnoDB: ROW_FORMAT=DYNAMIC requires innodb_file_format > Antelope.InnoDB: assuming ROW_FORMAT=COMPACT.
오류시 다음과 같이 확인한다.
Before 5.7, table cannot be created Dynamic row-format with innodb_file_format= Antelope (Returns warning and table is created as Compact row-format)
5.7 can create Dynamic row-format table even innodb_file_format= Antelope, without any warnings and actually SHOW TABLE STATUS returns Row_format= Dynamic.
5.7's code checks innodb_file_format only when ROW_FORMAT= Compressed.https://bugs.mysql.com/bug.php?id=83647
Mysql버전문제일 가능성도 있다
반응형