Skip to content
PERCONA MONITORING AND MANAGEMENT DOCUMENTATION

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

Get help from Percona

MySQL SQL mode not fitting best practice

Description

In order for the server to check data integrity, the sql_mode should have TRADITIONAL, STRICT_ALL_TABLES, and STRICT_TRANS_TABLES set in sql_mode.

The advisors raise an alert if one or more of them are missing.

Resolution

Set sql_mode in a way that it contains TRADITIONAL, STRICT_ALL_TABLES and STRICT_TRANS_TABLES.

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.