Im Admin-Magazin 2011/06 hat es einen netten Artikel über MySQL und PostgreSQL Performance Tuning: Duell der Datenbanken: In einem Shootout messen sich MySQL und PostgreSQL

Susanne hat dabei PostgreSQL, wir MySQL betreut...

Wir haben bisher folgende Vorträge gehalten:

Basic solutions (CLI)

Those solutions are run from the command line (CLI):

• top (man)
• vmstat (man)
• iostat (man), mpstat (man), pidstat in package sysstat

General things about benchmarking

• RAID, bm and bonnie Benchmarks
• xCAT HPC Benchmark HOWTO (WIP)
• Speeding up Linux Using hdparm

General benchmarks

• bm

Disk benchmarking

• Filesystem Benchmark: IOzone
• Bonnie
• Harddisk-Benchmark: Bonnie++
• [http://www.

Transaction performance relates among other things from I/O performance. This means hard disk performance.

Hard disk performance

When you select a hard disk, an important feature to consider is the performance (speed) of the drive. Hard disks come in a wide range of performance capabilities. As is true of many things, one of the best indicators of a drive’s relative performance is its price. An old saying from the automobile-racing industry is appropriate here: "Speed costs money.