Innodb

http://www.xaprb.com/blog/2011/01/29/how-innodb-performs-a-checkpoint/

http://www.xaprb.com/blog/2011/01/29/how-innodb-performs-a-checkpoint/ An article about MySQL InnoDB checkpoint-ing mechanism written by Perconna folks. Read comments as well, several PostgreSQL core committers have participated in the discussion. “InnoDB’s checkpoint algorithm is not well documented. It is too complex to explain in even a long blog post, because to understand checkpoints, you need to understand a lot of other things that InnoDB does. I hope that explaining how InnoDB does checkpoints in high-level terms, with simplifications, will be helpful. A lot of the simplifications are because I do not want to explain the complexities of how the simple rules can be tweaked for optimization purposes, while not violating the ACID guarantees they enforce.” ...

http://www.mysqlperformanceblog.com/2011/02/03/how-innodb-handles-redo-logging/

http://www.mysqlperformanceblog.com/2011/02/03/how-innodb-handles-redo-logging/ How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)

http://www.mysqlperformanceblog.com/2011/04/04/innodb-flushing-theory-and-solutions/ blog posts that describes how MySQL InnoDB flushes data to disk (also see bgwriter, checkpoint_* parameters in PostgreSQL)

http://venublog.com/2008/04/17/notes-on-scaling-heavy-concurrent-writes-in-real-time/ notes about how to scale innodb writes. to summ it up: shard, use int as PKEY (convert hash to int using base-convert, batch lots of write into one trx. / nothing special