December 18, 2008

XtraDB in CPU-bound benchmark

Posted by Vadim |

Peter said me that previous results http://www.mysqlperformanceblog.com/2008/12/18/xtradb-benchmarks-15x-gain/ are too marketing, and we should show other results also.

Here is the run for CPU Bound,or it would be more correctly to say in-cache benchmark, because there is a lot of CPU remains idle. This run is exactly the same as Disk Bound but with innodb_buffer_pool_size=8G which is more than enough to fit all data in memory.

The XtraDB is showing very modest gain of about 2.5% in this case which can be attributed to measurement error too.

[read more...]

Posted by Vadim @ 9:36 pm :: benchmarks, patch, xtradb :: No comments
Print This Post Print This Post book mark XtraDB in CPU-bound benchmark in del.icio.usdel.icio.us :: submit XtraDB in CPU-bound benchmark to digg.comdigg

XtraDB benchmarks – 1.5X gain in IO-bound load

Posted by Vadim |

I guess it is first reaction on new storage engine – show me benefits. So there is benchmark I made on one our servers. It is Dell 2950 with 8CPU cores and RAID10 on 6 disks with BBU, and 32GB RAM on board with CentOS 5.2 as OS. This is quite typical server we recommend to run MySQL on. What is important I used Noop IO scheduler, instead of default CFQ. Disclaimer: Please note you may not get similar benefits on less powerful servers, as most important fixes in XtraDB are related to multi-core and multi-disks utilization. Also results may be different if load is CPU bound.

[read more...]

Posted by Vadim @ 2:46 am :: benchmarks, xtradb :: 30 comments
Print This Post Print This Post book mark XtraDB benchmarks – 1.5X gain in IO-bound load in del.icio.usdel.icio.us :: submit XtraDB benchmarks – 1.5X gain in IO-bound load to digg.comdigg