MySQL Performance Tips
Server Tuning
Read and understand SHOW STATUS output
Bytes in/out per second
Queries per second
Active vs. idle vs. max connections
Understand critical resources
Memory
CPU
Disk I/O
Customize your configuration file
Defaults are very conservative!
Copyright 2003, Jeremy Zawodny