Bug #485 Remote Performance Issue Windows in 4.1
Submitted: 23 May 2003 12:38 Modified: 5 Jun 2003 10:38
Reporter: Timothy Little Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Windows (Windows ONLY)
Assigned to: CPU Architecture:Any

[23 May 2003 12:38] Timothy Little
The 4.1+ versions of the Windows Builds have a SIGNIFICANT performance penalty on dataset result returns for each query.

How to repeat:
Install 4.1 Windows Build of MySQL server.  
Start that 4.1 server.  
Do a SELECT (1+1); from a local MYSQL.EXE command line utility (or MySQLcc).  The time will be low (from 0.04 to 0.00 seconds).

Try the same query, SELECT (1+1) from any other machine (no matter how close on the network) and you will get a response time of 0.13 to 0.26 seconds.

That is a huge delay.

Repeat the queries for an average.

Now, shut down the server, and overwrite the BIN directory with the 4.0 server binaries (EXEs).  

Start the 4.0 server.

Do the same queries, both locally and remotely and notice they always take around 0.04 seconds or less.

Suggested fix:
Look at the differences introduced in Windows build's between 4.0 and 4.1... maybe something is being closed, or rebuilt.
[30 May 2003 6:33] Alexander Keremidarski
We are aware of this problem with new binary protocol and investigate it. As you mention it happens with  Windows only

Thank you for your time.
[5 Jun 2003 10:38] Indrek Siitan
This is a duplicate of #482.