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?
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