MySQL Forums
Forum List  »  Optimizer & Parser

MySQL Optimizer: Features in MySQL 5.7
Posted by: Edwin Desouza
Date: December 18, 2012 11:38AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Optimizer: Features in MySQL 5.7
3719
December 18, 2012 11:38AM


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.