SQL overloads CPU, pages load like molasses or time out

I'm using phplist and Mambo / Joomla CMS for my sites.

Transfered to a new VPS recently with the following specs:

LINUX CPANEL

Fedora Core 2
Equal share CPU
1GB Burst RAM
256MB RAM guaranteed
10GB Disk Space
150GB Monthly Transfer
2 IP numbers
Power Panel
cPanel/WHM (latest edition)
Fantastico De-Luxe
Clientexec

things were fone for awhile but then everything got real slow - especially the backend phplist area - it takes forever (many minutes) for pages to load and in some instances it just times out. not goot at all! I checked the VPS via virtuozzo and CPU use is normal until i click on the phplist admin area - then it spikes (and stays) at 100% and i have the problem with the loading of pages..

You can see how slow they load on the frontend too:
http://www.npleader.com
http://www.thevipcg.com
http://www.difficultboss.com

any ideas how I can speed this up or even why this happens?

I'm really new to all of this so any help would be appreciated...

 

 

 

 

Top