Huh? This doesn't make any sense to me.
If I'm running a LAMP box (all services on the same box), and my PHP calls
out to the mySQL database, I would expect it to use the fastest method
possible (since it's LOCAL). If that's sockets, then that's what it should
use. I would think this to be a horrible design flaw if the mere fact that I
have networking enabled (for the times I want to connect SQLYog to the RDBMS
to manually run SQL commands) should NOT slow down or hurt my PHP
applications performance in any way, shape or form!? I seriously hope that
by turning on networking, mySQL isn't stupid enough to then start trying to
connect my PHP application to "localhost" via 127.0.0.1 or something equally
Please tell me this isn't the case.
From: Moon's Father [mailto:yueliangdao0608@stripped]
Sent: Tuesday, January 15, 2008 1:44 AM
To: Sebastian Mendel
Cc: Daevid Vincent; mysql@stripped
Subject: Re: does 'disable networking' make mySQL faster?
Because client's submit speed also affects servers's data.
On Jan 14, 2008 6:54 PM, Sebastian Mendel <lists@stripped> wrote:
Moon's Father schrieb:
> On Jan 14, 2008 7:00 AM, Daevid Vincent < daevid@stripped> wrote:
>> I saw this on the PHP list and was wondering if there is any merit to
>> I would be surprised if disabling networking made a difference. I'm only
>> concerned about the added speed. I get the security benefit of course.
>>> From: Manuel Lemos [mailto:mlemos@stripped]
>>> Sent: Saturday, January 12, 2008 12:57 PM
>>> To: php-general@stripped
>>> Subject: Re: [PHP] Re: SMTP vs mail()
>>> Every time I install MySQL on the same machine as the Web server, I
>>> disable networking to make it use Unix domain sockets, for either
>>> greater speed and security.
> Of course faster than before.
using sockets is possible faster than using networking, but why should
disable networking speedup MySQL?
I'm a mysql DBA in china.
More about me just visit here: