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)

Version specific information

• 8.0.12-1: The feature was ported from Percona Server for MySQL 5.7

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.

Related reading

• MySQL bug 42851

• MySQL InnoDB replication

• InnoDB Startup Options and System Variables

• InnoDB Error Handling

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 consulting services , contact Percona Sales.

---

Last update: 2023-01-12