nav-img
Advanced

Whether the max_allowed_packet Value of the Source Database Is Too Small

MySQL Serving as the Source

Table 1 Checking whether the max_allowed_packet value of the source database is too small

Check Item

Whether the max_allowed_packet value of the source database is too small

Description

If the max_allowed_packet value of the source database is too small, data migration may fail.

Item to Be Confirmed and Handling Suggestion

Potential problem: If there is a lot of data to be migrated or there are too many fields to be migrated, and the max_allowed_packet value of the source database is too small, then the migration task may fail.

Handling suggestion: Change the max_allowed_packet value of the source database to a value greater than 16777216.