mysqlizer

Welcome

Welcome to the mysqlizer project page.

mysqlizer is a program that analyzes mysql binlogs. The whole program is in one file, so it's easy to try out. No messy installs.

About mysqlizer

mysqlizer takes the output of mysqlbinlog on stdin, and produces a report on stdout. Unknown lines are printed to stderr.

Requirements: Python 2.4
License: mysqlizer is available to the general public under the GPL v2.

Support

Email me

I can be contacted by email. My sourceforge account is aqk, and the MX is users.sourceforge.net.

Example Usage:

chmod +x mysqlizer
mysqlbinlog binlog.0000003 | ./mysqlizer 2> unknown.txt

Example output:

-- Events by type: --
    use:  1
    replace:  9
    insert_values:  169
    delete:  404
    begin:  777
    commit:  777
    insert:  2087
    update:  7932
    comment:  12155
    timestamp:  12155
    at:  12156
  Unknown:  8
  Total:  48622

-- Table Accesses: --
    
    nodes: 2421 (22.84%)
    updates: 3066 (28.92)
    loginsystem: 5114 (48.24%)

-- Sizes by event type: --
    use: 34 (0.00%)
    replace: 900 (0.00%)
    begin: 9324 (0.00%)
    commit: 10101 (0.00%)
    insert_values: 12506 (0.00%)
    delete: 42507 (0.01%)
    at: 180631 (0.03%)
    timestamp: 376805 (0.05%)
    insert: 942026 (0.13%)
    comment: 1189489 (0.17%)
    update: 708059567 (99.61%)
  Total:  710823890  bytes

-- Total event sizes by table: --
    nodes: 306900 (0.04%)
    updates: 2508794 (0.36%)
    loginsystem: 708008196 (99.60%)
  Total:  710823890 bytes

Help the project

As it is in its early stages, I'd appreciate feedback, as well as files containing sample unmatched events.