Remote MySQL connections slow

Gareth-AWD

• February 04, 2016 05:35

I'm having a problem with remote MySQL connections. I set up the local IP to access it but a page load takes about 5 seconds before you see it. If I run the php files on the server it's lightening fast. I've changed the my.cnf to skip-name-resolve as I heard that causes issues, but still it's slow. I also put my SQL connection to the IP as well as the server.domain.com but still the same. Any ideas?

• 

  cPanelMichael

  • February 04, 2016 17:49

  Hello :) Have you tried utilizing the "traceroute" utility from your server to the remote MySQL server to see if there's any issue with the connection between the two servers? Traceroute Enable/Disable - Documentation - cPanel Documentation Thank you.

  0

Please sign in to leave a comment.