Performance check
Using Jamroom
run mysyqltuner.pl your database sux ass
my recent run
note i am spending alot on a dedicated server
i also have tuned it over and over upgraded to mariadb from mysql
upgraded to litspeed from apache
fine tuned the database, and litespeed tweaking them for maximum performance
i would start by every 24 hours run mysqltuner.pl
edit my.cnf with the reccomenations once you got it fairly good run it every 48 hours
once it no longer shows recomendations except maye optimize tables and increase join buffers then just leave it be maybe run the tuner every few weeks to see if any more tunings possible
but
before you bother with that upgrade to a decent server you get what you pay for jamroom or hivelocity.net are both great options
if u go with hivelocity..who i use i recomend u request a special configuration
use a ssd drive for /home/
but a large sata drive for /home/yourjamroomaccountspace/public_html/data/media/
mounting a sata at that location (yourjamroomaccountspace should be replaced by the account name your jr sites under) will save u a ton of money you can get a 2 terabyte sata for like 1/4 the price of a 500 meg ssd
since media uses up your most drive space , keep it on a sata drive the site will still load very fast off the ssd