asked on ALL long queries on localhost
Large query
Error Code: 2013. Lost connection to MySQL server during query
600.510 sec
I am using mysql on windows on localhost
using mysql workbench query editor
how can I extend query timeout
I do not wish to modify current query because
I am looking for an answer for all queries.
Error Code: 2013. Lost connection to MySQL server during query
600.510 sec
I am using mysql on windows on localhost
using mysql workbench query editor
how can I extend query timeout
I do not wish to modify current query because
I am looking for an answer for all queries.
MySQL Server
Last Comment
rgb192
ASKER
Where would i find my.ini? I do not know what folder i installed mysql or which mysql (i have zend and wamp ) that i am accessing using workbench
ASKER
Finding my.ini is a related question
https://www.experts-exchange.com/questions/28312933/looking-for-my-ini-that-I-am-using-in-mysql-workbench.html
So once I find my.ini, I can respond to this question.
https://www.experts-exchange.com/questions/28312933/looking-for-my-ini-that-I-am-using-in-mysql-workbench.html
So once I find my.ini, I can respond to this question.
A query that runs for 600 seconds might have something wrong. EXPLAIN SELECT might give you a hint about what MySQL is doing with its time. See also this article:
https://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html
https://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html
If you have wampserver installed, there should be an icon on the taskbar click it and select my.ini and it will open the ini in notepad.
Cd&
Cd&
ASKER
note: this is xampp and not wamp.
C:\xampp\ does not exist in windows explorer (even with show hidden files and folders).
I have zend php framework, xampp, wamp installed
![what is the option I change]()
C:\xampp\ does not exist in windows explorer (even with show hidden files and folders).
I have zend php framework, xampp, wamp installed
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This is the correct answer extending the query timeout time. I will keep on extending because there could be an error with the query but I know that I can eliminate all timeout times. Thanks
Cd&