MariaDB 5.3.4 benchmarks

MariaDB 5.3 has reached the release candidate milestone, and the 5.3 version promises a lot of new features and optimization (i.e in optimizer http://kb.askmonty.org/en/what-is-mariadb-53#query-optimizer). No surprise I wanted to check how all improvements affect general performance.

So I why don’t we run old good sysbench benchmark.

For the benchmark I took:

• • HP ProLiant DL380 G6 box

• • sysbench multitables oltp rw workload, 16 tables, 500mil rows each, total datasize about 30GB

• • working threads from 1 to 256

• • Versions: MariaDB 5.3.4, MySQL 5.5.20

• • Data is stored on RAID10 HDD partition

• • Like in all my recent benchmarks, I make throughput measurements each 10 sec, so we can see the stability of the throughout

The raw results, configuration and scripts are available on our Benchmarks Launchpad

The graphical results:

Throughput (more is better)

I was surprised to see that MariaDB shows 20-30% worse throughput.
It seems many changes resulted to performance hit in general. I wonder whether MariaDB team runs performance regression benchmarks, and if they do, why do we see such performance decline.

Follow @VadimTk