Advanced query optimization techniques on large queries.

Developing Applications
25 April 1:50pm - 2:40pm @ Ballroom A

This talk is looking to fill some of the gap between the ability of reading explain output and the ability to optimize really large queries (imagine a 7 table join). I would like to discuss practical techniques through real-world practical examples, displaying common flaws, encountered throughout my work as a consultant. The talk will cover, but will not be limited to:

- How do you start optimizing large queries.
- Denormalization.
- Early join, when can it help.
- Effect of join order.
- Range join optimization.
- OR consitions in the query.

Speakers

Peter Boros
Principal Architect, Percona
Biography: 
Peter joined the European consulting team in May 2012. Before joining Percona, among many other things, he worked at Sun Microsystems, specialized there in performance tuning and was a DBA at Hungary's largest social networking site. He also taught many Oracle University MySQL courses. He has been using and working with open source software from early 2000s. Peter's first and foremost professional interest is performance tuning. He currently lives in Budapest, Hungary with his wife and son.

Slides