Archive for the 'innodb' Category

How InnoDB performs a checkpoint at Xaprb [by Baron Schwartz {of Perconna, MySQL vendor }

Friday, May 6th, 2011

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 co…

How InnoDB performs a checkpoint at Xaprb [by Baron Schwartz {of Perconna, MySQL vendor }

Friday, May 6th, 2011

How InnoDB handles REDO logging – MySQL Performance Blog [by Ewen Fortune]

Friday, May 6th, 2011

How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)

How InnoDB handles REDO logging – MySQL Performance Blog [by Ewen Fortune]

Friday, May 6th, 2011

InnoDB Flushing: Theory and solutions – MySQL Performance Blog

Friday, April 29th, 2011

blog posts that describes how MySQL InnoDB flushes data to disk (also see bgwriter, checkpoint_* parameters in PostgreSQL)

Venu Anuganti Blog » Notes on scaling heavy concurrent writes in real time /InnoDB

Saturday, April 19th, 2008

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