mysql在一段时间后断开连接 [英] mysql Disconnected after time

问题描述

MYSQL停止一段时间后没有用户连接到MySQL服务器有什么问题我不知道是MySQL问题，因为在java中我正确连接。





我的错误是一段时间我需要手动重启MySQL服务后10分钟后工作完美同样存在问题



请帮忙我

MYSQL Stop After some time when no of user connected to MySQL server what is problem I don't know is that MySQL problem because in java I connect properly.


my error is some time I need to manually restart MySQL service after time it work perfect after 10 min same problem exist

please help me

推荐答案

请检查mysql服务器上的负载。并且还建议检查它是否是开放的线程/连接问题。



要检查相同而不是重新启动mysql数据库，请重新启动java应用程序并检查它是否正常工作。如果是这样，那么你需要照顾开放的连接。



如果仍然面临同样的问题。请求在mysql DBA的帮助下检查mysql会话计数。



问候，

Panduranga。

Please check the load on mysql server. And also suggest to check is it the open thread/connections issue.

To check the same instead of restarting the mysql db, restart the java application and check is it working. If so then you need to take care of open connections.

If still face the same issue. request to check the mysql session count with the help of mysql DBA.

Regards,
Panduranga.

从MYSQL 5.1升级到5.6



我解决自我升级最新版本。

upgrade from MYSQL 5.1 to 5.6

I Solve my self to upgrade latest version.

这篇关于mysql在一段时间后断开连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！