Archive for the 'buffers' Category

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)

Gettys: Whose house is of glasse, must not throw stones at another [LWN.net]

Tuesday, December 7th, 2010

Interesting discussion on LWN about an article describes problem with packet loss on home broadband networks due to improper buffer sizes in various network gear (routers, cable/dsl modems, switches, etc) along the route path.

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