What Read Timeout Value Should I Set for Queries on My MySQL Instance?

Question

What read timeout value should I set for queries on my MySQL instance?

Environment

Connector: MySQL

Answer

Here are a few things that can impact query performance:

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

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