«
»

InnoDB map: bulk inserting

So, what does InnoDB do while you’re loading the data in parallel?
It looks something like this:
mediawiki profile flow
Click on image for larger (8MB) version, if you dare, have efficient browser and lots of spare RAM (7k*10k canvas). Generated by:

opreport | Gprof2Dot | dot

Tags: , ,

This entry was posted on Tuesday, May 27th, 2008 at 21:50 and is filed under mysql. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

3 Responses to “InnoDB map: bulk inserting”

  1. Evert says:
    May 28, 2008 at 01:05

    Thats awesome!

  2. Kevin Burton says:
    May 28, 2008 at 02:09

    Whaoh. I can see my house from up here!

  3. Jay Pipes says:
    May 28, 2008 at 13:55

    Looks like at least 10% of the execution time is spent in trx_undo_seg_free(). You think this is where InnoDB is swapping the currently written log buffer to disk in order to make room for more transactions? Can increasing a buffer help reduce the time spent in this function?

    -jay