Resolved: It takes too long to run the code
Good morning. Every time I try to compile the "employees" file, at some time it gives me the error "Error code: 2013. Lost connection to MySQL server during query". The "Duration/Fetch" is always around 30 seconds where the error appears. Is there any way to increase that time to 1 minute for example? Are there any other ways to solve this problem? Thank you.
Hi Alessandro!
Thanks for reaching out.
New versions of MySQL WorkBench have an option to change specific timeouts.
Please go to Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600 Changed the value to 6000. This will solve the issue. Thank you.
Hope this helps.
Best,
Tsvetelin
Actually it has worked after a lot of attempts, but it will be useful for the next time. Thank you very much!
Hi Alessandro!
You are very welcome!
Best,
The 365 Team