Problem running conversion rate project query
Is that when I run the query, I get the message 2013 indicating that the mysql server connection has been lost during the query, could you help me?![](https://365datascience.com/resources/qa-hub/thumb@1170_dwxj73u8qt.webp)
![](https://365datascience.com/resources/qa-hub/thumb@1170_dwxj73u8qt.webp)
1 answers ( 0 marked as helpful)
Hi Juan!
Thanks for reaching out.
This error message can be resolved with the following steps:
1) Increase timeout: SET GLOBAL wait_timeout = 300;
2) Check network stability.
3) Optimize the query to reduce execution time.
4) Increase max_allowed_packet in MySQL configuration file: max_allowed_packet=64M
Restart the server after changes.
Hope this helps.
Best,
Tsvetelin
Thanks for reaching out.
This error message can be resolved with the following steps:
1) Increase timeout: SET GLOBAL wait_timeout = 300;
2) Check network stability.
3) Optimize the query to reduce execution time.
4) Increase max_allowed_packet in MySQL configuration file: max_allowed_packet=64M
Restart the server after changes.
Hope this helps.
Best,
Tsvetelin