MySQL Optimizer: Blogs

[Edwin DeSouza]

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.