—

---

MySQL Performance Tuning Key

See also .

This document is still under construction! Thus it is still a little chaotic. Please feel free to mail recommendations, suggestions, etc. to .

This key should give you a guide how to best tune you MySQL database systematically... It should also work similar for other RDBMS.

Caution: Some recommendations are dangerous! Dangerous means you can loose or get inconsistent data in certain cases. Only use them if you know what you are doing!!!

Acknowledgment

Thanks to the following people for hints:

• Jens Bollmann

Start

Before start tuning think about the following graph:

Efficiency of Performance Tuning measurements

And see also

000. Do you have performance problems?

• Yes: -->
• No: --> Do not tune your system it only can get worse! -->