FW: mysql performance

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?

Thanks for any responses,
Dan Herron
Sr. Programmer Analyst
Kittle's Home Furnishings
8600 N Allisonville Rd.
Indianapolis, Indiana 46250

=20
=20

-----Original Message-----
From: Jorge Bastos [mailto:mysql.jorge@decimal.pt]=20
Sent: Saturday, July 29, 2006 6:59 PM
To: win32@lists.mysql.com
Subject: Re: mysql performance

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.

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: FW: mysql performance

On 7/29/06, Herron, Dan wrote:
> How would one use the MySQL Administrator to check whether this is set
> or not, and then turn it off/on?

Simply edit the configuration file, you don't sincerely expect to use
GUIs for this.

> Or does one have to completely reinstall MySQL to change the setting?

*lol* no way... Its a simple setting, check your config file, edit it, add:

skip-name-resolve

And its done... Also, if you need to ask this, read the MySQL Manual.

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
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: FW: mysql performance

Just another way for your ref: I added all clients' IP and their name in
"hosts" file on the server (E:\WINNT\system32\drivers\etc), then these
listed clients are connect fast.


Daniel da Veiga wrote:
> On 7/29/06, Herron, Dan wrote:
>> How would one use the MySQL Administrator to check whether this is set
>> or not, and then turn it off/on?
>
> Simply edit the configuration file, you don't sincerely expect to use
> GUIs for this.
>
>> Or does one have to completely reinstall MySQL to change the setting?
>
> *lol* no way... Its a simple setting, check your config file, edit it, add:
>
> skip-name-resolve
>
> And its done... Also, if you need to ask this, read the MySQL Manual.
>


--
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