[Maria-discuss] Single-threaded performance & optimizer overhead
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/
More notes on how to get the most (or not) out of MySQL 5.6 during benchmarks. http://mysqlha.blogspot.com/2013/04/mysql-56-incomplete-guide-to-avoiding.ht... On Wed, Apr 3, 2013 at 6:24 AM, Colin Charles <colin@montyprogram.com>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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Mark Callaghan mdcallag@gmail.com
Colin, All, 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. Regards, Igor. 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
participants (3)
-
Colin Charles -
Igor Babaev -
MARK CALLAGHAN