Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

mysqld-nt.exe is showing in the task manager, but I cannot connect to it.

I tried:

telnet localhost 3306

And it fails to connect.

So I restarted the server,and it's ok.

This happens every day. Any ideas?

EDIT

Here is the error log(I didn't find anything abnormal though):

100122 10:11:16 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

100122 10:11:16 InnoDB: Starting shutdown... 100122 10:11:18 InnoDB: Shutdown completed; log sequence number 0 22939338 100122 10:11:18 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

100122 10:12:40 InnoDB: Started; log sequence number 0 22939338 100122 10:12:42 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.24-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 100123 16:20:44 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

100123 16:20:44 InnoDB: Starting shutdown... 100123 16:20:46 InnoDB: Shutdown completed; log sequence number 0 22939832 100123 16:20:46 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

100123 16:22:09 InnoDB: Started; log sequence number 0 22939832 100123 16:22:11 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.24-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 100125 9:18:59 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

100125 9:18:59 InnoDB: Starting shutdown... 100125 9:19:00 InnoDB: Shutdown completed; log sequence number 0 22941001 100125 9:19:00 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

100125 9:20:22 InnoDB: Started; log sequence number 0 22941001 100125 9:20:25 [Note] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.24-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)

share|improve this question
    
What do the logs show? Have a look at both the Windows event logs and the MySQL logs. –  John Gardeniers Jan 25 '10 at 4:39
    
Are you running the daemon really hard? Set a scheduled task perhaps to check for mysqld update every 30 minutes and restart as necessary. –  darkAsPitch Feb 19 '10 at 14:21
    
Do you run an anti-virus and could that anti-virus be the problem? Also you say it happens every day does it happen at the same time and if yes are you running any kind of maintenance at that time? Do you do an offline DB backup maybe... –  Autobyte May 1 '10 at 23:44
1  
Next time it happens, run netstat -an in a command prompt and see if mysql is still listening on that port. –  DerfK Oct 23 '10 at 19:20
    
Which Windows version are you running? Is MySQL certified for the Windows Version you are using? –  hakre Mar 20 '11 at 15:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.