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]
We just installed MySQL 4.1.7 (we were previously using 4.0.22)
Our applications have now become extremely slow. When executing
queries directly on the database server, our response times are "228
rows in set (0.00 sec)" When we execute them from our development
servers (via mysql query browser,
20 matches
Mail list logo
