{"id":142,"date":"2013-09-25T20:18:00","date_gmt":"2013-09-25T20:18:00","guid":{"rendered":"http:\/\/245@jodohost.com\/\/blog\/"},"modified":"2013-09-25T20:18:00","modified_gmt":"2013-09-25T20:18:00","slug":"how-to-restart-mysql-from-the-server-if-it-is-taking-many-connections","status":"publish","type":"post","link":"http:\/\/www.jodohost.com\/blog\/index.php\/2013\/09\/25\/how-to-restart-mysql-from-the-server-if-it-is-taking-many-connections\/","title":{"rendered":"How to restart MySQL from the server if it is taking many connections"},"content":{"rendered":"<p>Steps to restart the MySQL service if it is taking many connections :-<\/p>\n<p>step1\u00a0 pgrep mysql (it will show the processes&#8217; ids)<br \/>step2\u00a0 pgrep mysql > mysql.txt<br \/>step3\u00a0 for i in `cat mysql.txt`; do { kill -9 $i; }; done;<br \/>step4\u00a0 \/etc\/init.d\/mysql start<\/p>\n<p> ]]><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steps to restart the MySQL service if it is taking many connections :- step1\u00a0 pgrep mysql (it will show the processes&#8217; ids)step2\u00a0 pgrep mysql > mysql.txtstep3\u00a0 for i in `cat mysql.txt`; do { kill -9 $i; }; done;step4\u00a0 \/etc\/init.d\/mysql start ]]&gt;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/142"}],"collection":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=142"}],"version-history":[{"count":0,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/142\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=142"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}