MySQL 8.0: Optimizer & Parser

[Edwin Desouza]

MySQL 8.0: One Giant Leap For SQL
- https://modern-sql.com/blog/2018-04/mysql-8.0

MySQL 8.0: Optimizer
- https://www.slideshare.net/NorvaldRyeng/more-sql-in-mysql-80
- https://www.slideshare.net/NorvaldRyeng/mysql-80-what-is-new-in-optimizer-and-executor
- https://www.slideshare.net/NorvaldRyeng/how-to-take-advantage-of-optimizer-improvements-in-mysql-80
- https://mysqlserverteam.com/removal-of-implicit-and-explicit-sorting-for-group-by/
- https://mysqlserverteam.com/improvements-to-rollup-in-mysql/
- https://mysqlserverteam.com/mysql-8-0-query-optimizer-takes-data-buffering-into-account/
- https://mysqlserverteam.com/optimization-to-skip-index-dives-with-force-index/
- http://mysqlserverteam.com/mysql-8-0-labs-descending-indexes-in-mysql/
- http://mysqlserverteam.com/mysql-8-0-invisible-indexes/
- http://mysqlserverteam.com/mysql-8-0-faster-batch-record-retrieval/
- http://mysqlserverteam.com/mysql-8-0-grouping-function/
- http://dasini.net/blog/2019/03/14/mysql-functional-indexes/


Hash Join and EXPLAIN ANALYZE
- https://www.slideshare.net/NorvaldRyeng/mysql-8018-latest-updates-hash-join-and-explain-analyze

Hash Join
- https://mysqlserverteam.com/hash-join-in-mysql-8/
- https://www.percona.com/blog/2019/10/30/understanding-hash-joins-in-mysql-8/
- https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html

EXPLAIN ANALYZE
- https://mysqlserverteam.com/mysql-explain-analyze/
- https://www.percona.com/blog/2019/10/28/using-explain-analyze-in-mysql-8/
- https://dev.mysql.com/doc/refman/8.0/en/explain.html#explain-analyze


CTEs:
- http://www.slideshare.net/oysteing/mysql-80-common-table-expressions-71760102
- http://www.slideshare.net/oysteing/mysql-80-common-table-expressions
- https://mysqlserverteam.com/supporting-all-kinds-of-outer-references-in-derived-tables-lateral-or-not/
- https://mysqlserverteam.com/support-for-lateral-derived-tables-added-to-mysql-8-0-14/
- http://mysqlserverteam.com/mysql-8-0-improved-performance-with-cte/
- http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes-part-two-how-to-generate-series/
- http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes/


Window Functions:
- http://www.slideshare.net/DagHWanvik/sql-window-functions-for-mysql
- https://www.slideshare.net/oysteing/common-table-expressions-cte-window-functions-in-mysql-80
- https://mysqlserverteam.com/row-numbering-ranking-how-to-use-less-user-variables-in-mysql-queries/


Histograms:
- https://www.slideshare.net/oysteing/histogram-support-in-mysql-80
- https://mysqlserverteam.com/histogram-statistics-in-mysql/
- http://lefred.be/content/mysql-8-0-histograms/


Hints:
- https://mysql.wisborg.dk/2020/04/28/mysql-8-0-20-index-level-optimizer-hints/


CHECK Constraints:
- https://mysqlserverteam.com/mysql-8-0-16-introducing-check-constraint/
- https://vladmihalcea.com/mysql-custom-sql-check-constraints/


New Index Features
- https://www.slideshare.net/ErikFrseth/new-idnex-features-in-mysql-8

SKIP LOCKED and NOWAIT:
- http://mysqlserverteam.com/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/
- https://www.percona.com/blog/2020/08/03/using-skip-lock-for-queue-processing-in-mysql/

AntiJoins:
- https://mysqlserverteam.com/a-must-know-about-not-in-in-sql-more-antijoin-optimization/
- https://mysqlserverteam.com/antijoin-in-mysql-8/


MySQL 8.0: Parser
- http://mysqlserverteam.com/mysql-8-0-labs-refactoring-and-improving-the-parser/

MySQL 8.0: Keywords
- https://dev.mysql.com/doc/refman/8.0/en/keywords-table.html
- https://lefred.be/content/mysql-8-0-and-keywords/



Edited 32 time(s). Last edit at 08/03/2020 09:59AM by Edwin Desouza.