mysql 长连接断开,mysql在一段时间后断开连接

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

解决方案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.

upgrade from MYSQL 5.1 to 5.6

I Solve my self to upgrade latest version.