Sample Header Ad - 728x90

Do too many subquries create multiple sleeping processes in MySQL?

1 vote
1 answer
881 views
I am using java & MySQL to make an app. When I check the process list. I see a lot of sleeping processes. It also reaches to a points when no further connection is allowed. I have read many answers around which tell the command to masskill the process or some suggests checking the code for bug. I have checked that I'm closing the connections properly using the Apache Commons DbUtils. DbUtils.closeQuietly(rs); DbUtils.closeQuietly(statement); DbUtils.closeQuietly(con); I am not able to figure out why these processes don't get killed after closing the connection. My question is 1. Do too many subquries create multiple sleeping processes in MySQL? I don't see much relation though and didn't find anything on search. 2. Does passing connection object through methods create extra/multiple processes? Regards
Asked by Shekhar Sahu (111 rep)
Jun 30, 2017, 03:56 PM
Last activity: Jun 20, 2024, 11:02 PM