MySQL Bugs: #48846: Too much time spent in ha_partition::records_in

Bug #48846	Too much time spent in ha_partition::records_in_range if not able to prune
Submitted:	17 Nov 2009 18:51	Modified:	19 Mar 2010 10:51
Reporter:	Mattias Jonsson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Partitions	Severity:	S3 (Non-critical)
Version:	5.1+	OS:	Any
Assigned to:	Mattias Jonsson	CPU Architecture:	Any
Tags:	pruning

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

perl test script (uses mysql client).

Attachment: bug37252.no_dbi.pl (text/plain), 10.34 KiB.

spreadsheet showing the performance figures

Attachment: bug48846_report.ods (application/vnd.oasis.opendocument.spreadsheet, text), 134.27 KiB.