Bug #74030 Filesort chosen where index should've been, using LIMIT
Submitted: 23 Sep 2014 7:54 Modified: 11 Apr 2020 2:15
Reporter: Edgars Irmejs (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:8.0dev, 5.7.16, 5.6.20, 5.5.39, OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: Contribution

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:

[23 Sep 2014 7:55] Edgars Irmejs
InnoDB case where the problem occurs in production use

Attachment: trace_bug_74030.log (application/octet-stream, text), 16.96 KiB.