2017년 2월 28일 화요일

MySQL log_warnings 값 설정

MySQL log_warnings 값 설정


아래 처럼 에러 로그가 너무 빈번히 발생한다면 log_warnings 변수의 값을 확인해서 변경해주면 됩니다.

170228 13:28:43 [Warning] Statement may not be safe to log in statement format. Statement: insert
170228 13:28:43 [Warning] Statement may not be safe to log in statement format. Statement: update
170228 13:28:43 [Warning] Statement may not be safe to log in statement format. Statement: insert
170228 13:28:52 [Warning] Statement may not be safe to log in statement format. Statement: insert
170228 13:28:52 [Warning] Statement may not be safe to log in statement format. Statement: update
170228 13:28:52 [Warning] Statement may not be safe to log in statement format. Statement: insert
170228 13:29:35 [Warning] Statement may not be safe to log in statement format. Statement: insert
170228 13:29:35 [Warning] Statement may not be safe to log in statement format. Statement: update
170228 13:29:35 [Warning] Statement may not be safe to log in statement format. Statement: insert

show variables like 'log_warnings';

set global log_warnings = 0;