Hello.
Upgrade your MySQL. This is a bug:
http://bugs.mysql.com/bug.php?id=8471
Vincent MATHIEU <[EMAIL PROTECTED]> wrote:
> With mysql-max-4.1.7-pc-linux-i686 :
>
> If I start the mysqld with --skip-name-resolve, the following errors are
> writed in mysqld.l
With mysql-max-4.1.7-pc-linux-i686 :
If I start the mysqld with --skip-name-resolve, the following errors are
writed in mysqld.log :
050620 8:30:27 [Warning] 'host' entry
'194.214.218.192/255.255.255.224|%' ignored in --skip-name-resolve mode.
050620 8:30:27 [W
<[EMAIL PROTECTED]> wrote:
>> > Hi,
>> > Sometimes our Internet conection goes down and then all conections via
>> > tcp/ip to our the mysql server (v.4.1.5) are slow.
>> >
>> > I've read in the manual that one could use --skip-name-resolve as a
Well, we allready use ip numbers instead of host names in the grant
tables, but after setting the skip-name-resolve startup option
machines with Windows ( any flavor) are still slow when internet
connection goes down.
Still, I cant tell if the startup parameter (skip-name-resolve) has been
Mauricio Pellegrini wrote:
Is there a way to check whether this option is active or not, while the
server is running?
Not sure why it doesn't show up in "SHOW VARIABLES", but one way
to check would be to see whether the hosts in the "Host" column
of "SHOW PROCESSLIST" are shown as IP addresses or
windows-vs-unix.html
>
>
>
> Mauricio Pellegrini <[EMAIL PROTECTED]> wrote:
> > Hi,
> > Sometimes our Internet conection goes down and then all conections via
> > tcp/ip to our the mysql server (v.4.1.5) are slow.
> >
> > I've read in th
ow.
>
> I've read in the manual that one could use --skip-name-resolve as a
> possible solution to this problem under windows.
>
> The thing is that I've set this option int /etc/my.cnf in this way
>
> [mysqld]
> port= 3306
> socket
Hi,
Sometimes our Internet conection goes down and then all conections via
tcp/ip to our the mysql server (v.4.1.5) are slow.
I've read in the manual that one could use --skip-name-resolve as a
possible solution to this problem under windows.
The thing is that I've set this optio
Hello,
today one of our caching nameservers failed. Although a second
nameserver was listed in /etc/resolf.conf and mysqld was started with
--skip-name-resolv, mysql struggled and took very long to accept new
connections. It's obvious, that mysql is doing reverse-dns lookups
against what config
