MySQL Database Optimization

I recently purchased a Dell Intel Dual Xeon 2.0ghz system from Rackshack. I am hosting a fairly large forum on it, but I can't seem to get it optimized.

The forum is located at www.d12world.com/board/index.php

The server definitely should be able to handle the size and activity of the forums. I tried using the my-large.cnf and my-huge.cnf

Currently it is on the my-medium.cnf (my-huge.cnf doesn't work). The system has 2GB of ram running CPanel. This server is a really heavy MySQL user. It is hosting multiple highly active MySQL databases such as:

http://forums.ffonline.com
http://www.d12world.com/board/index.php

I attached the my.cnf file I am using.

Thanks in advance for the advice!

 

 

 

 

Top