rosend511

My database is 300 mb in size, mostly half being a giant member table, other half being a giant post table for SMF. My old host says there are so many tables and rows, but because its an already made forum software, I don't know how to fix. How to fix?

I now use a VPS with low specs, but while watching the stats, it uses at most 25% all day. But at random points, it goes to a CPU load of 40, which is outrageous. It's just a giant spike that makes the server overload. Each and every time, the host says to me it has to do with the MySQL. How to fix or find out?

Currently, I have a Download/Filesystem used with SimpleMachines Forum (SMF). Due to my giant 300mb, 300,000 member MySQL database, my website at time uses a Crazy amount of CPU processes (was told from 20-27 virtual cores), therefor, all the hosts I have used will shut me down. (I don't blame them) Either, how to fix, as my SMF forum is not needed anymore, but my filesystem is. The problem is I have a directory on another server that host all my 36gb of files and can handle the bandwidth. My problem with giving people direct access to the directory to eliminate the MySQL problem, is that there will be not download restrictions that my SMF 3rd party Download system has in place to limit the number of user downloads at one time, per day, etc. What is a solution?