Ldbeaudoin

Member
Apr 13, 2017
6
0
1
Quebec
cPanel Access Level
Root Administrator
Hi,

I have a server that is overloading for the past few weeks. We are moving clients to another server because there's too many. However, i've seen this multiple times in "mysqladmin process" :

| 206483 | axxxmor_gerard | 208.111.xx.xxx:57176 | | Sleep | 2768 | | |
| 206491 | axxxmor_gerard | 208.111..xx.xxx:57177 | axxxmor_site | Sleep | 66 | | |
| 206532 | axxxmor_gerard | 208.111..xx.xxx:57178 | axxxmor_site | Sleep | 28 | | |
| 207065 | axxxmor_gerard | 208.111..xx.xxx:57180 | axxxmor_site | Sleep | 603 | | |
| 214053 | axxxmor_gerard | 208.111..xx.xxx:57363 | axxxmor_site | Sleep | 65 | |

Can this cause performance issues in our mutualised server ? Also, if any of you have any tips on how to find the cause of an overload beside the "top" command that would be more than welcome.

Thanks
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463

SysSachin

Well-Known Member
Aug 23, 2015
604
48
28
India
cPanel Access Level
Root Administrator
Twitter
you can also go with the mysql governor.

It really helps to lower down the mysql processes.

You can have the detailed instructions here :-

CloudLinux Documentation
 

24x7server

Well-Known Member
Apr 17, 2013
1,911
96
78
India
cPanel Access Level
Root Administrator
Twitter
Hi,

Alternative to the top command, you can use iotop command to check the input/output ratio, so you can see how well the disk is doing when it comes to writing and reading on what processes of the server.