Tweaking/Optimizing MySQL

I am looking to make sure I have MySQL optimized on one of my servers. I have about 60 sites on the server, a few of them have somewhat busy forums.

The server is a Dual Opteron 242, 2GB RAM and SCSI hard drives.
So if I optimize things, like MySQL I should be good to go. The server load does go up on occasion, sometime 3+ or even 4+ but will then settle back down to 1+ or even below 1 in less busy times. I have seen a spike over 5+

My /etc/my.cnf looks a little bare...could I benefit from some cache here or limiting connections, etc. ? Also, when I compiled Apache, should I also be selecting "use system mysql" if Mysql 4+ is installed?

Here's my my.cnf :

[mysqld]
set-variable = max connections=1000 (had this at 500 but go too many mysql connections error once)
safe-show-database

Any help or suggestions would be appreciated

 

 

 

 

Top