Bug #79294 Query with double nested subquery much slower in 5.7
Submitted: 16 Nov 2015 15:31 Modified: 18 Dec 2015 18:46
Reporter: Jonathan Corwin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.7.9, 5.7.11 OS:Windows (2008 x64 / 8.1 x64)
Assigned to: CPU Architecture:Any

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:

[16 Nov 2015 15:33] Jonathan Corwin
Table definitions and data

Attachment: slow.sql (application/octet-stream, text), 24.50 KiB.

[17 Nov 2015 8:35] Jonathan Corwin
MySQL config file

Attachment: my.ini (application/octet-stream, text), 886 bytes.