Resolving The Following Error: "Lost Connection To MySQL Server During Query"
The above error may occur as a result of a timeout on the SQL server. This is more likely to happen when one or more of the following conditions apply:
- The MySQL server is at a remote location (possibly with poor network connectivity)
- Heavy network traffic
- The query comprises a large amount of data (rows)
- There are many query requests from Sisense to the MySQL server
To avoid the error, we recommend that your DBA increase the time limits of the following parameters in the MySQL server:
- net_read_timeout
- net_write_timeout
- Interactive_timeout
- wait_timeout
We recommend increasing the 60 second default to atleast 10 minutes, check, and if needed, increase the limit depending on your environment.
More information can be found in the MySQL documentation.
Updated 03-02-2023
