Resources are finite, but it would be great if MariaDB also did something about single-thread performance regressions. MySQL has not done/said much about them in public. Bugs I created on bugs.mysql.com are getting some work, but I think all are still open.
On Thu, Nov 21, 2013 at 11:30 PM, Colin Charles <b...@mariadb.com> wrote: > Hi XL, > > On 22 Nov 2013, at 01:32, Axel Schwenke <a...@askmonty.org> wrote: > > > Hi, > > > > I have run another sysbench with in-memory workload to check where we are > > with respect to mutex contention. > > > > Thank you for doing this. This is *amazing*, and I hope this continues > > <snipped> > > > I notice a visible performance gain in MariaDB-10.0 over MariaDB-5.5 at > 32 > > threads. This is probably due to the work on the InnoDB kernel mutex > > (impossible to prove since 5.5 doesn't have mutex instrumentation). At > > higher concurrency however the LOCK_open mutex kicks in and performance > is > > clearly dominated by that mutex alone (it flattens out for all 5.5 and > 10.0 > > versions of MariaDB) > > > > OK, from my reading, it seems that yes, MariaDB 10 is better than 5.5, but > in all occurrences performance is not matched to MySQL 5.6. This is > something we clearly need to look into before we go GA > > Readonly, at 32 threads shows a difference 2,000 tps. And from 10.0.4 -> > 10.0.6 we seem to have lost some 1,500 tps as well. This delta is much > worse when we have 64 or 128 threads. This seems to also be the case for > sysbench r/w. > > That said, now is a good time to start fixing these problems, as we > clearly need a performant DB for a GA release. > > Thank you again XL for doing this, and lets hope we see a lot more > > cheers, > -colin > > -- > Colin Charles, Chief Evangelist > MariaDB | t: +6-012-204-3201 | Skype: colincharles > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-developers > Post to : maria-developers@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-developers > More help : https://help.launchpad.net/ListHelp > -- Mark Callaghan mdcal...@gmail.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
