Donny Simonton wrote:
It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.
Reverse DNS is evil... :)
http://dev.mysql.com/doc/mysql/en/DNS.html
You can disable DNS hostname lookups by starting |mysqld| with the
|--skip-name-resolve| option. However, in this
It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.
Donny
> -Original Message-
> From: Frank Febbraro [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 07, 2004 3:23 PM
> To: Donny Simonton; [EMAIL PROTECTED]
> Subject: Re: MySQ
> I've been using mysql 4.1 since the first day it was out; it's all been
> trial and error. If I remember correctly, I found it on 4.1.0 when I was
> doing a processlist, and noticed that some of the boxes connecting to mysql
> had reverse and others didn't. So now we actually go to the /etc/hos
onny Simonton; [EMAIL PROTECTED]
> Subject: Re: MySQL 4.1.7 Network slowdown
>
> > The final question, does the windows box have reverse DNS setup for it?
> If
> > not add it to the /etc/hosts file on your fc3 linux box. And reconnect
> to
> > mysql.
>
> WOW! Th
> The final question, does the windows box have reverse DNS setup for it? If
> not add it to the /etc/hosts file on your fc3 linux box. And reconnect to
> mysql.
WOW! That was it. Things are lightning fast now.
Sorry for going completely down the wrong path.
What would have been the best way
/etc/hosts file on your fc3 linux box. And reconnect to
mysql.
Donny
> -Original Message-
> From: Frank Febbraro [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 07, 2004 1:01 PM
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL 4.1.7 Network slowdown
>
> > >
> > This might be related to a bug I filed a couple months ago, assuming
> > your server is running on Windows
> >
> > http://bugs.mysql.com/bug.php?id=5787
>
> Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be
> exact.
>
My client machine (the remote machine in this mix
> This might be related to a bug I filed a couple months ago, assuming
> your server is running on Windows
>
> http://bugs.mysql.com/bug.php?id=5787
Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be exact.
--
MySQL General Mailing List
For list archives: http://lists.mys
> I have tried it with both utf8 and latin1, no difference in delay.
Sorry, to be more specific.
I have tried it originally with everything as UTF-8 (database, tables,
connections) I thought that the encoding could be the problem so I
converted/configured everything to latin1 (ISO-8859-1) and hav
> What character set are you using in the JDBC driver? Does it happen to
> be utf-8?
I have tried it with both utf8 and latin1, no difference in delay.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Got me then?! I am still running 4.0.22. Waiting for the connecter/J
to come out of gamma and for 4.1.* to stabilize a bit, so I can't offer
much other than what I have read.
Frank Febbraro wrote:
Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank Febbraro wrote:
>>Are you seeing the slowdown only from your java app? Or from all clients?
>
>
> I see this slowdown from my java app AND from the remote MySQL client
> application (called MySQL Query Browser 1.1.1 and 1.1.2). Basically I
> s
> Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown from my java app AND from the remote MySQL client
application (called MySQL Query Browser 1.1.1 and 1.1.2). Basically I
see the slowdown from all clients that are remote machines, but I do
not see it w
Frank Febbraro wrote:
The MySQL-client is 4.1.7, too?
Yes
The localhost mysql command is version 4.1.7-standard
The remote query browser is version 1.1.1 gamma
The remote JDBC driver is version 3.0.16-ga
Are you seeing the slowdown only from your java app? Or from all clients?
In the changelog f
Frank,
Wouldn´t it because the client driver (ODBC version)?
Perhaps it´s faster in the local server because it uses a mysql-4.1.7
client.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> The MySQL-client is 4.1.7, too?
>
Yes
The localhost mysql command is version 4.1.7-standard
The remote query browser is version 1.1.1 gamma
The remote JDBC driver is version 3.0.16-ga
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hmmm...
The MySQL-client is 4.1.7, too?
I realy don´t know if it make some difference, but perhaps
it does.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for the response
> If you provide more informations like the query and how
> many rows it returns, it should be easier help you.
The query is: select * from cmContent;
The query returns 228 rows.
mysql> describe cmContent;
+-+--+--+-+-
Frank,
If you provide more informations like the query and how
many rows it returns, it should be easier help you.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
19 matches
Mail list logo
