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
]]>
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
]]>