lost connection to mysqlserver during query socket error on read .WSAGETLASTERROR return 10054 ($2746)

While I am creating constraint on mysql 5 from delphi 2006, it gives me the following error
"lost connection to mysqlserver during query socket error on read .WSAGETLASTERROR return 10054($2746)."
After that the mysql cannot connect to it unless I restart the mysql server on windows xp.  Any suggestion
nabil_zakkakAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

UmeshMySQL Principle Technical Support EngineerCommented:
Pls amke sure MySQ: server parameters are properly set (increase)

connect_timeout
interactive_timeout
net_read_timeout
net_write_timeout
slave_net_timeout
wait_timeout
max_connections
max_user_connections

MySQL docs..

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

and

http://dev.mysql.com/doc/refman/5.0/en/error-lost-connection.html
0
UmeshMySQL Principle Technical Support EngineerCommented:
Pls ignore this variable... 'slave_net_timeout'
0
nabil_zakkakAuthor Commented:
I did what u told me.  But this didn't solve the problem
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

UmeshMySQL Principle Technical Support EngineerCommented:
Where did you set these parameters?
 in my.cnf(my.ini if windows) or from mysql prompt?

mysql>SET GLOBAL connect_timeout = 20;
0
nabil_zakkakAuthor Commented:
in my.ini because i am using windows
0
UmeshMySQL Principle Technical Support EngineerCommented:
yes , that's correct...on windows my.ini

Are you on windows... then I'm sure its not an MySQL fault... may be some windows settings is just causing this.. I'll post you the tread similar to this..at the end user noticed that some windows setting was the problem
0
UmeshMySQL Principle Technical Support EngineerCommented:
Also, I wan to see the erro log... it would be nice if you can get me the error log during in which you got below error

lost connection to mysqlserver during query socket error on read .WSAGETLASTERROR return 10054 ($2746)

This may help you...

http://dev.mysql.com/doc/mysql-windows-excerpt/6.0/en/can-not-connect-to-server-on-windows.html
0
nabil_zakkakAuthor Commented:
The problem is not showing any more.  I don't know why
0
UmeshMySQL Principle Technical Support EngineerCommented:
Cool...

Thanks,
Umesh
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Editors IDEs

From novice to tech pro — start learning today.