Kill all Mysql processes?

David Beroff · Nov 9, 2017

I have a small website running on a shared hosting plan and sometimes it is overloaded on CPU and Mysql. I checked cPanel and see I can kill all Mysql processes there but I am not sure it will solve my issue? Anyone tell me is there a way to kill all Mysql processes that safer and effective?

24x7serverman · Nov 9, 2017

You can check the running MySQL processes by using below command -
mysqadmin -pr
or
ps aux | grep mysqld

Once you will get the processes with their ID then fire below command -
kill [signal or option] PID(s)
or
pkill process_id

You can also fire below command to find the processes with their PID -
ps -A

Please note, it is not recommended to play with the MySQL on the server, it may affect your server so be careful before proceeding.

WebReflex · Nov 9, 2017

David Beroff said:
I have a small website running on a shared hosting plan and sometimes it is overloaded on CPU and Mysql. I checked cPanel and see I can kill all Mysql processes there but I am not sure it will solve my issue? Anyone tell me is there a way to kill all Mysql processes that safer and effective?

Hi David

I can see that you are on shared hosting and exceeding your resources most of the time means It's time for you to upgrade to dedicated hosting which offers guaranteed resources for your website offering better experience for your visitors.

Killing MySQL Processes, you are denying your visitors the chance to use your website. If you are experiencing bot traffic, try a service like Cloudflare which acts as a guardian for your website from all bots and also improves website speed with CDN.

So recommend you to upgrade hosting or Install Cloudflare. Hope that helps !

Kill all Mysql processes?

David Beroff

Well-known member

24x7serverman

Well-known member

WebReflex

New member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud