MYSQL remote connections

[Ldbeaudoin]

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]

Hello,

You may want to try tuning the MySQL configuration on the system. The following thread is a good place to start:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

For general load troubleshooting, check out this thread:

Troubleshooting high server loads on Linux servers

Thank you.

 

[SysSachin]

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]

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.