EmergencyEMERGENCY? Get 24/7 Help Now!

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

System Variables

variable log_warnings_suppress
Version Info:
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.



General Inquiries

For general inquiries, please send us your question and someone will contact you.