Skip to content

Rate this page
Thanks for your feedback
Thank you! The feedback has been submitted.

For help, click the link below to get free database assistance or contact our experts for personalized support.

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';
Expected output
Query OK, 0 rows affected (0.00 sec)

System variables

log_warnings_suppress

Option Description
Command-line Yes
Config file Yes
Scope Global
Dynamic Yes
Data type SET
Default (empty string)
Range (empty string), 1592

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.