When issuing a query on MySQL, I get a "Lost Connection" error.
ERROR 2013 (HY000) at line xx: Lost connection to MySQL server during query
Lost Connection error occurs when:
- You have network connectivity issues.
- Your query is taking too long to complete.
If you are consistently getting this error and queries are taking longer than 30 seconds (the default value for MySQL’s
net_read_timeout variable) to complete:
- Check for network connectivity issues.
- Revise your query to not send as much data, and therefore be faster.
- Split your query into multiple smaller queries.