Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed a LAMP server and enabled MySQL remote connections but I'm experiencing really bad response times when connecting to the database remotely from a WordPress install.

I've been looking around for hours for a solution but all I could find had to do with setting "skip-host-cache" and "skip-name-resolve" to true. I've done that and I'm accessing the server via IP, but the problem still persists.

Server Details:

  • Ubuntu 12.04
  • Apache 2.2.22
  • MySQL 5.5.24

There are only a handful of people accessing the server so load isn't an issue either.

I'd really appreciate some help with this.

share|improve this question
Can the remote MySQL server resolve DNS? What is the last mile connectivity on each server, – Ben Lessani - Sonassi Oct 2 '12 at 8:03
The MySQL server shouldn't be doing any DNS resolution because "skip-name-resolve" is set to true. The last mile connectivity on each server is a "standard" business ADSL connection (I'm unsure of the specifics, I'll have to wait until tomorrow to get more detailed information). – Greg Antowski Oct 2 '12 at 8:48
It still needs to resolve DNS regardless of whether you have set that flag or not. Given its over commodity ADSL connections - its not much of a surprise that its slow. – Ben Lessani - Sonassi Oct 2 '12 at 9:25
Please define: "slow response". Is connecting slow? Is transferring the data slow? Do the queries take ages to complete? – Bobby Oct 2 '12 at 10:05
Sadly, I'm starting to think you might be right, sonassi. @Bobby The queries complete very quickly and connecting to the server is fairly fast as well. The slowness seems to come from the actual data transfer. – Greg Antowski Oct 2 '12 at 10:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.