Issue

If you are considering limiting how long queries can run by adding a read timeout on queries for your MySQL instance, the article below will help to cover some important considerations for setting a reasonable limit.

Environment

Connector: MySQL

Resolution

The time it takes for our queries to complete depends on a few different things and varies from one instance to another.

A few things that can impact query performance:

• The volume of data
• Network Latency
• Size of the environment

We normally recommend customers set any timeout parameter to 1 hour in order for our queries to complete without interruption and if needed, increase that parameter by an additional hour.