Bug #80505 mysql server 5.7.11 view performance issue
Submitted: 25 Feb 2016 9:43 Modified: 25 Feb 2016 14:53
Reporter: mohamed atef Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:5.7.11 OS:Windows
Assigned to: CPU Architecture:Any
Tags: view performance issue

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:

[25 Feb 2016 9:44] mohamed atef
extended explain for the query in server 5.7.11

Attachment: EXTENDED EXPLAIN DEIVED_MERGE ON MYSQL 5.7.11.html (text/html), 4.63 KiB.

[25 Feb 2016 9:45] mohamed atef
extended explain for query in server 5.7.10 and optimizer dervied_merge is set to off

Attachment: EXTENDED EXPLAIN derived_merge off 5.7.10.html (text/html), 4.63 KiB.

[25 Feb 2016 9:45] mohamed atef
extended explain for query in server 5.7.10 and optimizer dervied_merge is set to on

Attachment: EXTENDED EXPLAIN derived_merge on 5.7.10.html (text/html), 4.12 KiB.