Question

One or more connectors are failing. In the destination, the following warning task appears in the dashboard: Increase Query Timeout.

Environment

Destination: MySQL

Answer

To resolve this, there are a number of options:

1. Upgrade your MySQL instance with a longer timeout so it can support the queries.

2. Use a different warehouse type (the support team can help you migrate your connectors if you go with this option).

3. Create a new connector and sync the data historically again.

   More on this point: During incremental sync, some queries may be timing out because they are slightly more database resource intensive (e.g. UPDATE) in a non-performant database.

   If you create a new connector that syncs the data historically, it will issue INSERT queries instead which are faster. However, this will not guarantee that we will not hit this issue again though.

Our recommended solution is option 2 - to move to a different warehouse that can better support your connector syncs. 

Cause

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

As mentioned in our documentation, we do not recommend to use MySQL as a destination as it is known to run into these limitations. It is mainly recommended to use 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 data warehouse. We support MySQL data warehouse as a test environment. If you run into these limitations, you will need to migrate to a supported destination.