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. This feature does not influence warnings delivered to a client. Please note that warning code needs to be a string:

mysql> SET GLOBAL log_warnings_suppress = '1592';
Query OK, 0 rows affected (0.00 sec)

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.

Download PDF Manual