MySQL Bugs: #68079: InnoDB does not scale well on 12 core system for specific all in memory SELECT

Bug #68079	InnoDB does not scale well on 12 core system for specific all in memory SELECT
Submitted:	14 Jan 2013 12:01	Modified:	16 Jan 2014 13:15
Reporter:	Valeriy Kravchuk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S2 (Serious)
Version:	5.5.29, 5.6.9-rc	OS:	Linux (x86_64)
Assigned to:	Arnaud Adant	CPU Architecture:	Any
Tags:	performance, read only, scalability, throughput

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

Dump of tables, incase somebody thinks exact content matters

Attachment: test.sql.gz (application/x-tar-gz, text), 233.32 KiB.

Files results from latest tests.

Attachment: innodb-scale-bug-68079.tar.gz (application/x-gzip, text), 34.34 KiB.