Bug #46648 SQL_CALC_FOUND_ROWS kills performance with ORDER BY and LIMIT
Submitted: 11 Aug 2009 11:41 Modified: 17 Aug 2009 13:36
Reporter: Jille Timmermans Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.1.32, 4.1, 5.0, 5.1, azalea bzr OS:Linux (2.6.28.7)
Assigned to: CPU Architecture:Any
Tags: limit, order by, performance, sql_calc_found_rows

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:

[12 Aug 2009 6:20] Sveta Smirnova
test case for the testsuite

Attachment: bug46648.test (application/octet-stream, text), 1.11 KiB.