Slow DB performance (timeouts and http 500 errors) 2.0 rc3

[gh0stw4lk3r]

our forum has grown to a 500.000 posts with 10.000 pageviews a day.
we are on a shared host with very few options to tweak the database. resulting in a website that is sometimes unreachable when someone is trying to search the forum.
i can't even create a fulltext or custom index to search because the DB will overload
does anyone have any idea what we can do to make our forum more responsive?

status.php:

http://www.fzrclub.nl/smf/status.php

if nothing can be done to optimize our forum i shall have to move to a new host..

[kat]

i shall have to move to a new host..

That's your best option, by far. 

[gh0stw4lk3r]

well, after disabling the "related topics" mod, the execution time for queries went down by seconds....
stupid that i never thought of that before...

[Adish - (F.L.A.M.E.R)]

You seem to be hitting the Max CPU usage set by your host. This is when 500 internal server errors start to come up randomly. I see you have disabled related topics mod. It will certainly help as every topic you view, it executes a command causing the db to slow down.