mysql performance

Hello all;
I found this comment on the php website:


If you are experiencing extremely slow connections to MySQL from PHP from
a Windows 2003 Server it may well not be PHP or IIS - try loading mysql in
in 'skip-name-resolve'-Mode.

It may mean the difference between a 10 second load time and a split
second load time.
(source: http://ca3.php.net/mysql)

is there any truth to this, and if so, how do I do this?
Ray



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
ray [ Sa, 29 Juli 2006 20:44 ] [ ID #1409661 ]

Re: mysql performance

------=_NextPart_000_006C_01C6B36B.0767BEF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Yes it is,
That option is to mysql not search the dns's for the connect client ip
address reverse lookup.
installing mysql NT service like:
mysqld-nt --install MySQL --skip-name-resolve will stop search the OS =
dns
servers, wich some times are slow and then make mysql response slow.

------=_NextPart_000_006C_01C6B36B.0767BEF0--
Jorge Bastos [ So, 30 Juli 2006 00:59 ] [ ID #1410441 ]

RE: mysql performance

Thanks all for your help,
I like the way this list gives quick and clear answers.
Ray



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
ray [ Mo, 31 Juli 2006 07:15 ] [ ID #1411405 ]
Datenbanken » gmane.comp.db.mysql.windows » mysql performance

Vorheriges Thema: Migration tool and SQL2005
Nächstes Thema: FW: mysql performance