Disable "unsafe instruction for binary log" in mysql

How to disable unsafe statement for binary loggingWarning message in error log in MySQL 5.5version.
I do not want to change the format binlogin Row or Mixed Mode.

In Perconaa variable log_warnings_suppress = 1592
Is there anything like that in MySQL?

Thanks,
Zola

+4
source share
2 answers

If you get this from DELETEs LIMIT, there is a workaround.

  • Do SELECTwith the same ORDER BYand LIMITto get idor a range of identifiers that you need to delete.
  • DELETE id IN ( ... ) id BETWEEN ... AND ....
0

@ircmaxwell ( ) , . " ", limit.. . "", "" "". , Percona "" .

0

Source: https://habr.com/ru/post/1543362/


All Articles