binindex Posted May 22, 2007 Share Posted May 22, 2007 I moved my db to another system and used the same my.ini file from my old server. For some reason any query that takes over 30 seconds will get a connection lost. Even table repairs. Does anyone know how to fix this. I have windows xp and mysql 5.0.41 Quote Link to comment https://forums.phpfreaks.com/topic/52432-solved-connection-lost-during-queries-over-30-secs/ Share on other sites More sharing options...
fenway Posted May 23, 2007 Share Posted May 23, 2007 Lost connections have nothing to do with mysql, but rather with the server. Quote Link to comment https://forums.phpfreaks.com/topic/52432-solved-connection-lost-during-queries-over-30-secs/#findComment-260111 Share on other sites More sharing options...
binindex Posted May 25, 2007 Author Share Posted May 25, 2007 ok what can I change for this then. Any query whether it be a repair table or a select at the 30 second mark it says lost connection with server. I have tried with query browser and with a straight connect with the console mysql program. Quote Link to comment https://forums.phpfreaks.com/topic/52432-solved-connection-lost-during-queries-over-30-secs/#findComment-261238 Share on other sites More sharing options...
fenway Posted May 30, 2007 Share Posted May 30, 2007 I've never run a windows server before, but it's obviously a timeout somewhere. Quote Link to comment https://forums.phpfreaks.com/topic/52432-solved-connection-lost-during-queries-over-30-secs/#findComment-264859 Share on other sites More sharing options...
Bok Posted May 30, 2007 Share Posted May 30, 2007 Try altering the WAIT_TIMEOUT value in your ini. I had a similar problem and pushing this value up to 3600 solved it. Quote Link to comment https://forums.phpfreaks.com/topic/52432-solved-connection-lost-during-queries-over-30-secs/#findComment-265006 Share on other sites More sharing options...
binindex Posted May 31, 2007 Author Share Posted May 31, 2007 I have all values set to 28800 and it still don't help. After like 30 seconds it just stops. Don't matter if it's doing a repair table to whatever the server quits doing what its doing and I get a lost connection to server. But I don't find anything in the error log. Quote Link to comment https://forums.phpfreaks.com/topic/52432-solved-connection-lost-during-queries-over-30-secs/#findComment-265322 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.