mysql - mysqld-nt.exe exist in task list,but actually it's not running? -
Have you ever stepped into such a problem?
I tried:
Telnet localhost 3306
and it fails to connect.
I can see mysqld-nt.exe
in the task manager (I'm using the windows platform).
So I restarted the server, and it's okay.
Does this happen every day, any thoughts? Edit
: 16 [note] D: \ MySQL \ MySQL server 5.0 \ bin \ mysqld-nt: normal shutdown
100122 10:11:16 InnoDB: start shutting down ... 100122 10: 11:18 InnoDB: shutdown complete; Log Sequence Number 0 22939338 100122 10:11:18 [Note] D: \ MySQL \ MySQL Server 5.0 \ bin \ mysqld-nt: Shut down complete
100122 10:12:40 Inodb: Start; Log sequence number 0 22939338 100122 10:12:42 [Note] D: \ MySQL \ MySQL Server 5.0 \ bin \ mysqld-nt: ready for connection. 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: General Closure
100123 16:20:44 INODB: Starting to stop ... 100123 16:20:46 INODB: shutdown is complete; Log sequence number 0 22 9 39832 100123 16:20:46 [Note] D: \ MySQL \ MySQL Server 5.0 \ bin \ mysqld-nt: shutdown complete
100123 16:22:09 Inodbie: Start; Log sequence number 0 22 9 39832 100123 16:22:11 [Note] D: \ MySQL \ MySQL Server 5.0 \ bin \ mysqld-nt: ready for connection. Version: '5.0.24-Community-NT' Socket: '' Port: 3306 MySQL Community Edition (GPL) 100125 9: 189 [Note] D: \ MySQL \ MySQL Server 5.0 \ bin \ mysqld-nt: Normal Close < / P>
100125 9: 18 9 NODB: Starting to stop ... 1001259 9:19: NODB: shutdown is complete; Log sequence number 0 22 9 41001 100125 9:19:00 [Note] D: \ MySQL \ MySQL Server 5.0 \ bin \ mysqld-nt: shutdown full
100129 9:22: InnoDB: Start; Log sequence number 0 22 9 41001 100125 9:20:25 [Note] D: \ MySQL \ MySQL Server 5.0 \ bin \ mysqld-nt: ready for connection. Version: '5.0.24-Community-NT' Socket: '' Port: 3306 MySQL Community Edition (GPL)
Looks like the network connection of mysqld-nt is ending, so the telnet fails and there are ways to restart it, are you using a lot of connections, allowed for the server / Try to increase the attached connections.
Hope this helps, Best regards, Tom.
Comments
Post a Comment