Home / server / Questions / 162110
Accepted
scetoaux
Asked: 2010-07-21 00:21:45 +0800 CST

MySQL binlog analyzing and reporting tool

  • 772

One of the databases I maintain has recently increased its write load by 2x.

In order to find out what insert/update statements are causing that load increase, I'm looking for a tool to report and analyze mysql binlog files.

I've looked at Maatkit, which is a superb toolkit for many tasks, but it does only work with slow and general logs.

Before start reinventing the wheel, is there any tool/s (pereferibly opensource) that can help me with this?

Thanks in advance.

performance mysql maatkit

2 Answers

  1. Best Answer

    Actually Maatkit's mk-query-digest understands binary log format input too. Daniel Nichter wrote mysqlsla, and subsequently wrote the binary log parser for mk-query-digest. I think I can speak for him and say "use mk-query-digest, it is much more powerful." Try this:

    mk-query-digest --type binlog /path/to/file [other options if desired]

    • 7

  2. check out mysqlsla. one of it's nice features: 'canonizing' of requests from:

    select a,b,c from talbeName where x=123 and y=23;

    to form:

    select a,b,c from talbeName where x=? and y=?;

    so you can easily get breakdown on query types.

    • 1