OpenWest 2013 - 5/2 - Rob Van Dam - Slow Query Log Analysis Using Perl (75)
Channel: OpenWest (old)
Date: 15/05/2013

The MySQL slow query log can provide a great jumping off point for finding bottlenecks in your code base. But how do you know where to start? How do you decide which queries to focus on and which to ignore? There are many reasons for a query to be slow (bad queries, poorly defined relationships, incorrect indexes, unanticipated scaling, insufficient slaves, etc). Improved analysis of the slow query log can be critical in deciding how best to approach and resolve these issues.