CODEWITHSUNDEEP
phpmysqlmysqli
eddow
eddow

Reputation: 430

mysqli_connect latency

I just recently had to reinstall my wamp package so I end up with a fresh apache 2.2.22, php 5.4.3 and mysql 5.5.24 .

One big change who occured was the page generation time. I dug a bit and found out that the call to mysqli_connect was taking up to 2 seconds.

So it still works, so my users have been well reconfigured and the whole system stands up - only this detail who make the whole unusable.

Does anyone knows where this latency could come from?

EDIT: it seems to be a dns problem as you proposed - Now, if I change to 127.0.0.1 I have an access-denied. I keep on digging

Upvotes: 4

Views: 1056

Answers (2)

user1812374
user1812374

Reputation: 1

Well wildcards on C:\Windows\System32\drivers\etc\hosts slowed every my request to 1s and more,

Handling multiple localhost names comma separated was horror (something with win7 DNS regexp)

127.0.0.1 localhost, domain.com

Spliting it i got again nice response without delay

127.0.0.1 localhost
127.0.0.1 domain.com

Upvotes: 0

Xavier.be
Xavier.be

Reputation: 81

I had the same exact, i was connecting to "localhost" and i had 1.5 sec for each "connect", now i'm using 127.0.0.1 instead and it works great now ! FIY, tested with windows 2008 R2 x64 + plesk 11 php 5.3 (and php5.4 as well)

Upvotes: 8

Related Questions