From: Daevid Vincent Date: January 15 2008 9:41pm Subject: RE: does 'disable networking' make mySQL faster? List-Archive: http://lists.mysql.com/mysql/210841 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0178_01C8577C.63E08980" ------=_NextPart_000_0178_01C8577C.63E08980 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 assinine. 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 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 it?! >> 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. Why? Any Source? using sockets is possible faster than using networking, but why should disable networking speedup MySQL? -- Sebastian -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn ------=_NextPart_000_0178_01C8577C.63E08980--