Tag Archives: code

InnoDB subsystems in color

Posted on 2011/07/10 by

I tried to put every subdirectory of InnoDB codebase into a chart that would explain some of relations between subsystems and modules inside the source. This is what I got (click to enlarge): Update: Check Vadim’s diagram for a more … Continue reading →

Posted in mysql | Tagged , , | 5 Comments

pmysql (multi-server mysql client)

Posted on 2010/08/12 by

To have more visibility of our systems I needed a method to quickly query large sets of MySQL servers. Though there are few methods like ‘xargs -P’ and dsh, they are overkill for the SQL-only job, and simply not fast … Continue reading →

Posted in facebook, mysql | Tagged , , | 21 Comments

INSERT speed, paramy, auto-inc

Posted on 2008/05/26 by

One of first things I noticed, when I tried to run some 5.0 tests, was that INSERT speed was much slower (no benchmarking at that time, purely subjective speed that loading the dump was somewhat too slow). After discussing at … Continue reading →

Posted in mysql | Tagged , , , , | 8 Comments