Archive for the 'wal' Category

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)

Posted in database, databases, dba, innodb, internals, log, mysql, programming, redo, shortcut:mysql, translation, wal | Comments Off | permalink

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

Friday, May 6th, 2011

Posted in database, databases, dba, innodb, internals, log, mysql, programming, redo, shortcut:mysql, translation, wal | Comments Off | permalink

Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration

Wednesday, February 10th, 2010

improvements to PostgreSQL that could be made by tuning wal/background writer processes

Posted in background, buffers, database, dba, LRU, optimization, performance, postgres, postgresql, reference, tuning, wal | Comments Off | permalink

Tuning PostgreSQL WAL Synchronization

Tuesday, February 9th, 2010

Notes about PostgreSQL WAL synchronizations methods

Posted in database, dba, disk, filesystem, performance, postgres, postgresql, tuning, wal | Comments Off | permalink

WAL Configuration

Tuesday, February 9th, 2010

Notes about Write-Ahead Log, Check points and other IO configuration related to postgresql transaction log settings

Posted in dba, performance, pg_xlog, postgres, postgresql, tuning, wal | Comments Off | permalink