MySQL Bugs: #29413: Maximum performance of OLTP benchmark is not so scalable on multi-cpu

Bug #29413	Maximum performance of OLTP benchmark is not so scalable on multi-cpu
Submitted:	28 Jun 2007 8:38	Modified:	12 Aug 2009 17:14
Reporter:	Yasufumi Kinoshita	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S4 (Feature request)
Version:	5.0.41	OS:	Any
Assigned to:	Inaam Rana	CPU Architecture:	Any
Tags:	Contribution

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

The benchmark results

Attachment: performance.png (image/png, text), 918 bytes.

example

Attachment: mysql-5.0.41_control_flush_and_merge.patch (application/octet-stream, text), 8.21 KiB.

Parallelize and increase IO threads

Attachment: mysql-5.0.41_control_io-threads.patch.gz (application/octet-stream, text), 813 bytes.

Optimize relatives of freeing blocks

Attachment: mysql-5.0.41_split_buf_pool_mutex_fixed_optimistic2.patch.gz (application/octet-stream, text), 7.21 KiB.

new results

Attachment: sequencial_resulut_new.pdf (application/force-download, text), 46.20 KiB.

add tuning parameters in this report

Attachment: mysql-5.0.41_control_flush_and_merge_and_read_ahead.patch.gz (application/octet-stream, text), 2.45 KiB.

latest patch (fixed just a little)

Attachment: mysql-5.0.54_split_buf_pool_mutex_fixed_optimistic.patch.gz (application/x-gzip, text), 7.09 KiB.

Some doubtful code are fixed.

Attachment: mysql-5.0.67_split_buf_pool_mutex_fixed_optimistic_safe2.patch.gz (application/x-gzip, text), 7.17 KiB.