MySQL Optimizer: Features in MySQL 5.7

[Edwin Desouza]

MySQL Optimizer: Features in MySQL 5.7
http://oysteing.blogspot.com/2017/03/what-to-do-when-mysql-optimizer.html
http://oysteing.blogspot.com/2017/03/mysql-57-improved-join-order-by-taking.html
http://www.tocker.ca/2015/05/25/optimizer-trace-and-explain-formatjson-in-5-7.html
http://mysqlserverteam.com/generated-columns-in-mysql-5-7-5/
http://mysqlserverteam.com/a-new-dimension-to-mysql-query-optimizations-part-2/
http://mysqlserverteam.com/a-new-dimension-to-mysql-query-optimizations-part-1/
http://mysqlserverteam.com/re-factoring-some-internals-of-prepared-statements-in-5-7/
http://mysqlserverteam.com/you-asked-for-it-new-default-for-eq_range_index_dive_limit/
http://mysqlserverteam.com/filesort-optimization-in-5-7-3-pack-values-in-the-sort-buffer/
http://mysqlserverteam.com/state-of-the-union/
http://mysqlserverteam.com/range-access-now-in-an-in-predicate-near-you/
http://mysqlserverteam.com/with-recursive-and-mysql/
http://mysqlserverteam.com/faq-innodb-extended-secondary-keys/
http://mysqlserverteam.com/dynamic-range-access-and-recent-changes/
http://www.tocker.ca/2013/10/18/optimizer-enhancements-in-mysql-5.7.html


MySQL Optimizer: Query Rewrite
http://www.slideshare.net/MartinHanssonOracle/the-query-rewrite-plugin-interface-writing-your-own-plugin/
http://www.slideshare.net/SvetaSmirnova/introducing-new-sql-syntax-and-improving-performance-with-preparse-query-rewrite-plugins
http://mysqlserverteam.com/the-query-rewrite-plugins/
http://mysqlserverteam.com/write-yourself-a-query-rewrite-plugin-part-1/
http://mysqlserverteam.com/write-yourself-a-query-rewrite-plugin-part-2/
http://thenoyes.com/littlenoise/?p=483
https://scriptingmysql.wordpress.com/2018/09/07/manipulating-queries-with-non-conforming-data-via-mysql-query-rewrite-plugin-triggers-and-stored-procedures/


MySQL Optimizer: Hints
http://mysqlserverteam.com/new-optimizer-hints-in-mysql/


MySQL Optimizer: Cost Model
http://www.slideshare.net/olavsa/mysql-optimizer-cost-model
http://mysqlserverteam.com/optimizer-cost-model-improvements-in-mysql-5-7-5-dmr/
http://mysqlserverteam.com/the-mysql-optimizer-cost-model-project/


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



Edited 15 time(s). Last edit at 09/07/2018 10:33AM by Edwin Desouza.