Kill all Mysql processes?

David Beroff

Well-known member
Registered
Joined
Jun 14, 2016
Messages
1,477
Points
63
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

Well-known member
Hosting Provider
Registered
Joined
Jul 25, 2017
Messages
651
Points
28
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

New member
Registered
Joined
Nov 9, 2017
Messages
1
Points
0
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 !
 
Recommended Threads
Replies
7
Views
3,186
Replies
11
Views
8,718
Replies
7
Views
2,423

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top