Warning: Increase Query Timeout

Issue

One or more connectors are failing with the following warning in the dashboard:

Increase Query Timeout

Environment

MySQL destination

Resolution

To resolve this, you can do one of the following:

• Upgrade your MySQL instance with a longer timeout to support the queries.

• Use a different destination.

  NOTE: Our support team can help you migrate your connectors.

• Create a new connector and re-sync the historical data again.

  NOTE: During the incremental sync, some queries may time out because they are slightly more database resource intensive (for example, UPDATE) in a non-performant database. If you create a new connector that syncs the data historically, it will use INSERT queries instead, which are faster. However, this does not guarantee that you will not face this issue again.

We recommend using a different destination to support your connector syncs.

Cause

The connector is failing on the load operations to the MySQL database. This occurs as MySQL cannot support the queries to the database.

We recommend using something other than MySQL as a destination, as it is known to run into these limitations. Use MySQL as a test environment.

WARNING: MySQL database can fail to perform basic queries for even medium volumes of data and is not appropriate as a destination. We support MySQL database as a test environment. If you run into these limitations, you will need to migrate to a supported destination.