Bug #68046 IN() clause with many constant values does not perform
Submitted: 7 Jan 2013 9:29 Modified: 22 Jan 2013 14:04
Reporter: Martijn Otto Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.6-rc9 OS:Any (Ubuntu 12.04)
Assigned to: Jørgen Løland 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:

[7 Jan 2013 9:46] Shane Bester
testcase. 5.5.29 takes < 0.1 seconds, 5.6.10 takes > 4 seconds.

Attachment: bug68046.sql (application/octet-stream, text), 194.98 KiB.