Documentation Home
MySQL Replication
Related Documentation Download this Excerpt
PDF (US Ltr) - 1.8Mb
PDF (A4) - 1.8Mb


4.1.18 Replication and LIMIT

Statement-based replication ofLIMIT clauses inDELETE,UPDATE, andINSERT ... SELECT statements is unsafe since the order of the rows affected is not defined. (Such statements can be replicated correctly with statement-based replication only if they also contain anORDER BY clause.) When such a statement is encountered:

  • When usingSTATEMENT mode, a warning that the statement is not safe for statement-based replication is now issued.

    When usingSTATEMENT mode, warnings are issued for DML statements containingLIMIT even when they also have anORDER BY clause (and so are made deterministic). This is a known issue. (Bug #42851)

  • When usingMIXED mode, the statement is now automatically replicated using row-based mode.