Question

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?

Environment

Connector: MySQL

Answer

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.