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!

Remote MySQL latency very high

Discussion in 'Database Discussion' started by Gareth-AWD, Apr 24, 2018.

  1. Gareth-AWD

    Gareth-AWD Well-Known Member

    Joined:
    Jul 3, 2008
    Messages:
    174
    Likes Received:
    4
    Trophy Points:
    68
    Location:
    London, UK
    cPanel Access Level:
    Root Administrator
    Having severe delay when connecting to cPanel MySQL using remote SQL.

    I had this problem a couple of years ago and decided it must have been my legacy scripts causing the issue. I've since rewritten my connection scripts using PDO and the problem still remains across all my cPanel servers.

    If I run my new development on the cPanel server running localhost I get a total executive time of 8ms which is very fast.

    If I run on my local machine but set to the IP of my server the total script execution time is 600ms.

    It can't be anything local on my Wamp as on my Mac with MacOS's native install of PHP it does exactly the same thing.

    Is there any way to speed up the connection? I disabled the firewall too so no issues from that.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Gareth-AWD,

    The type of issue you described typically relates to the connection between the cPanel server and the remote server. For instance, have you tried running the "traceroute" command from your local server to the cPanel server to see the results? How far away are the two servers geographically?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Gareth-AWD

    Gareth-AWD Well-Known Member

    Joined:
    Jul 3, 2008
    Messages:
    174
    Likes Received:
    4
    Trophy Points:
    68
    Location:
    London, UK
    cPanel Access Level:
    Root Administrator
    Thanks for the feedback. I appreciate I'm using non server based broadband to connect but thought 600-1000ms was high. I tried two locations with similar results and we're about 100 miles away from where the server is.

    General delay of pinging the server is about 80-100ms. It seems to just be when connecting to MySQL is the issue.
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice