Login to Members Area

Choose the service you want to log in
     
24x7x365 Presence
1-888-289-2246
Live Chat

Hosting Blog

 

How to restart MySQL from the server if it is taking many connections

Steps to restart the MySQL service if it is taking many connections :-

step1  pgrep mysql (it will show the processes' ids)
step2  pgrep mysql > mysql.txt
step3  for i in `cat mysql.txt`; do { kill -9 $i; }; done;
step4  /etc/init.d/mysql start

Abhishek Wednesday 25 September 2013 - 8:18 pm | | Default
Used tags: , , , , , ,

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
« Steps to restart the … | Home | Problem with Windows … »