← Back to team overview

maria-discuss team mailing list archive

Re: Single-threaded performance & optimizer overhead



Any benchmarks of maria-10.0.1 or of a built over the carrent
10.0/10.0-base trees do not make any sense, because these
trees are based on innodb from mysql 5.6.5, not on innodb from mysql 5.6.10.

It's a well known fact that innodb of mysql-5.6.10 is much faster than
innodb of mysql 5.6.5.


On 04/03/2013 06:24 AM, Colin Charles wrote:
> Hi!
> Mark Callaghan asks this on Facebook:
> While testing single-threaded performance to compare MySQL 5.1 with 5.6 I think there is much more overhead in the optimizer in 5.6. Do you have benchmark results for a single-threaded workload with fast queries (like SELECT one row by PK from a cached table)? I am curious whether new versions of MariaDB have a similar increase in optimizer overhead.
> http://bugs.mysql.com/bug.php?id=68825
> He also wrote a blog post:
> 	http://mysqlha.blogspot.com/2013/04/mysql-56-single-thread-update-only.html
> Might make a great post at our blog
> cheers,
> -colin
> --
> Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles
> MariaDB: Community developed. Feature enhanced. Backward compatible.
> Download it at: http://www.mariadb.org/
> Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp