What is the meaning of the following MySQL warning:
Statement may not be safe to log in statement format.
I have some tens of thousands of these statements every day in my
mysqld.err file, and I'm not sure where should I begin my investigation.
This means that your binary log format
You can get a good idea of different types of these non-deterministic statements by looking at how the
There is another reason for
My employer has a DB Client who is always running a query like this
This query will succeed on a DB Server. However, if you are using MySQL Replication, this could present data inconsistency problems because when either
In other words :
The way around this would be to do what @DTest just recommended : Change the binlog_format to ROW. (+1 for @DTest for going straight to the solution)