Table of Contents
Patch: suppress_log_warning_1592
In some circumstances MySQL will warn you that a statement is unsafe to replicate whereas it is perfectly safe:
090213 16:58:54 [Warning] Statement is not safe to log in statement format.
This has no effect on replication (see the discussion on MySQL's bugzilla) but it can fill up your error log with unnecessary messages.
This patch allows you to completely disable logging of this warning.
NOTE Only MySQL 5.1 is subject to this bug. A partial solution has been published from MySQL 5.1.37, but this bug still appears in some situations.
All warnings #1592 will be disabled so you will not be able to know if your statements are really safe to replicate anymore. Use it at your own risk and only if you understand what you are doing.
Version-Specific Information
| Percona-Server Version | Comments |
|---|---|
| 5.1.47-11.0 | Full functionality available. |
Variables Provided
suppress_log_warning_1592
| Type | System and command-line variable |
| Scope | Global |
| Dynamic | Yes |
| Default | OFF |
Disables warning #1592 (unsafe statement for binary logging).
Related Reading
Except where otherwise noted, content on this wiki is licensed under the following license:GNU Free Documentation License 1.2
Please report bugs to https://bugs.launchpad.net/percona-project/+filebug and ask general questions in maillist Percona-discussions
Discussion