Suppress Warning Messages 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 variablelog_warnings_silenceintroduced.5.5.10-20.1: Renamed variablelog_warnings_silencetolog_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.
