mysql Disconnected after time

Question

0.00/5 (No votes)

See more:

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

Posted 30-Jan-15 18:06pm

hareshdgr8

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pandu Rang · Answer 1 · 2015-02-02T22:32:00

Solution 1

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.

Posted 2-Feb-15 22:32pm

Pandu Rang

Comments

hareshdgr8 3-Feb-15 4:38am

not understand can you please explain me in depth

Pandu Rang 3-Feb-15 5:20am

Imagining you are using DB Pool to connect to MySQL DB. If the DB pool size is 10, and for every connection taken from the pool is not closed or returned to pool properly, then the available connections in pool will exhaust and it may appear that DB is down.

hence suggest first to restart the Java application and check.

If the issue is not with the java application, then we need to check the MySQL max connection variable size, the more details about the same can be found/seen in below link:

http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html

hareshdgr8 3-Feb-15 5:26am

sir, I restart java application same error occurred every time I have to restart MySQL Service and upto 5-10 min it work perfectly, after 5-10 min same problem exists.

Pandu Rang 3-Feb-15 8:56am

Can you give me brief idea like how many connection you are taking , what is the pool size and what is the max_connection variable size in MySQL DB.

hareshdgr8 · Answer 2 · 2015-02-15T21:39:00

Solution 2

upgrade from MYSQL 5.1 to 5.6

I Solve my self to upgrade latest version.

Posted 15-Feb-15 21:39pm

hareshdgr8