I just optimized my MySQL server (mysql Ver 14.12 Distrib 5.0.51a, for redhat-linux-gnu (x86_64) using readline 5.0 ). I was using mysqltuner.pl and tuning-primer.sh to optimize. It can be download in the following links below.
[[email protected] src]# ./tuning-primer.sh — MYSQL PERFORMANCE TUNING PRIMER — – By: Matthew Montgomery – MySQL Version 5.0.88-community-log i686 Uptime = 22 days 18 hrs 12 min 36 sec Avg. qps = 14 Total Questions = 28279137 Threads Connected = 4