Imagine a MySQL query that barely fits your monitor screen such as a 7 table join. This video discusses filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations are hared, while pointing out common mistakes organizations often make.
The talk covers the following topics:
* How to start optimizing large queries
* The use of denormalization
* The effect of join order
Video producer: http://www.percona.tv/