Re: does 'disable networking' make mySQL faster?

2008-01-13 Thread Moon's Father
Of course faster than before. 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 sec

does 'disable networking' make mySQL faster?

2008-01-13 Thread Daevid Vincent
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. > -Original Message- > From: Manuel Lemos [mailto:[EMAIL PROTECTED]

Selecting virtual rows

2008-01-13 Thread Steffan A. Cline
I am working on a query where I need to get a certain number of rows based on a setting BUT if the number limited does not exist then return nulls instead. SELECT ca.filename,ca.attributeid FROM companyattributes ca WHERE ca.companyid=1234 LIMIT (SELECT at.LimitMovies FROM accounttypes AS at LEFT

issues with replicating stored routines or triggers?

2008-01-13 Thread gengxy-douban
With MySQL's classic statement-based replication, there may be issues with replicating stored routines or triggers from : http://dev.mysql.com/doc/refman/5.1/en/replication-formats.html what's mean?