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/mysql?unsub=m...ie.nctu.edu.tw

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 have the
same delays.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

I have a bunch of 4.1.7 boxes all running linux, some 32 bit and some 64 bit
and I've never experienced the problem you are having. Are you have the
problem if you connect from a remote linux box?

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.

Donny



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

WOW! That was it. Things are lightning fast now.

Sorry for going completely down the wrong path.

What would have been the best way to figure this out, not knowing this
could have been the case?

I truly apprecuate the help.

Regards,
Frank

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

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/hosts file
and name all of our boxes something just in the hosts file so it will be
easier to know exactly what everything is.

You might still want to file that as a bug and you can at least have mysql
determine if it's a bug or not. They will probably say it's on some
documentation like on page 13,645 paragraph 12 or something so they won't
consider it a bug. But at least this way somebody else may know about the
problem.

Donny


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

So do you think the 5+ second delay was that it was actually getting a
reverse lookup, just from somewhere that responded really slow, or it
tried, got some timeout, then gave up?

Thanks again...so happy.
Frank

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.

Donny



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

--------------090908030601000902030702
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Donny Simonton wrote:


http://dev.mysql.com/doc/mysql/en/DNS.html


Are you not running JDBC connection pooling? This should have only happened once and then moved on since the connection is open.

I don't think MySQL is doing this per query.

Kevin

--

Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an
invite! Also see irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html

If you're interested in RSS, Weblogs, Social Networking, etc... then you
should work for Rojo! If you recommend someone and we hire them you'll
get a free iPod!

Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412


--------------090908030601000902030702--