You are thinking about adding a read timeout on queries for your MySQL instance because you want to limit how long queries can run on your instance. What is a reasonable limit for the read timeout?
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.