MySQL Forums
Forum List  »  Optimizer & Parser

MySQL Optimizer: Blogs
Posted by: Edwin DeSouza
Date: April 28, 2007 06:20PM

MySQL Optimizer Team Blog:
http://mysqloptimizerteam.blogspot.com/

MySQL Optimizer: Features in MySQL 5.7
http://www.tocker.ca/2013/10/18/optimizer-enhancements-in-mysql-5.7.html

MySQL Optimizer: Features in MySQL 5.6
http://jorgenloland.blogspot.com/2012/12/favorite-mysql-56-features-optimizer.html

MySQL Optimizer: InnoDB
http://jorgenloland.blogspot.com/2013/10/faq-innodb-extended-secondary-indexes.html
http://glukhsv.blogspot.co.uk/2012/12/innodb-extended-secondary-keys.html
http://oysteing.blogspot.com/2011/04/more-stable-query-execution-time-by.html

MySQL Optimizer: EXPLAIN
http://mysqlserverteam.com/mysql-explain-explained/
http://oysteing.blogspot.com/2013/05/when-is-subquery-executed.html
http://glebshchepa.blogspot.com/2012/04/optimizer-new-explain-formatjson.html
http://glebshchepa.blogspot.com/2011/10/optimizer-new-explain-for-data.html
http://jorgenloland.blogspot.com/2011/10/optimizer-tracing-query-execution-plan.html
http://jorgenloland.blogspot.com/2011/10/optimizer-tracing-query-execution-plan.html

MySQL Optimizer: Tracing
http://jorgenloland.blogspot.com/2011/10/optimizer-tracing-query-execution-plan.html
http://dimitrik.free.fr/blog/archives/2012/01/mysql-performance-overhead-of-optimizer-tracing-in-mysql-56.html
http://guilhembichot.blogspot.com/2011/09/optimizer-tracing-how-to-configure-it.html


MySQL Optimizer: Benchmarks
http://jorgenloland.blogspot.com/2013/02/dbt-3-q3-6-x-performance-in-mysql-5610.html
http://oysteing.blogspot.com/2012/04/improved-dbt-3-results-with-mysql-565.html
http://oysteing.blogspot.de/2011/10/bacthed-key-access-speeds-up-disk-bound.html

MySQL Optimizer: Subqueries
http://oysteing.blogspot.com/2013/05/when-is-subquery-executed.html
https://blog.mozilla.org/it/2013/01/29/in-subqueries-in-mysql-5-6-are-optimized-away/
http://dev.mysql.com/doc/refman/5.6/en/subquery-materialization.html
http://oysteing.blogspot.com/2012/07/from-months-to-seconds-with-subquery.html
http://guilhembichot.blogspot.com/2012/04/faster-subqueries-with-materialization.html

MySQL Optimizer: Index Condition Pushdown
http://jorgenloland.blogspot.com/2012/03/index-condition-pushdown-to-rescue.html
http://olavsandstaa.blogspot.com/2011/04/mysql-56-index-condition-pushdown.html

MySQL Optimizer: Batched Key Access Speeds
http://oysteing.blogspot.de/2011/10/bacthed-key-access-speeds-up-disk-bound.html
http://oysteing.blogspot.com/2011_10_01_archive.html

MySQL Optimizer: Prepared Statements
http://mysqlserverteam.com/re-factoring-some-internals-of-prepared-statements-in-5-7/


MySQL Optimizer: More
http://optimize-this.blogspot.com/2013/05/the-outer-join-to-inner-join-coversion.html
http://jorgenloland.blogspot.com/2011/08/mysql-range-access-method-explained.html
http://jorgenloland.blogspot.com/2011/09/tips-and-tricks-killer-response-time.html
http://didrikdidrik.blogspot.com/2011/04/optimizing-mysql-filesort-with-small.html
http://jorgenloland.blogspot.com/2012/04/improvements-for-many-table-joins-in.html
http://jorgenloland.blogspot.com/2012/04/on-queries-with-many-values-in-in.html
http://roylyseng.blogspot.com/2012/04/semi-join-in-mysql-56.html



Edited 31 time(s). Last edit at 05/15/2014 12:31PM by Edwin Desouza.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Optimizer: Blogs
11027
April 28, 2007 06:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.