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:[EMAIL PROTECTED] Sent: Tuesday, January 15, 2008 1:44 AM To: Sebastian Mendel Cc: Daevid Vincent; mysql@lists.mysql.com 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 <[EMAIL PROTECTED]> wrote: Moon's Father schrieb: > > On Jan 14, 2008 7:00 AM, Daevid Vincent < [EMAIL PROTECTED]> 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:[EMAIL PROTECTED] >>> Sent: Saturday, January 12, 2008 12:57 PM >>> To: [EMAIL PROTECTED] >>> 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
