This is my first attempt at creating a plugin for MySQL Workbench. As a first step, I’ve created a plugin that summarizes the slow query log if it’s output to the slow_log table, which is an option available in MySQL version 5.1 or newer. It’s similar to the mysqldumpslow perl script, except that it doesn’t require perl, which should be more convenient on Windows. In my next update, the plugin will provide the same summary statistics for the slow query log file on disk.
While the slow query log reports query time, lock time, rows sent and rows examined for each query; it’s often useful to group and aggregate similar queries for analysis. For example, here’s a sample of the plugin output, which is sorted by count, after just a few clicks on a drupal6 site:[Read more...]