RE: mysql performance - Kerry Frater - com.mysql.lists.win32

8 messages in com.mysql.lists.win32RE: mysql performance

From	Sent On	Attachments
Ray	29 Jul 2006 11:44
Jorge Bastos	29 Jul 2006 15:59
Herron, Dan	29 Jul 2006 17:58
Daniel da Veiga	29 Jul 2006 19:40
Jorge Bastos	30 Jul 2006 01:50
Kerry Frater	30 Jul 2006 02:49
Dennis Yu	30 Jul 2006 19:45
Ray	30 Jul 2006 22:15

Subject:	RE: mysql performance
From:	Kerry Frater (ker...@wannaemail.com)
Date:	07/30/2006 02:49:31 AM
List:	com.mysql.lists.win32

If you have/use the MySQL Administrator (I have version 1.1) then it is an option in the Networking section.

-----Original Message----- From: Jorge Bastos [mailto:mysq...@decimal.pt] Sent: 30 July 2006 09:51 To: win...@lists.mysql.com Subject: Fw: mysql performance

Like Daniel said, or mysqld-nt --remove MySQL

mysqld-nt --install MySQL --skip-name-resolve

How would one use the MySQL Administrator to check whether this is set or not, and then turn it off/on? Or does one have to completely reinstall MySQL to change the setting?

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.