← Back to team overview

maria-developers team mailing list archive

Re: MariaDB scalability: mutexes

 

Hi Svoj,

Sergey Vojtovich wrote:
> I benchmarked various mutexes available to MariaDB.
> Among other things I noticed that normal mutexes scale better than adaptive.

> Could you do official benchmarks (patch attached)? It would be nice to also
> benchmark MySQL-5.6 with thr_lock part of the patch.

Here are sysbench results for 10.0.8. I added 10.0.7 and MySQL-5.6.10 from
an earlier run for comparison. The test is sysbench OLTP ro with multiple
(32) tables.

The normal mutexes give significantly better throughput. The raw data
contains also the snapshots from performance schema with the mutex numbers.
Top mutex is still LOCK_open.

I currently run another sysbench OLTP, this time also r/w and with both
lower and higher concurrency. I added 10.0.8-patched to this, but it won't
finish before tomorrow.


XL

Attachment: tps.dat
Description: MOPAC data

Attachment: raw-PFS-off.zip
Description: Zip archive

Attachment: raw-PFS-on.zip
Description: Zip archive


Follow ups

References