kill ALL mysql processes
Moderator: General Moderators
kill ALL mysql processes
Anyone know how to do this? or at least how to kill all sleep connections
Thanks!
Thanks!
- AKA Panama Jack
- Forum Regular
- Posts: 878
- Joined: Mon Nov 14, 2005 4:21 pm
They will normally timeout on their own. BTW, if you are using persistent connections you might want to change to normal connections. What with the changes in how Mysql works persistent connections are not faster and do not save any processing time but they do eat up memory and can cause mysql to run out of available connections. This will cause the some people to see the too many connection error when they try to access the site.
If you are using persistent connections you really should stop. Honestly the only reason I think they still keep it is for backwards compatibility.
If you are using persistent connections you really should stop. Honestly the only reason I think they still keep it is for backwards compatibility.
Just wanted to come back to this, i have tons of sleeping processes still and no where can I find out how to kill them all.. or disable them.. I'm not entirely sure what this even means, i just know that my server seems to be running quite slow and i have all these processes running.
Is there an ideal way to setup everything if it will be highly transactional to prevent this from happening in the future?
Is there an ideal way to setup everything if it will be highly transactional to prevent this from happening in the future?
Okay, I was able to kill all processes using
Now the question is how to prevent sleeping threads from occurring in the future!
Code: Select all
ps ax | grep mysqld
then
kill -9 PID#Now the question is how to prevent sleeping threads from occurring in the future!