Bug #416 Server slow if client not on localhost
Submitted: 11 May 2003 12:47 Modified: 28 May 2003 4:18
Reporter: Thomas Aho Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.0-alpha OS:Microsoft Windows (Windows XP and NT)
Assigned to: CPU Architecture:Any

[11 May 2003 12:47] Thomas Aho
Description:
Repeated queries from a client running on another host than the server
takes a long time.
If the server runs an eralier version (e.g. 4.0.12) the problem disappears, i.e. the queries are much faster.
This behaviour occurs on Windows XP and NT (haven't tested on 95/98/ME).
Also tested 4.1.0-alpha on Linux (SuSE 8.1) and there it works fine.

How to repeat:
Run repeated queries from a C/C++-program under XP or NT.

Suggested fix:
Workaround: use 4.0.12 or run the server on Linux.
[22 May 2003 16:33] MySQL Verification Team
I did several tests with 4.0.12/4.1.0-alpha with almost any difference
between the versions running on Win2k Server.
Please provide a case test.
[23 May 2003 6:23] Joeri Willems
I must admit i have exactly the same problem : Server running Windows XP SP1 and server running Windows 2000. And on both PCs only localhost is fast, performing queries VIA ODBC gives about a 0.3s per query!
I believe though this is a bug of the connection between ODBC and the new 4.1 server. I have already done a small test with using the API connector and it doesn't reflect the problem (although i still need to try it with a larger test). Also noteable : Doing a very difficult query (a WHERE with about 10 conditions on a 1200 row table yielded a result of 18.1s ! I hope there will be a solution for this problem!!
[27 May 2003 15:51] Joeri Willems
http://bugs.mysql.com/bug.php?id=482 for continuation on this bug. (made a new thread as i thought this thread was closed.
[28 May 2003 4:18] Indrek Siitan
Yes, it's the same bug as #482.