Bug #87641 Execution plan differs after upgrade to 5.7
Submitted: 1 Sep 2017 14:20 Modified: 6 Sep 2017 15:47
Reporter: KORBULY Francois Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version:5.6.33 / 5.7.18 OS:CentOS (6 (x86_64))
Assigned to: CPU Architecture:Any
Tags: execution plan;difference;5.6;5.7

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:

[1 Sep 2017 14:27] KORBULY Francois
Create tables SQL

Attachment: Bug_87641_table_structure.txt (text/plain), 3.94 KiB.

[5 Sep 2017 15:39] KORBULY Francois
Query optimizer trace on 5.6 Mysql server

Attachment: optimizer_trace_5.6.txt (text/plain), 19.89 KiB.

[5 Sep 2017 15:39] KORBULY Francois
Query optimizer trace on 5.7 Mysql server

Attachment: optimizer_trace_5.7.txt (text/plain), 16.89 KiB.