Bug #4654 lost connection error 2013
Submitted: 20 Jul 2004 19:57 Modified: 20 Aug 2004 21:33
Reporter: Alan Napier Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.1.3 and 4.1.2 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[20 Jul 2004 19:57] Alan Napier 
Description:
When doing large joins between 2 tables approx 5000 rows each, if I don't use/forget to use an index on left join criterea, then I get an error message 2013 lost connection and the mysqld server hogs up processor for 1 to to hours before going back to normal state

How to repeat:
repeatable on VARCHAR(26) or UNSIGNED INTEGER join criterea
Can send tables if necessary

Suggested fix:
If query is going to be too long then after giving back prompt on client, then stop unnecessary server processor hogging.
[20 Jul 2004 21:33] MySQL Verification Team 
Hi,
Please upload the test case file at:

ftp://ftp.mysql.com/pub/mysql/upload

making mention to this bug report.

thanks,
Miguel
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".