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.
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.