MySQL Bugs: #30738: Concurrent disk sorts from InnoDB tables are much slower in MySQL 5

Bug #30738	Concurrent disk sorts from InnoDB tables are much slower in MySQL 5
Submitted:	31 Aug 2007 3:36	Modified:	19 Nov 2011 9:50
Reporter:	Mark Callaghan	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S5 (Performance)
Version:	5.0.37	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any
Tags:	concurrent, disk, innodb, regression, slow, sort

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

patch to release btr_search_latch if the current THD has build temp tables on disk.

Attachment: ahi_5.0_v0.patch (text/x-diff), 532 bytes.

patch based on Yasufumi's idea of fixing missed os_event_set() call in sync0arr.

Attachment: os_event_5.0_v2.patch (text/x-diff), 17.22 KiB.