Download as PDF, PPTX
Mysql server query path
- 1. MySQL 8.0 ServerQuery Path 2019-10-01 - 宸风
- 2.
- 3. 目录 1 MySQL Parser 2MySQL Resolver (rewriter) 3 MySQL Optimizer 4 MySQL Executor
- 4.
- 5.
- 6. Parser - AST Relatedcodes: - sql_parse.cc - sql_yacc.cc - item*.h/.cc Ref: http://mysql.taobao.org/monthly/2017/04/02/
- 7. Parser - Item Ref:MySQL Item 源码阅读笔记 • • • • • •
- 8.
- 9.
- 10. Resolver – Semanticcheck
- 11. Resolver - ViewMerge or Materialization
- 12. Resolver - ViewMerge Example https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html
- 13. Resolver – SubqueryOptimization à
- 14. Resolver – SubqueryOptimization https://mariadb.com/kb/en/library/non-semi-join-subquery-optimizations/#the-in-to-exists-transformation
- 15. Resolver – SubqueryOptimization Rewrite Algos
- 16. Resolver – SubqueryOptimization Rewrite Algos
- 17. Subquery Optimization SemiJoinExecution Algos
- 18. Subquery Optimization SemiJoinExecution Algos
- 19. Subquery Optimization SemiJoinExecution Algos
- 20. Subquery Optimization SemiJoinExecution Algos
- 21. Subquery Optimization SemiJoinExecution Algos
- 22.
- 23. SQL Optimizer –Main procedure Ref: MySQL 8.0 Optimizer 源码笔记 Ref: MySQL 8.0 Distinct 源码笔记
- 24.
- 25.
- 26. SQL Optimizer -statistics
- 27. SQL Optimizer –cost model
- 28. SQL Optimizer –join reorder
- 29. SQL Optimizer –access method • • • • •
- 30. SQL Optimizer –access method
- 31.
- 32. SQL Executor –do select
- 33. SQL Executor –Nested-Loop Join HashJoin is coming in MySQL 8.0.17
- 34. SQL Executor –RowIterator
- 35. SQL Executor –MRR, BKA
- 36. SQL Executor –ICP (Index cond pushdown)
- 37. Missing branches/features inQueryPath - privilege - fulltext - CTE - table function - partitioned table - window - GIS/JSON, etc. - perf & track - agg & distinct - rollup - distribution related - etc …