Suppress Warning Messages

This feature is intended to provide a general mechanism (using log_warnings_silence) to disable certain warning messages to the log file. Currently, it is only implemented for disabling message #1592 warnings.

Version Specific Information

• 5.5.8-20.0: System variable log_warnings_silence introduced.
• 5.5.10-20.1: Renamed variable log_warnings_silence to log_warnings_suppress.

System Variables

variable log_warnings_suppress

Version Info:

• 5.5.8-20.0 – Introduced.
• 5.5.10-20.1 – Renamed.

Command Line:

Yes

Config File:

Yes

Scope:

Global

Dynamic:

Yes

Variable Type:

SET

Default Value:

(empty string)

Range:

(empty string), 1592

This variable was added in beta release 5.5.8-20.0 as log_warnings_silence and renamed in release 5.5.10-20.1.

It is intended to provide a more general mechanism for disabling warnings than existed previously with variable suppress_log_warning_1592.

When set to the empty string, no warnings are disabled. When set to 1592, warning #1592 messages (unsafe statement for binary logging) are suppressed.

In the future, the ability to optionally disable additional warnings may also be added.

Related Reading

• MySQL bug 42851
• MySQL InnoDB replication
• InnoDB Startup Options and System Variables
• InnoDB Error Handling