File Library

Finding Query Problems Proactively With Query Reviews
Topic: Webinars
Owner: Sheeri Cabral
Date: 2012-08-31
Subtopic: Administration

Sheeri Cabral, PalominoDB

Wikipedia defines a code review as a “systematic examination (often as peer review) of computer source code intended to find and fix mistakes overlooked in the initial development phase, improving both the overall quality of software and the developers’ skills.”   Wouldn’t it be great to do the same thing, but for the queries run against your databases? This presentation shows you how to do exactly that!  mk-query-digest is a Maatkit tool that can digest queries (similar to the output of mysqldumpslow) in a report. This can be a one-off report, or it can be stored in MySQL for a meta-database of queries. You can use this process to systematically go through every type of query that is sent by the code and set about approving or annotating each query type. For example, I have used this system to EXPLAIN each type of query, so that queries can be optimized before they show up in the slow query log.

Download File   SCabral_2011-03-01.wmv

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database