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…
Posted in architecture, checkpoint, database, dba, innodb, mysql, postgresql, programming | Comments Off | permalink
Posted in architecture, checkpoint, database, dba, innodb, mysql, postgresql, programming | Comments Off | permalink
How MySQL InnoDB implements transaction log, aka REDO (Oracle), aka WAL (PostgreSQL)
Posted in database, databases, dba, innodb, internals, log, mysql, programming, redo, shortcut:mysql, translation, wal | Comments Off | permalink
Posted in database, databases, dba, innodb, internals, log, mysql, programming, redo, shortcut:mysql, translation, wal | Comments Off | permalink
blog posts that describes how MySQL InnoDB flushes data to disk (also see bgwriter, checkpoint_* parameters in PostgreSQL)
Posted in buffers, database, dba, inn, innodb, mysql, percona, performance, postgresql | Comments Off | permalink
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
Posted in architecture, index, innodb, mysql, scalability, scaling, shard, string | Comments Off | permalink
You are currently browsing the archives for the innodb category.
Konstantin Antselovich (c) 2004-2011
powered by WordPress
Entries (RSS)
and Comments (RSS).