Bug #29413 Maximum performance of OLTP benchmark is not so scalable on multi-cpu
Submitted: 28 Jun 2007 10:38 Modified: 12 Aug 19:14
Reporter: Yasufumi Kinoshita
Status: Closed
Category:Server: InnoDB Severity:S4 (Feature request)
Version:5.0.41 OS:Any
Assigned to: Inaam Rana Target Version:
Tags: Contribution

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-29413.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[28 Jun 2007 10:39] Yasufumi Kinoshita
The benchmark results

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

[28 Jun 2007 10:41] Yasufumi Kinoshita
example

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

[13 Aug 2007 11:54] Yasufumi Kinoshita
Parallelize and increase IO threads

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

[13 Aug 2007 11:55] Yasufumi Kinoshita
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.

[13 Aug 2007 11:56] Yasufumi Kinoshita
new results

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

[13 Aug 2007 11:58] Yasufumi Kinoshita
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.

[2 Aug 2008 14:53] Yasufumi Kinoshita
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.

[29 Aug 2008 6:40] Yasufumi Kinoshita
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.