任务列表中存在mysqld-nt.exe,但实际上它没有运行?
你曾经遇到过这样的问题吗?
我尝试过:
telnet localhost 3306
但无法连接。
我可以在任务管理器中看到mysqld-nt.exe
(我使用的是Windows平台)。
于是我重启了服务器,就ok了。
这种事每天都会发生。有什么想法吗?
编辑
这是错误日志(不过我没有发现任何异常):
100122 10:11:16 [注]D:\MySQL\MySQL 服务器5.0\bin\mysqld-nt:正常 关闭
100122 10:11:16 InnoDB:启动 关闭... 100122 10:11:18 InnoDB: 关机完成;日志序列 号码 0 22939338 100122 10:11:18 [注] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: 关闭完成
100122 10:12:40 InnoDB:已启动;日志 序列号 0 22939338 100122 10:12:42 【注】D:\MySQL\MySQL Server 5.0\bin\mysqld-nt:准备连接。版本: '5.0.24-community-nt' 套接字:'' 端口:3306 MySQL社区版 (GPL) 100123 16:20:44 [注] D:\MySQL\MySQL 服务器 5.0\bin\mysqld-nt: 正常关闭
100123 16:20:44 InnoDB:启动 关闭... 100123 16:20:46 InnoDB: 关机完成;日志序列 号码 0 22939832 100123 16:20:46 [注] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: 关闭完成
100123 16:22:09 InnoDB:已启动;日志 序列号 0 22939832 100123 16:22:11 【注】D:\MySQL\MySQL Server 5.0\bin\mysqld-nt:准备连接。版本: '5.0.24-community-nt' 套接字:'' 端口:3306 MySQL社区版 (GPL) 100125 9:18:59 [注] D:\MySQL\MySQL 服务器 5.0\bin\mysqld-nt: 正常关闭
100125 9:18:59 InnoDB:启动 关闭... 100125 9:19:00 InnoDB: 关机完成;日志序列 号码 0 22941001 100125 9:19:00 [注] D:\MySQL\MySQL Server 5.0\bin\mysqld-nt: 关闭完成
100125 9:20:22 InnoDB:已启动;日志 序列号 0 22941001 100125 9:20:25 【注】D:\MySQL\MySQL Server 5.0\bin\mysqld-nt:准备连接。版本: '5.0.24-community-nt' 套接字:'' 端口:3306 MySQL社区版 (GPL)
Have you ever step into this kind of problem?
I tried:
telnet localhost 3306
And it fails to connect.
I can see mysqld-nt.exe
in the task manager(I'm using windows platform).
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
shutdown100122 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 complete100122 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 shutdown100123 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 complete100123 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 shutdown100125 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 complete100125 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)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
听起来 mysqld-nt 的网络连接正在耗尽,因此 telnet 失败并重新启动可以解决它,您是否使用了太多连接,请尝试增加服务器本身允许/允许的连接。
希望这有帮助,
此致,
汤姆.
Sounds like the mysqld-nt's network connections are being exhausted hence the telnet fails and a restart cures it, are you using too many connections, try increasing the connections allowed/permitted for the server itself.
Hope this helps,
Best regards,
Tom.