Bug #27199 Performance problem when query contains a left join against a subquery
Submitted: 16 Mar 2007 5:03 Modified: 9 Sep 2013 9:28
Reporter: Stephen Gornick Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.0.22, 5.0.37, 4.1 BK, 5.1 BK OS:Linux (linux)
Assigned to: Assigned Account CPU Architecture:Any
Tags: 100%, 5.0.22, 5.0.37, cpu, derived, derived table, join, left, left join, MAX, maxed, Optimize, optimized, Optimizer, outer, OUTER JOIN, peg, pegged, subquery, table

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file: