Database Software Development Videos and Tutorials - MySQL, Oracle, SQL Server, NoSQL, MongoDB, PostgreSQL
 
Advanced Optimization Techniques for Really Large MySQL Queries

Advanced Optimization Techniques for Really Large MySQL Queries

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/