Mysql Optimizer Features in 5.7 and 8.0
summary
MySQL 5.7 adds concrete optimizer tools: invisible indexes let DBAs disable an index as a dry run before dropping it, descending indexes store keys to avoid server-side sorts, and common table expressions including recursive CTEs let hierarchy queries run without heavy client-side logic. 8.0 labs show a prefetch buffer that increases rows fetched per I/O and reports ~15% gains on some scans, UUID storage as BINARY(16) with ordering, bitwise ops on BINARY/BLOB for IPv6, and finer join order and hint controls.
AI-written summary · about
chapters (25)
- 0:00Introduction
- 0:20Invisible indexes
- 0:30Drop an index
- 1:33Descending index
- 2:36Common table expressions
- 3:25Common table expressions drawbacks
- 3:58Subquery
- 4:41Recursive Query
- 5:29Recursive CPUs
- 6:00Real world example
- 6:55recursive CTE
- 7:43batch CTE
- 9:34performance
- 9:46hints
- 10:56joint fixed order
- 11:30how does it work
- 12:20straight join
- 13:06merge
- 13:42ipv6 support
- 15:15time stamping
- 16:07ipv4 ipv6 support
- 17:00future roadmap
- 18:26summary
- 18:50passing
- 20:00questions
