MySQLTuner is an awesome perl script for scaling / tuning MySQL. If you run MySQL on a production box, you need to check this out right now! Really great stats on a bunch of stuff you'd want to know, including recommendations for what to change.