MySQL Bugs: #55172: Innodb errors as 1104: The SELECT would examine more than MAX_JOIN

Bug #55172	Innodb errors as 1104: The SELECT would examine more than MAX_JOIN_SIZE rows...
Submitted:	12 Jul 2010 7:37	Modified:	19 Dec 2010 12:33
Reporter:	Nidhi Shrotriya	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	5.1.48, 5.5.5-m3	OS:	Linux
Assigned to:	Assigned Account	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:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

1st file

Attachment: storedproc-initial-5-1-major.test (application/octet-stream, text), 23.20 KiB.

2nd file

Attachment: storedproc-upgrade-5-1-major.test (application/octet-stream, text), 37.35 KiB.

Dump before failure

Attachment: dump (application/octet-stream, text), 3.07 KiB.