OSCON Day 5: Session – Benchmarking MySQL Queries

July 13, 2003

Filed under: Ozette Brown — Charles Engelke @ 6:19 pm

Why Benchmark?

what’s going to break

where will it break

does the server scale gracefully

monitor the system

Compare alternative implementations

queries

indexes, table types

application logic

Test server hardware configuration

should you add more RAM or disks

is Raid 10 faster than Raid 5

will dual CPU’s help

Useful Tools

MySQL-Bench

super-smack

mybench

URLS

My Comments

Jeremy Zawodny has a book coming out by O’reilly called “Advanced MySQL”. This will be a must have.

Comments Off