Tuning MySQL sometimes is no easy thing to do. This is where the MySQL Performance Tuning Primer Script comes into the game.

This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..." to produce sane recomendations for tuning server variables. It is compatable with all versions of MySQL 3.23 and higher (including 5.1).

However, the problem with this script is that it is not only bash'ified (it uses colors), but also doesn't fully work with OpenBSD.

That is what the following patch is for. It works against version 1.5-r2 of the tuning-primer script.

Patch against version 1.5-r2: tuning-primer.diff
Local copy of version 1.5-r2: tuning-primer.sh