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)

Posted in buffers, database, dba, inn, innodb, mysql, percona, performance, postgresql | Comments Off | permalink

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.

Posted in buffers, network, performance, research, sysadmin, tcp | 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