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_silence
introduced.5.5.10-20.1
: Renamed variablelog_warnings_silence
tolog_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.
Contact Us
For free technical help, visit the Percona Community Forum.To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.