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@m.gmane.org

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=20
address reverse lookup.
installing mysql NT service like:
mysqld-nt --install MySQL --skip-name-resolve will stop search the OS =
dns=20
servers, wich some times are slow and then make mysql response slow.

------=_NextPart_000_006C_01C6B36B.0767BEF0--

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@m.gmane.org