• 1-888-289-2246
  • 24x7x365 Presence

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

]]>


Leave a Reply

Your email address will not be published. Required fields are marked *