Optimize MySQL and HTTP/PHP
 

Hello,

I've running a vbulletin board for many years, last three years with the same host.
Last month i was thinking in expand my boards to get international support (started with vbet to check how it goes).

Because of this, i decided to upgrade my VPS to get more resources and to avoid downtime.
Since then, i'm getting daily problems: first was apache going down every 10 minutes (got a cron running every minute to check httpd), so i got it fixed.
Now i have MySQL problems:

My forum stats: 100k visitors per month / 500k pageviews per month
(About 70k threads / 200k posts and 40k members

Its a non-sense, because i never had problems with my server, and now, after upgrade, i'm getting tons of probs!!

Maybe there is something not well configured. Can anyone please tell me how to optimize database and server/vb config?

If this can't be solved, i will move up to another server....

Please help.
Thanks !

You should post over on vbulletin.com in the Server Configuration forum. At the top of the forum is a post which tells you all the information George will need to see in order to help you. Please read that and follow the instructions in there.