MySQL Excessive Usage


I've had previous problems with excessive CPU usage on my VPS before now, and I finally discovered this was down to the installation of the Black Pod theme, Since removing that things have been fine.

However, I now have excessive MySQL usage on my VPS. My hosting have said that they've cleaned it up a little, but that I should look into this.

I have over 1400 users, use of galleries and video embedding. I also have a forum and WP installed. I don't have hundreds of plugins installed.

In the evenings I have approximately 10 - 20 members on the site at one time.

Is this simply a case of needing a dedicated server, or is there something I can do with MySQL to stop these affects on the server?


Any help appreciated.