Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MYSQL remote connections

Discussion in 'Database Discussions' started by Ldbeaudoin, Oct 26, 2017.

  1. Ldbeaudoin

    Ldbeaudoin Registered

    Joined:
    Apr 13, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,437
    Likes Received:
    1,608
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
  3. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    604
    Likes Received:
    41
    Trophy Points:
    28
    Location:
    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
     
  4. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,677
    Likes Received:
    73
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page