Optimizer Resources
Contents |
[edit] Talks available online
- MySQL UC 2006, Timour, Speeding-up Queries: New Features of the MySQL 5.0 Query Engine. abstract, slides
- Google, 2006, Timour, An Overview of the MySQL Engine and its Latest Features. video
- MySQL Conf 2007, Timour, Query Optimizer Internals and What's New in the MySQL 5.2 Optimizer abstract, slides, slides and audio
- MySQL Conference 2008, Sergey Petrunia, New Subquery Optimizations in MySQL 6.0 abstract,slides
- TODO link to more UC Talks, etc.
[edit] MySQL University sessions
- How does the MySQL Optimizer work
- How MySQL Handles ORDER BY, GROUP BY, and DISTINCT
- Interaction Between Optimizer and Storage Engine
[edit] Source Trees
MySQL source trees with code that has not yet been integrated into main MySQL 5.0 tree
- WL#1326 "GIS: Precise spatial operations" http://mysql.bkbits.net:8080/mysql-5.1-wl1326/, i.e. bk://mysql.bkbits.net/mysql-5.1-wl1326
- Batched_Key_Access feature preview tree, UC talk and specification
The process of obtaining the source is described here: http://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html