MYSQL remote connections
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
-
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. 0 -
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 0 -
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. 0
Please sign in to leave a comment.
Comments
3 comments