Bug #36006 Optimizer does table scan for select count(*) w/5.1.22, .23, not 5.0.51, 5.1.11
Submitted: 11 Apr 2008 20:43 Modified: 13 May 2008 19:56
Reporter: Richard Bejtlich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:5.1.22, 5.1.23, 5.1.25-BK OS:FreeBSD (7.0)
Assigned to: Gleb Shchepa CPU Architecture:Any
Tags: regression

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:

[12 Apr 2008 0:01] Richard Bejtlich
I ran my tests with 5.1.22, 5.1.23, and 5.0.51a on one box to show the problem.

Attachment: example_on_one_box.txt (text/plain), 18.41 KiB.